Google BigQuery + Mailchimp

Google BigQuery + Mailchimp integrations

"update Mailchimp subscribers when new Google BigQuery jobs are completed with row data"

When a job is completed in Google BigQuery and it comes with row data, this workflow allows for instant updates or adds subscribers in your Mailchimp account. This automation not only saves time spent on manual data entry but ensures your Mailchimp subscriber lists are always up-to-date based on your latest Google BigQuery findings. Make your data work harder for you with this simple, streamlined process.

When this happens...
Query Job Completed (With Row Data)Triggers when a query job has completed processing successfully.
TriggerPolling
automatically do this!
Add/Update SubscriberAdd a new subscriber to an audience of your choosing. Can be used to update an existing subscriber too.
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