Posts

Showing posts from January, 2019

How to Create Forms that allow File Uploads to Google Drive

Image
With File Upload Forms ( demo ) for Google Sheets, you can receive large files from anyone directly in your Google Drive. You can automatically send email confirmations to the notify the form respondent. The forms can be created inside Google Sheets using the built-in drag-n-drop form builder and the forms can CAPTCHAs, e-signature and more. A school teacher may want to build forms for students to upload assignments and the files are automatically saved to her Google Drive but in separate student folders. The HR team may want an online form where job applicants can upload their resumes in PDF or Word format. Business can build forms with eSignatures that respondents can sign on their desktops and mobile phones. Google Forms do allow file uploads but the respondents need to be signed into their Google accounts before they can upload files. File Upload Forms impose no such limitations – anyone can upload files to your Google Drive. They may not have a Google account and they’ll still

YouTube Uploader – Let Others Upload Videos to your YouTube Channel

Image
It is easy to upload videos to your own YouTube channel but there’s one limitation. Only the owner of the channel can upload videos to their YouTube account and they cannot delegate the task to someone else in the team. Google Drive has the concept of shared folders. A folder can have multiple collaborators and anyone can upload files to that folder. Wouldn’t it be useful if such a feature were available for YouTube channels as well? You maintain a single YouTube account and multiple people can upload videos to your common account without the owner having their the Google account credentials with anyone. YouTube Video Uploader for Collaboration Introducing YouTube Uploader, a simple file upload form that lets anyone upload videos to your YouTube channel from their desktop or mobile phone. The uploader doesn’t even need a Google account and they’ll still be able to upload video files of any size to your YouTube channel. Before we get into the implementation details, open this live

How to Monitor your Website’s Uptime with Google Sheets

Image
Would you like to receive instant email alerts as soon as your website goes down or is inaccessible to users? Most  website monitoring services  follow the “freemium” model – they have free plans for basic downtime and uptime monitoring of a website but you need to pay for unlimited email or SMS alerts. You may also need to upgrade to monitor multiple websites. There’s a good alternate though. Make your own Website Uptime Monitor with Google Sheets and Gmail You can create your own website monitor that runs on Google servers and sends email alerts via Gmail when your website goes down or is back up and accessible again. The website monitor logs all events in a Google Spreadsheet or you can even choose to record store the uptime and downtime activity inside Google Analytics. How to Setup Website Monitor Here’s how you quickly configure Google Sheets to monitor the uptime /downtime of any public website. The setup has to be done just once and the Google Apps Script attached to the G