Skip to main content

Google Sheets: Forms

Record, monitor, and analyse your form statistics and responses using Google Sheets.

Gareth Burroughes avatar
Written by Gareth Burroughes
Updated this week

Automatically populate your Google sheets with your form data. The data saved to the Google sheet contains the following properties: ID, name, URL, response dates, and more.

You can select from options to update or append sheets.


Before you start

Things you need to know:

  • You must have the Integrations permission enabled.

  • Your form responses sync through to Google Sheets at hourly intervals.

  • Google Workspace APIs and the data passed within are not used to develop, improve, or train generalised/non-personalised AI and/or ML models.


1. Connect integration

  1. Go to Connect > Integrations.

  2. In the left menu, under SHOW, select Self-serve.

  3. Find Google sheets: Forms, then select +ADD.

  4. Select INSTALL


2. Connect Google Sheets to Dotdigital

  1. On Get to know the integration, read the information, then select NEXT.

  2. Either select New authentication to create a Google Sheets authentication or if you’ve already authenticated a Google account, select an existing one.

  3. Follow the Google account authentication instructions.

  4. Expand the Select what Dotdigital can access drop-down menu and select the checkbox for See, edit, create, and delete all your Google Sheets spreadsheets.

  5. Select NEXT.

If you have trouble authorising the connection, you might need to verify the action inside your Google account settings.

If you want to connect to more than one Google account select + Add another Google Sheets connection.


3. Settings

  1. For Sheet name, enter the name of the Google sheet you want to save the data to, then select NEXT.

  2. Expand the Update or append drop-down menu and choose whether to Update or Append existing rows in the Google sheet for each form.

    • Update
      Overwrites existing rows in your Google Sheet and pulls through all current responses for your forms, including historic data.

    • Append
      Creates new rows alongside any previous ones.

      • Cannot use historical data, but works from the moment it is activated.

  3. Select NEXT

  4. On the first installation, you must choose how far back to look for forms with activity. Your Google Sheet includes data for forms that have had activity within a specific period.

    To choose your time period, expand the Activity Within drop-down menu and choose either Last day, Last 7 days, Last 30 days, Last 90 days, Last year, or All time.

  5. Select NEXT.

  6. Expand the Import responses drop-down menu and select whether or not you want to import the form responses to your Google Sheet.

  7. Expand the Timezone drop-down menu, then select your time zone.

  8. Select FINISH.


Troubleshoot Google Forms

How do I find the correct Google Sheet or tab for my form responses?

After completing the integration, your Google Sheets document may include tabs for each connected form. Alternatively, each row may include a column showing the form name or ID. To locate your responses, search for the sheet, tab, or column that matches the name or details of your Dotdigital form.

Why are new responses not appearing instantly?

Responses sync to Google Sheets on an hourly basis. If you don't see your form data right away, please allow up to one hour for the latest responses to appear.

Can I sync responses from multiple forms in my account?

Yes, once set up, all published forms in your Dotdigital account will sync to your connected Google Sheet. You can use Google Sheets' filtering and search features to view data from specific forms.

How do I filter responses for a specific form in Google Sheets?

To filter responses for a particular form, use the filter options available in Google Sheets. Look for the column containing the form name or ID, then apply your filters to view or analyze responses from a specific form.

Did this answer your question?