Constant Contact + Google Sheets

Automatically Add New Constant Contact Contacts to a Google Spreadsheet

When this happens
Step 1: New Contact
Then do this
Step 2: Create Spreadsheet Row

If you want to easily keep track of all of your Constant Contact contacts in a Google spreadsheet, Zapier can help. This Constant Contact and Google Docs Spreadsheet integration will take any new Constant Contact subscriber and add them to a Google Sheets Spreadsheet of your choosing.

How it Works

You add a new contact in Constant Contact
Zapier sends that person's information to a Google Sheet you choose

What You Need

A Constant Contact account with at least one mailing list
A Google Spreadsheet for the data
At least one row of data, as well as a row of headings, in the Google Spreadsheet

Try this template

Supported triggers and actions

What does this mean?

New Contact
Triggers when a new contact is added to your account.
Trigger
Scheduled
New Email Open
Triggers when a recipient opens an email from a specified campaign.
Trigger
Scheduled
New List
Triggers when a new list is added.
Trigger
Scheduled
Create Contact
Creates a contact on a specific list in your account.
Action
Write
Update Contact
Updates a contact in your account. Only filled will be updated.
Action
Write

Find Contact
Find Contact by email.
Action
Search
Find or Create Contact
Find or Create Contact
Action
Search or write

New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Trigger
Scheduled

Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action