Google BigQuery + Mailchimp

Create rows in Google BigQuery for new campaigns in Mailchimp

Boost your data analysis process with this convenient automation. When you launch a new campaign in Mailchimp, this workflow instantly creates a row in Google BigQuery. This gives you a quick, efficient way to expand your data sets without extra manual work. Perfect for businesses looking to streamline their marketing data collection and analytics.

When this happens...
New Campaign
Triggers when a new campaign is created or sent.
TriggerPolling
automatically do this!
Create Row
Creates a new row of data in a table. Note: Does not create a job.
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

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

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

Create rows in Google BigQuery for new campaigns in Mailchimp

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

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

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

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

About Google BigQuery

Related categories

About Mailchimp

Related categories

Similar apps

AWeber

Campaign Monitor

Emma

Related Zap Templates

Related Zap Templates