Constant Contact + Google Sheets

Add contacts from Google Sheet rows to Constant Contact

When this happens
Step 1: New or Updated Spreadsheet Row (Team Drive)
Then do this
Step 2: Create Contact

Are you keeping lead details in a spreadsheet? Need an easy way to transfer them to your CRM? Try this automation. Each time a row appears or gets updated in your Google sheet, we'll create a contact on Constant Contact . With this process in place, you'll be able to manage your prospects in a systematic and structured way.

Try this template

Supported triggers and actions

What does this mean?

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
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger
Instant
New Spreadsheet
Triggered when you create a new spreadsheet.
Trigger
Scheduled
New or Updated Spreadsheet Row (Team Drive)
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
Trigger
Instant

New Worksheet
Triggered when you create a new worksheet in a spreadsheet.
Trigger
Scheduled
Create Spreadsheet Column
Create a new column in a specific spreadsheet.
Action
Write

Create Spreadsheet Row
Create a new row in a specific spreadsheet.
Action
Write

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
Constant Contact
Triggers when a new contact is added to your account.
Scheduled
Trigger
Constant Contact
Triggers when a recipient opens an email from a specified campaign.
Scheduled
Trigger
Constant Contact
Triggers when a new list is added.
Scheduled
Trigger
Constant Contact
Creates a contact on a specific list in your account.
Scheduled
Action
Constant Contact
Updates a contact in your account. Only filled will be updated.
Scheduled
Action
Constant Contact
Find Contact by email.
Scheduled
Action
Constant Contact
Find or Create Contact
Scheduled
Action