■Overview
This is a flow to store data in a Google Spreadsheet database when an email is opened in Mailchimp.
■Recommended for
1. Marketing Team
・Teams that want to measure the effectiveness of email campaigns and understand open rates
・Teams that want to analyze open data and conduct targeted marketing
2. Data Analysts
・Analysts who want to aggregate email open data in Google Spreadsheets and create detailed analyses and reports
3. Sales Team
・Teams that want to plan follow-up activities based on open data and optimize their approach to prospects
■Benefits of Using This Template
・Management and utilization of email open data are streamlined, enhancing the effectiveness of marketing and sales activities.
・Real-time data updates and centralized management enable quick decision-making and appropriate follow-ups.
■Notes
・Please integrate Mailchimp and Google Spreadsheets with Yoom.


When a row is added
When a row is updated
When an Email is Opened
When a subscriber is added (Webhook) (Deprecated)
When a Subscription is Canceled (Webhook)
When a Contact Profile is Updated (Webhook)
When an Email Address is Bounced (Webhook)
When an Email Address is Updated (Webhook)
When a campaign draft is created
When a campaign is sent
When a Subscriber Is Added
When a Contact Unsubscribes
When a Contact’s Profile Is Updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
When a row is added
When a row is updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
Insert columns
Delete columns
Write values to multiple columns
When an Email is Opened
When a subscriber is added (Webhook) (Deprecated)
When a Subscription is Canceled (Webhook)
When a Contact Profile is Updated (Webhook)
When an Email Address is Bounced (Webhook)
When an Email Address is Updated (Webhook)
When a campaign draft is created
When a campaign is sent
When a Subscriber Is Added
When a Contact Unsubscribes
When a Contact’s Profile Is Updated
Add Contact to Audience
Update Contact Information
Retrieve Contact Information
Archive Contact
Search Contact (Exact Match by Email Address)
Create Campaign
Add Content to Campaign (Plain-text Email)
Send Campaign
Get Campaign Information
Delete Registered Webhook
Search Contact (Partial Match)