Google BigQuery + Mailchimp

Google BigQuery + Mailchimp integrations

Create rows in Google BigQuery for new or updated Mailchimp subscribers

Effortlessly keep your subscriber data up-to-date across different platforms with this workflow. Once set up, each time there's a new or updated subscriber in Mailchimp, it generates a new row in Google BigQuery. This way, you can efficiently track and manage your subscribers, offering a seamless data management approach for your marketing initiatives.

When this happens...
New or Updated SubscriberTriggers when a subscriber is added or updated in an audience.
TriggerInstant
automatically do this!
Create RowCreates a new row of data in a table. Note: Does not create a job.
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 Mailchimp and Google BigQuery

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

- 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
  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
- 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
- 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

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