ConditionalVisibility

new-products-promo

automate-contact-tracking-01-zap-explainer

Find a Zap quiz

Zapier tutorials

finding-lead-gen-opportunities-00-hero

Whether you're managing leads or newsletter contacts, you've worked hard to earn that contact information. How often do you sit down and analyze it? 

How to automatically keep track of your contacts for easier reporting

Nothing beats a spreadsheet if you want a comprehensive overview of all that contact or lead information. Let Zapier maintain a perfect record of your Mailchimp users, and you won't ever have to deal with exports or missing information again. Once active, this Zap reacts to every new subscriber you add to a list on Mailchimp, automatically adding them to a new row on an Excel spreadsheet for your archives.

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.

Mailchimp

Triggers when a new campaign is created or sent.

New Campaign

Triggers when a recipient opens an email in a specific campaign.

Email Opened

Triggers when a recipient clicks a pre-specified link in your campaign.

Link Clicked

Triggers when a new audience is added to your MailChimp accounts.

New Audience

Triggers when a new customer is added to a selected store.

New Customer

Triggers when a new subscriber is added to an audience.

New Subscriber

New Order

Triggers when any current subscriber unsubscribes from an audience.

New Unsubscriber

Triggers when a subscriber is added to a Tag within a List.

New Subscriber With Tag

Triggers when a subscriber is added to a segment or tag within an audience.

New Subscriber in Segment or Tag

Triggers when a subscriber is added or updated in an audience.

New or Updated Subscriber

Find a Campaign

Find Customer

Find Tag

Searches for a new subscriber on your MailChimp audience.

Find a Subscriber

Find or Create Campaign

Find or Create Tag

Find or Create Subscriber

Archive Subscriber

Create Campaign

Get report details for a specific sent campaign.

Campaign Report

Get report details for a specific link clicks.

Click Report

Create Tag

Creates a custom event for an existing subscriber.

Create Custom Event

Creates a new audience in your MailChimp account.

Create Audience

Add a new subscriber to an audience of your choosing. Can be used to update an existing subscriber too.

Add/Update Subscriber

Unsubscribe or delete a contact by email address within an audience.

Unsubscribe or Delete Contact action

Removes a subscriber by email address from a tag within an audience.

Remove Subscriber from Tag

Sends a campaign to all subscribers in an audience, segment, or tag.

Send Campaign

Adds a new note to an existing subscriber.

Add Note to Subscriber

Add an email address to a tag within an audience. Note: the email address **must already be subscribed to the audience**, or this will fail.

Add Subscriber to Tag

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

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.

Microsoft Excel

Triggers when a new row is added to a worksheet in a spreadsheet.

New Row

Triggers when a new row is added to a table in a spreadsheet.

New Row in Table

Triggers when a new worksheet is added to a spreadsheet.

New Worksheet

Triggers when a row is added or updated in a worksheet.

Updated Row

Finds a row by a column and value. Returns the entire row if one is found.

Find Row

Finds any rows that match a specific value in a given column.

Find Row(s)

Find or Create Row

Adds a new row to the end of a worksheet.

Add Row

Adds one or more rows to the end of a worksheet (with line item support).

Add Row(s)

Adds a new row to the end of a specific table.

Add Row to Table

Create Spreadsheet

Update Row

Add new Mailchimp subscribers to Excel spreadsheet rows

Backups are invaluable when there's data loss, and spreadsheets make flexible repositories. Let this ActiveCampaign-Google Sheets integration take care of all your contacts' safe-keeping from behind the scenes. Triggered with every new subscriber you add to ActiveCampaign, it will automatically send all of that data to Google Sheets, adding a new row for each one.

ActiveCampaign is a customer experience automation (CXA) platform that helps businesses meaningfully engage customers. Access pre-built automations that combine transactional email and email marketing, marketing automation, ecommerce marketing, and CRM for powerful segmentation and personalization across social, email, messaging, chat, and text.

ActiveCampaign

Triggers when a Custom Object record is created or updated.

New or Updated Custom Object Record

Triggers when a custom object record is deleted in ActiveCampaign

Custom Object Record Deleted

Triggers when a deal task has been completed.

Deal Task Completed

Triggers when a new account is added or an existing account's details are updated.

New or Updated Account

Triggers when an automation sends out webhook data. To add a webhook in ActiveCampaign, navigate to your Automations section, add or edit an automation, and create a new "Webhook" action.

New Automation Webhook

Triggers when a contact email address bounces from a sent campaign.

New Campaign Bounce

Triggers when a contact clicks a link in a campaign message (will only run once for each unique link).

New Campaign Link Click

Triggers when a contact opens a campaign (will trigger once per contact per campaign).

New Campaign Open

Triggers when a new campaign starts sending.

New Campaign Starts Sending

Triggers when a contact unsubscribes as a result of a campaign email sent to them.

New Campaign Unsubscribe

Triggers when a new contact note is added.

New Contact Note

Triggers when a new contact task is created.

New Contact Task

Triggers when a new deal note is created.

New Deal Note

Triggers when a new deal task is created.

New Deal Task

Triggers when a new deal is created or existing deal is updated.

New Deal Added or Updated

New Contact

Triggers whenever a contact is added to a list.

Contact Added to List

Triggers when an existing contact details are updated.

Updated Contact

Triggers when a new contact is created or an existing contact's details are updated.

New or Updated Contact

Triggers when a a Tag is added or removed from a Contact

Tag Added or Removed From Contact

Find Account

Finds a contact by email address, ID, or phone.

Find Contact

Find Contact Task

Finds an existing deal by title or email.

Find Deal

Looks for a Deal and if found, returns the User that owns the Deal

Find Deal Owner

Find Deal Task

Find User

Create Account

Update Account

Creates a new account or updates an existing account.

Create or Update Account

Creates a new contact, or updates an existing contact.

Create or Update Contact

Create Deal (Deprecated)

Adds an existing contact into any automation.

Add Existing Contact to Automation

The contact will be removed from this active automation

Remove Contact From Automation

Adds a contact to an ActiveCampaign account

Add Contact to Account

Add Contact Note

Add/Remove Tag From Contact

Create or Update Contact Task

Creates a new custom object record or update an existing record

Create or Update a Custom Object Record

With a deal ID and a contact ID set the corresponding contact as a secondary on the deal. Optionally set the role. If the Deal has no Primary contact set, this contact will be set as Primary if you DO NOT select a role.

Add Secondary Contact to Deal

Create Deal

Add Note to Deal

Create or Update Deal Task

Update Deal

Subscribes a Contact to a List it is not currently associated with, or Unsubscribes a Contact from a list is currently associated with.

Subscribe or Unsubscribe Contact From List

Creates a custom website or application event.

Create Tracked Event

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Google Sheets

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new spreadsheet row at the top of a spreadsheet (after the header row).

Create Spreadsheet Row at Top

Creates a new worksheet by copying an existing worksheet.

How to automatically keep track of your contacts for easier reporting

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.