Google BigQuery + Mailchimp

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 Row
Triggers when an existing row is updated in a table in BigQuery.
TriggerPolling
automatically do this!
Add Subscriber to Tag
Triggers when a subscriber is added to a segment or tag within an audience.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write

- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

- Audience
- Status
Trigger
Polling
Try It
- Audience
- LinkRequired
- Track all links clicks
Trigger
Polling
Try It
- StoreRequired
Trigger
Polling
Try It
- Store
Trigger
Polling
Try It
- AudienceRequired
- Segment or TagRequired
Trigger
Polling
Try It
- AudienceRequired
- Email AddressRequired
Action
Write
- CampaignRequired
Action
Write
- AudienceRequired
- Tag nameRequired
Action
Write
- NameRequired
- CompanyRequired
- Address 1Required
- Address 2
- CityRequired
- StateRequired
- ZipRequired
- CountryRequired
- Phone
- Permission ReminderRequired
- Email Type OptionRequired
- From NameRequired
- From EmailRequired
- SubjectRequired
- LanguageRequired
- Notify On Subscribe
- Notify On Unsubscribe
- Double Optin
- Marketing Permissions
- Use Archive Bar
Action
Write
- AudienceRequired
- Email AddressRequired
- Deletion Info
Action
Write
- AudienceRequired
- TagRequired
- Email AddressRequired
Action
Write
- AudienceRequired
- Email AddressRequired
- NoteRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- StoreRequired
- Email AddressRequired
Action
Search
- SearchRequired
- Audience
Action
Search
- AudienceRequired
- Tag nameRequired
Action
Search or write

- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
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
- AudienceRequired
- Note About Samples
Trigger
Instant
Try It
- AudienceRequired
Trigger
Instant
Try It
- AudienceRequired
- Note About Samples
Trigger
Instant
Try It
- Campaign Name
- AudienceRequired
- Segment or Tag
- Email SubjectRequired
- Preview Text
- From NameRequired
- From Email AddressRequired
- To Name
- Content Type
Action
Write
- CampaignRequired
Action
Write
- AudienceRequired
- Email AddressRequired
- Custom Event NameRequired
- Properties
Action
Write
- AudienceRequired
- Subscriber EmailRequired
- New Email
- StatusRequired
- Double Opt-In
- Update Existing
- Replace Groups
- Groups
- Language Code
- Tag(s)
Action
Write
- AudienceRequired
- Email AddressRequired
- Delete Contact
Action
Write
- CampaignRequired
Action
Write
- AudienceRequired
- TagRequired
- Email AddressRequired
Action
Write
- NameRequired
Action
Search
- AudienceRequired
- Tag nameRequired
Action
Search
- NameRequired
- Campaign Name
- AudienceRequired
- Segment or Tag
- Email SubjectRequired
- Preview Text
- From NameRequired
- From Email AddressRequired
- To Name
- Content Type
Action
Search or write
- SearchRequired
- Audience
- AudienceRequired
- Subscriber EmailRequired
- New Email
- StatusRequired
- 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 more

Related categories

About Mailchimp

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

Learn more

Related categories

Marketing Automation

Similar apps

Related Zap Templates

Update Mailchimp subscribers when new rows are updated in Google BigQuery

Google BigQuery + Mailchimp

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

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

New Campaign

Link Clicked

New Customer

New Order

New Subscriber in Segment or Tag

Archive Subscriber

Campaign Report

Create Tag

Create Audience

Permanently Delete Member

Remove Subscriber from Tag

Add Note to Subscriber

API Request (Beta)

Find Customer

Find a Subscriber

Find or Create Tag

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

Email Opened

New Audience

New Subscriber

New Unsubscriber

New or Updated Subscriber

Create Campaign

Click Report

Create Custom Event

Add/Update Subscriber

Unsubscribe or Delete Contact

Send Campaign

Add Subscriber to Tag

Find a Campaign

Find Tag

Find or Create Campaign

Find or Create Subscriber

About Google BigQuery

Related categories

About Mailchimp

Related categories

Similar apps

AWeber

Campaign Monitor

Emma

Related Zap Templates

Related Zap Templates