Using Google App Script to upload multiple files to google drive.
- Create google sheet with sheet name('responses') and with following columns: Check the sample sheet in the repository
a. timeline (description : Will auto update the record creation time).
b. name (description : name value passed from the html form).
c. email (description : email value passed from the html form).
d. contact (description : contact no value passed from the html form).
e. resume (description : Auto populated with the google drive file url;s ).
f. skillsets (description : skillsets value passed from the html form ).
g. linkedinUrl (description : linkedinUrl value passed from the html form ).
-
Go to the Sheet-> Tools -> Script Editor.
-
Copy the googleAppScripts.js code into the editor.
-
Update the constant variable (emailTo) in the googleAppScripts.js/editor with your personal email.
-
Script Editor -> Run menu -> Run Function -> setup()
-
Script Editor -> Run menu -> Run Function -> setup()
-
Select the startup function -> Script Editor -> next to debug button, select function drop down -> select doPost()
-
Script Editor -> Publish menu -> Publish as web app. a. Change the "who has access to the app" to "Anyone, even Anonymous". b. Provide required permissions. c. click on update, copy the web app url.
-
Paste the copied web app url, into the clientScript.js -> scriptUrl variable
-
Save everything and click the submit button on the form.
