How to Link Google Forms to Google Drive

Method 1: Create the Apps Script

Step 1: Open the script editor in the form

Three dots are given in the top right corner of the form. Click “More” to open the dialogue box. Select “Script editor” from the options.

Step 2: Click the untitled project on the top

Click the untitled project name at the top of the window.Rename the project to “Upload files to Drive”.

Step 3: Create another file in the Apps Script     

This step is optional, both code sections can be placed in the same script file. If you prefer separation, follow these steps:

• Click on “File” in the menu bar.
• Select “New” and then “Script file”.
• Name the new file “Setup”.

Step 4: Replace the last content with the given one

Replace the content of both script files with the following content:

// Replace “Form Name” with the ID of your form.

var form = FormApp.openById(‘YOUR_FORM_ID’);

var folderId = ‘YOUR_FOLDER_ID’; // Replace with the ID of the folder in Google Drive where you want to store the files.

// This function is triggered every time the form is submitted.

function onFormSubmit(e) {

var responses = e.response.getItemResponses();

// Loop through each form response.

for (var i = 0; i < responses.length; i++) {

var response = responses[i];

// Check if the response is a file upload question.

if (response.getItem().getType() == FormApp.ItemType.FILE_UPLOAD) {

var fileBlob = response.getResponse(); // Get the uploaded file.

var folder = DriveApp.getFolderById(folderId);

var fileName = response.getItem().getTitle(); // Use the question title as the filename.

folder.createFile(fileBlob).setName(fileName); // Save the file to Google Drive.

}

}

}

Method 2: Run The Script

Get the Form and Folder IDs. To run the script, here are the steps:-

Step 1: Replace form ID

Replace ‘YOUR_FORM_ID’ with the ID of your Google Form. You can find this ID in the URL of the form.

Step 2: Replace folder ID

Replace ‘YOUR_FOLDER_ID’ with the ID of the folder in your Google Drive where you want to store the files. If you don’t have the ID, you can get it from the URL when you’re in the folder.

Step 3: Save Script

Save the script.

Step 4: Click triggers

Click on the clock icon (Triggers) in the script editor toolbar.

Step 5: Set up a trigger

Set up a trigger to run the ‘On Form Submit’ function every time the form is submitted.

Google Forms is a free service that lets you create surveys, quizzes, and more. Google Drive is cloud storage for your files. By combining these two, you can easily collect files from respondents.

This article will guide you on uploading files to Google Drive from Google Forms. You’ll learn how to create a form with a file upload question and automatically store the uploaded files in your Drive.