Constant Contact + Google BigQuery

Constant Contact + Google BigQuery integrations

Create contacts in Constant Contact for new rows in Google BigQuery

Establish a seamless interaction between Google BigQuery and Constant Contact with this automation. Whenever a new row pops up in your Google BigQuery, this workflow swiftly creates a new contact in your Constant Contact application. A perfect solution to save time, reduce errors, and ensure your contacts are always up-to-date with your latest BigQuery data.

When this happens...
New RowTriggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.
TriggerPolling
automatically do this!
Create ContactTriggers when a new contact is added to your account.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google BigQuery and Constant Contact

Discover other triggers and actions you can use with Google BigQuery and Constant Contact

- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write

- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

New Contact
Triggers when a new contact is added to your account.
Trigger
Polling
Try It
New List
Triggers when a new list is added.
Trigger
Polling
Try It
- Contact ID
  Required
- List
  Required
Action
Write
- Contact ID
  Required
- List
  Required
Action
Write
- Contact ID
  Required
- Update Source
  Required
- Email
  Required
- List
- First Name
- Middle Name
- Last Name
- Job Title
- Company Name
- Max 2 Phone Numbers
- Home Phone
- Work Phone
- Cell Phone
- Other - Phone Number
- SMS Terms & Conditions
- SMS Phone Number
- SMS Consent Type
- Anniversary
- Birthday Month
- Birthday Day
- Address Requirements
- Address Type
- Street Address
- City
- State
- Zip or Postal Code
- Country
- Tags
Action
Write
- Email
  Required
- Status
- DeletedContactWarning
Action
Search

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write
- Campaign
  Required
- Campaign Activity
  Required
Trigger
Polling
Try It
New Unsubscriber
Triggers when a contact Unsubscribes (Email Unsubscribed).
Trigger
Polling
Try It
- Create Source
  Required
- Email
  Required
- List
- First Name
- Middle Name
- Last Name
- Job Title
- Company Name
- Max 2 Phone Numbers
- Home Phone
- Work Phone
- Cell Phone
- Other - Phone Number
- SMS Terms & Conditions
- SMS Phone Number
- SMS Consent Type
- Anniversary
- Birthday Month
- Birthday Day
- Address Requirements
- Address Type
- Street Address
- City
- State
- Zip or Postal Code
- Country
- Tags
Action
Write
- Contact ID
  Required
- Tags
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Email
  Required
- Status
- DeletedContactWarning
- Create Source
  Required
- List
- First Name
- Middle Name
- Last Name
- Job Title
- Company Name
- Max 2 Phone Numbers
- Home Phone
- Work Phone
- Cell Phone
- Other - Phone Number
- SMS Terms & Conditions
- SMS Phone Number
- SMS Consent Type
- Anniversary
- Birthday Month
- Birthday Day
- Address Requirements
- Address Type
- Street Address
- City
- State
- Zip or Postal Code
- Country
- Tags
Action
Search or write

About Constant Contact

Constant Contact can help grow your business with an email marketing tool that’s affordable, powerful, and easy to use.

Learn moreLearn moreHelpHelp

Related categories

Email Newsletters

Similar apps

Mailchimp

Marketing Automation

AWeber

Email Newsletters

Campaign Monitor

Email Newsletters

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium