Google Sheets: Contacts

Record, monitor, and analyse how many contacts were in your lists and segments using Google Sheets.

Gareth Burroughes avatar
Written by Gareth Burroughes
Updated this week

With the Dotdigital contacts integrations with Google Sheets, you can automatically populate your Google sheets with the latest list and segmentation data.

The data saved to the Google sheet contains the following properties: id, type, contact count, and name.

You can select from options to create a new sheet per day or update an existing sheet, and to either update the existing list and segmentation stats with the latest data or append to the data set.

Before you start

Things you need to know:

1. Connect integration

  1. Go to Connect > Integrations.

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

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

  4. Select INSTALL.

2. Connect Google Sheets to Dotdigital

  1. Select + Connect your Google Sheets and enter your Google email address and login credentials.

  2. 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.

  3. Select Continue, Ok, and Next to proceed.

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. Manage your settings

  1. Expand the Single, Daily or Every 30 days spreadsheet drop-down menu and choose Single Sheet, Daily Sheet. or Every 30 Days.

  2. For Name of spreadsheet, enter the name of the sheet to save the data to.

  3. Select Next.

  4. Expand the Update or append rows drop-down menu and choose Update, Append daily or Append every 30 days.

  5. Select Next.

  6. Expand the Timezone drop-down menu and choose your timezone.

  7. Select Next.

  8. The integration is connected, and data is pushed to your Google Sheets. Select Home to go back to the Integrations area. Google Sheets: Contacts can now be accessed from your Google drive.

Did this answer your question?