How to Automatically Copy Google Forms Responses to any other Spreadsheet

To automatically copy Google Forms responses to another spreadsheet, you can use Google Apps Script, which allows you to automate tasks within Google Workspace (formerly G Suite). Here's a step-by-step guide:

1. Create your Google Form:

• Go to Google Forms and create the form you want respondents to fill out.

2. Set up the destination spreadsheet:

• Create a new Google Spreadsheet where you want to copy the responses.

3. Open the Script Editor:

• In the destination spreadsheet, go to "Extensions" > "Apps Script".

4. Write the Script:

• In the Apps Script editor, write a script to copy form responses. Below is a sample script you can use:

function onFormSubmit(e) {

  var responses = e.namedValues;

  var sheet = SpreadsheetApp.openById('YOUR_DESTINATION_SPREADSHEET_ID').getActiveSheet();

  sheet.appendRow(Object.values(responses));

}

• Replace 'YOUR_DESTINATION_SPREADSHEET_ID' with the ID of your destination spreadsheet. You can find this ID in the URL of your spreadsheet.

1. Set up the trigger:

• In the Apps Script editor, click on the clock icon (triggers).
• Click on "+ Add Trigger" on the bottom right.
• Choose onFormSubmit as the function to run.
• Choose From form as the event source.
• Click Save.

2. Authorize the Script:

• When you first run the script, Google will ask for authorization. Review the permissions and authorize the script.

3. Test:

• Submit a response through your Google Form and check if it's copied to the destination spreadsheet.

4. Deployment:

• After testing, you may need to deploy the script as a web app for it to run automatically. You can do this by going to "Publish" > "Deploy as web app" and following the prompts.

That's it! Now, whenever someone submits a response to your Google Form, it will automatically be copied to the specified spreadsheet. Make sure your Google Form is set to collect responses in a Google Spreadsheet.