■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
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
When a row is added
When a row is updated
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
Add Column
Delete 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)