Microsoft Excel + Mailchimp

Track opened Mailchimp emails by adding rows in Microsoft Excel

Stay on top of your email engagement with this easy-to-use workflow. When someone opens an email from your Mailchimp campaign, a new row will be added to a Microsoft Excel spreadsheet, so you can quickly track and analyze your email open rates. This seamless automation helps you monitor your email performance, giving you valuable insights for future campaigns.

When this happens...
Email Opened
Triggers when a recipient opens an email in a specific campaign.
TriggerScheduled
automatically do this!
Add Row
Adds a new row to the end of a worksheet.
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
Scheduled
Try It
- Audience
- LinkRequired
- Track all links clicks
Trigger
Scheduled
Try It
- StoreRequired
Trigger
Scheduled
Try It
- Store
Trigger
Scheduled
Try It
- AudienceRequired
- Segment or TagRequired
Trigger
Scheduled
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
- 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
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

- Audience
- Trigger each time a subscriber opens an email
Trigger
Scheduled
Try It
New Audience
Triggers when a new audience is added to your MailChimp accounts.
Trigger
Scheduled
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
- TagRequired
- Email AddressRequired
Action
Write
- AudienceRequired
- Email AddressRequired
- NoteRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- StoreRequired
- Email AddressRequired
Action
Search
- SearchRequired
- Audience
Action
Search
- AudienceRequired
- Tag nameRequired
Action
Search or write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Related categories

Similar apps

About Mailchimp

Share your ideas with Mailchimp email newsletters—then use its landing page and form builders to grow your lists and take marketing further with drip and transactional emails.

Learn more

Related categories

Email Newsletters

Microsoft Excel + Mailchimp

Track opened Mailchimp emails by adding rows in Microsoft Excel

New Campaign

Link Clicked

New Customer

New Order

New Subscriber in Segment or Tag

Archive Subscriber

Campaign Report

Create Tag

Create Audience

Unsubscribe or Delete Contact action

Send Campaign

Add Subscriber to Tag

Find a Campaign

Find Tag

Find or Create Campaign

Find or Create Subscriber

New Row in Table

Updated Row

Add Row(s)

Create Spreadsheet

Find Row

Find or Create Row

Email Opened

New Audience

New Subscriber

New Unsubscriber

New or Updated Subscriber

Create Campaign

Click Report

Create Custom Event

Add/Update Subscriber

Remove Subscriber from Tag

Add Note to Subscriber

API Request (Beta)

Find Customer

Find a Subscriber

Find or Create Tag

New Row

New Worksheet

Add Row

Add Row to Table

Update Row

Find Row(s)

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

About Mailchimp

Related categories

Similar apps

AWeber

Campaign Monitor

Emma

Related Zap Templates

Related Zap Templates