■Overview
This is a flow that adds to Microsoft Excel when an email is opened in Mailchimp.
By using Yoom, you can easily connect apps without the need for programming.
■Recommended for
1. Those who are conducting email marketing using Mailchimp
・Those who send campaign emails using Mailchimp but find it cumbersome to manually record the open status in another tool
・Those who want to manage open data quickly and accurately to aid their marketing strategy
2. Those who use Microsoft Excel regularly in their work
・Those who manage and analyze data using Excel and want to efficiently import data from external services
・Those who want to reduce errors and time wasted from manual data entry and improve work efficiency
■Benefits of using this template
By adding to Microsoft Excel when an email is opened in Mailchimp, you can quickly check the open status.
This allows you to promptly grasp the results of email marketing and formulate effective strategies.
By following up at the right time, you can strengthen relationships with customers and expect business growth.
Additionally, automating the process saves effort and improves work efficiency.
Reducing manual data entry decreases the risk of input errors, enabling more accurate data management.
■Notes
・Please connect both Mailchimp and Microsoft Excel with Yoom.
・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
・Please note that the shortest trigger interval varies depending on the plan.


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)
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
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)
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session