Google BigQuery + Mailchimp

Google BigQuery + Mailchimp integrations

Update Mailchimp subscribers with tagged data from updated rows in Google BigQuery

Kick your email marketing up a notch with this efficient workflow. When new updates to a row occur in Google BigQuery, the same data will be used to add a subscriber to a specific tag within your Mailchimp account. Perfect for those who wish to keep their email list updated and segmented in real-time, this automation ensures your audience is always at the receiving end of your targeted campaigns.

When this happens...
Updated RowTriggers when an existing row is updated in a table in BigQuery.
TriggerPolling
automatically do this!
Add Subscriber to TagTriggers when a subscriber is added to a segment or tag within an audience.
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 Mailchimp

Discover other triggers and actions you can use with Google BigQuery and Mailchimp

- 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

- Audience
- Status
Trigger
Polling
Try It
- Audience
- Link
  Required
- Track all links clicks
Trigger
Polling
Try It
- Store
  Required
Trigger
Polling
Try It
- Store
Trigger
Polling
Try It
- Audience
  Required
- Segment or Tag
  Required
Trigger
Polling
Try It
- Audience
  Required
- Email Address
  Required
Action
Write
- Campaign
  Required
Action
Write
- Audience
  Required
- Tag name
  Required
Action
Write
- Name
  Required
- Company
  Required
- Address1
  Required
- Address2
- City
  Required
- State
  Required
- Zip
  Required
- Country
  Required
- Phone
- Permission_reminder
  Required
- Email_type_option
  Required
- From_name
  Required
- From_email
  Required
- Subject
  Required
- Language
  Required
- Notify_on_subscribe
- Notify_on_unsubscribe
- Double_optin
- Marketing_permissions
- Use_archive_bar
Action
Write
- Audience
  Required
- Email Address
  Required
- Deletion_info
Action
Write
- Audience
  Required
- Tag
  Required
- Email Address
  Required
Action
Write
- Audience
  Required
- Email Address
  Required
- Note
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Store
  Required
- Email Address
  Required
Action
Search
- Search
  Required
- Audience
Action
Search
- Audience
  Required
- Tag name
  Required
Action
Search or write

- 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
- Audience
- Trigger each time a subscriber opens an email
Trigger
Polling
Try It
New Audience
Triggers when a new audience is added to your MailChimp accounts.
Trigger
Polling
Try It
- Audience
  Required
- Note_about_samples
Trigger
Instant
Try It
- Audience
  Required
Trigger
Instant
Try It
- Audience
  Required
- Note_about_samples
Trigger
Instant
Try It
- Campaign Name
- Audience
  Required
- Segment or Tag
- Email Subject
  Required
- Preview_text
- From_name
  Required
- From Email Address
  Required
- To_name
- Content Type
Action
Write
- Campaign
  Required
Action
Write
- Audience
  Required
- Email Address
  Required
- Custom Event Name
  Required
- Properties
Action
Write
- Audience
  Required
- Subscriber Email
  Required
- New Email
- Status
  Required
- Double Opt-In
- Update Existing
- Replace Groups
- Groups
- Language Code
- Tag(s)
Action
Write
- Audience
  Required
- Email Address
  Required
- Delete Contact
Action
Write
- Campaign
  Required
Action
Write
- Audience
  Required
- Tag
  Required
- Email Address
  Required
Action
Write
- Name
  Required
Action
Search
- Audience
  Required
- Tag name
  Required
Action
Search
- Name
  Required
- Campaign Name
- Audience
  Required
- Segment or Tag
- Email Subject
  Required
- Preview_text
- From_name
  Required
- From Email Address
  Required
- To_name
- Content Type
Action
Search or write
- Search
  Required
- Audience
- Audience
  Required
- Subscriber Email
  Required
- New Email
- Status
  Required
- Double Opt-In
- Update Existing
- Replace Groups
- Groups
- Language Code
- Tag(s)
Action
Search or write

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

About Mailchimp

Mailchimp is an email and marketing automation platform built for growing businesses. Turn email and SMS into revenue.

Learn moreLearn moreHelpHelp

Related categories

Marketing Automation

Similar apps

AWeber

Email Newsletters

Campaign Monitor

Email Newsletters

Emma

Email Newsletters

Related Zap Templates

Update Mailchimp subscribers when new rows are updated in Google BigQuery