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

What does this mean?

- 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
- 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
- TableRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- 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
- 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
- TitleRequired
- Column Headers
- Zap Step Id
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.

Help

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 Help

Related categories

Email Newsletters

Microsoft Excel + Mailchimp

Track opened Mailchimp emails by adding rows in Microsoft Excel

New Campaign

Audience

Status

Link Clicked

Audience

Track all links clicks

New Customer

New Order

Store

New Subscriber in Segment or Tag

Archive Subscriber

Create Tag

Create Audience

Address 2

Phone

Notify On Subscribe

Notify On Unsubscribe

Double Optin

Marketing Permissions

Use Archive Bar

Unsubscribe or Delete Contact action

Delete Contact

Send Campaign

Add Subscriber to Tag

Find a Campaign

Find Tag

Find or Create Campaign

Campaign Name

Segment or Tag

Preview Text

To Name

Content Type

Find or Create Subscriber

Audience

New Email

Double Opt-In

Update Existing

Replace Groups

Groups

Language Code

Tag(s)

New Row in Table

Storage Source

Folder

Updated Row

Storage Source

Folder

Trigger Column

Add Row to Table

Storage Source

Folder

Update Row

Storage Source

Folder

Find or Create Row

Storage Source

Folder

Email Opened

Audience

Trigger each time a subscriber opens an email

New Audience

New Subscriber

Note About Samples

New Unsubscriber

New or Updated Subscriber

Note About Samples

Create Campaign

Campaign Name

Segment or Tag

Preview Text

To Name

Content Type

Create Custom Event

Properties

Add/Update Subscriber

New Email

Double Opt-In

Update Existing