Learn how to automatically copy Google Form responses to Microsoft Excel or Zoho Sheet when a new form response is submitted. You can copy form responses to multiple Google Sheets.
Google Forms is a great tool for collecting data from event registration to customer feedback. By default, your Google Form responses are added to the Google Sheet linked to the form.
However, there may be scenarios where you want to store a copy of the form responses in a different location, such as a Microsoft Excel worksheet, Zoho Sheet, or multiple Google Sheets.
the problem
For this example, we have a Google Form where respondents can fill in their name, email address, city and other basic details. When a respondent submits a form, we want to store that form’s response in an Excel sheet in addition to the original Google Sheet.
Let’s see how this can be easily automated with the help of Document Studio.
Solution
Start Document Studio within Google Forms and create a new workflow. Provide a workflow name and move to Conditions page.
Let’s add some conditions here to filter form responses that we don’t want to save to an Excel sheet. For example, you can only save responses where the respondent’s city is New York or Boston. Any form response that does not meet this condition will be ignored.
Next, move on Tasks Page and add a new task. choose Copy Row From the list of available actions. Here we will choose the spreadsheet service where the Google Form responses are to be stored. You can choose from Google Sheets, Microsoft Excel, or Zoho Sheets.
Connect Microsoft Excel to Google Forms
Select Excel Sheets from the list of available spreadsheet applications, and click Link Microsoft Excel button. You will be asked to sign in to your Microsoft account and grant permissions to Document Studio to access your Excel files.
Once your Microsoft account is linked, open an Excel workbook in your browser and copy and paste the spreadsheet URL as shown in the screenshot below. If you want to copy the form response to a Zoho Sheet, you can choose Zoho Sheets from the list and link your Zoho account.
You also need to specify the name of the worksheet where the form responses should be copied. If the sheet does not exist, Document Studio will create a new sheet in Excel with the specified name.
The next section is Field Mapping where you can specify which form fields should be copied to the Excel sheet. You need to specify the corresponding column names in the Excel sheet where the form responses should be stored.
For example, if a field in your Google Form is called “Zip Code,” you can map it to the “Postal Code” column in your Excel sheet. Similarly, if the field in your Google Form is “Email”, you can map it to the “Email Address” column in your Excel sheet.
| Google Forms Field (Field Name) | Excel Column Name (Field Value) |
|---|---|
| zip code | {{ Postal Code }} |
{{ Email Address }} |
Click Save and Save your action Continue To proceed to the trigger screen. Check the Run on form submit option so that every time a new form response is submitted, the workflow will be triggered, and a new row will be added to the specified Microsoft Excel or Zoho sheet.
Related tutorials
- Copy the Google Form response to the Zoho sheet
- Duplicate Google Form Response on another Google Sheet