Google Apps Script Google Drive How to ?

Create Form to Upload Files in Google Drive

Today Google form is the most widely used web form service used for many purposes. Some of its attractive features include intuitive drag and drop interface, quick integration with Google Sheets and not to mention add-ons which even enhance its capability. Despite all these features, it misses an important one that is uploading files or in other words, keeping file inputs to receive PDF or any other documents from form submitters. This has been a widely discussed topic even in forums.

Password Manager Demo

Now in this post we will introduce you to a script which can help in uploading file with Google Form like interface. Google form uses materialize design pattern (tech geeks). We have created this HTML form using materialize css which looks exactly similar like Google Form. In addition to that it can upload files as well. It stores the submitted data in Google Spreadsheet and files in the specified folder.

Features

  • Uploads file in the form which looks similar as Google Form
  • Stores submitted data in the Google Spreadsheet
  • Saves file in the specified folder
  • Stores the links of the files in the Spreadsheet
  • Multiple files can also be uploaded

Set up

  • Go to file → Make a copy
  • A new tab will be opened → Rename the file
  • Close the original file
  • In the new file → go to Tools → Script editor
  • In the script you will find some constant variable at the top. You need to replace with your own values.
  • Go to publish → Deploy as webapp
    • Project version: new
    • Execute the app as: me
    • Who has access to the app: Anyone even anonymous 
  • Update → You will get an URL for the form