Mailchimp
Microsoft Excel
integromat

An automated workflow using integromat

Connects Mailchimp + Microsoft Excel

Add a new Mailchimp subscriber to Microsoft 365 Excel

About this workflow template

This automation scenario allows you to connect Mailchimp and Microsoft Excel

It can be build using Integromat, a no-code workflow automation tool. Integromat allows you to create automated scripts using a simple drag-and-drop interface for non-technical users. This is a ready-made scenario, but it can be customized by adding more apps, actions, filters or branches.

Mailchimp and Microsoft Excel can also be integrated using automation tools other than integromat:

Diagram

Add a new Mailchimp subscriber to Microsoft 365 Excel
Workflow diagram: Mailchimp + Microsoft Excel integration

How it works?

When this trigger fires in Mailchimp

Mailchimp

Watch Subscribers in Mailchimp

Triggers when a new subscriber joins a list or is updated.

Then this action happens in Microsoft Excel

Microsoft Excel

Add a Worksheet Row in Microsoft Excel

Adds a new worksheet row.

How to set up this workflow

This guide contains information on how to set up an automatic workflow that allows to Add a new Mailchimp subscriber to Microsoft 365 Excel.

Part I

Configure Applications

First, we need to connect Mailchimp and Microsoft Excel to Make.com.

  • Create Make.com account.

    Create Make.com account.

    Create Make.com account if you don't have one.

  • Connect Mailchimp to Make.com.

    Connect Mailchimp to Make.com.

    Give Make.com access to your Mailchimp account, using Mailchimp credentials.

  • Connect Microsoft Excel to Make.com.

    Connect Microsoft Excel to Make.com.

    Give Make.com access to your Microsoft Excel account, using Microsoft Excel credentials.

Part II

Build an integration workflow

Next, we need to create a workflow automation scenario using graphical no-code web interface of Make.com.

  • Set up a Trigger action for Mailchimp

    Set up a Trigger action for Mailchimp

    Choose the following trigger: Watch Subscribers (Triggers when a new subscriber joins a list or is updated.).

  • Then set up an Action for Microsoft Excel

    Then set up an Action for Microsoft Excel

    Choose this action: Add a Worksheet Row (Adds a new worksheet row.).

Part III

Test and Publish

Finally, we need to test this automation and publish it.

  • Customize data flow

    Customize data flow

    Configure the data that is exchanged between Mailchimp and Microsoft Excel.

  • Test the workflow and turn it on for production use

    Test the workflow and turn it on for production use

    Test your scenario and publish to production. Now you have an automatic workflow, that will Add a new Mailchimp subscriber to Microsoft 365 Excel!

Supported triggers and actions

  • Mailchimp

    New subscriber

    Triggers when a new subscriber is added to an audience.

    zapieriftttautomateiopabbly-connect
    triggerbyzapieriftttautomateiopabbly-connect
  • Mailchimp

    New campaign

    Triggers when a new campaign is created or sent.

    zapierautomateiopabbly-connectpipedreamalbato
    triggerbyzapierautomateiopabbly-connectpipedreamalbato
  • Mailchimp

    New subscriber in segment or tag

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

    zapier
    triggerbyzapier
  • Mailchimp

    New or updated subscriber

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

    zapier
    triggerbyzapier
  • Mailchimp

    New unsubscriber

    Triggers when any current subscriber unsubscribes from an audience.

    zapierpabbly-connect
    triggerbyzapierpabbly-connect
  • Mailchimp

    New customer

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

    zapierautomateiopipedream
    triggerbyzapierautomateiopipedream
  • Microsoft Excel

    Add row

    Adds a new row to the end of a worksheet.

    zapier
    actionbyzapier
  • Microsoft Excel

    Add row to table

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

    zapierpabbly-connect
    actionbyzapierpabbly-connect
  • Microsoft Excel

    Add a worksheet row

    Adds a new worksheet row.

    integromat
    actionbyintegromat
  • Microsoft Excel

    Create spreadsheet

    Creates a new spreadsheet

    zapier
    actionbyzapier
  • Microsoft Excel

    Update row

    Updates a row in a specific worksheet.

    zapierintegrately
    actionbyzapierintegrately
  • Microsoft Excel

    Find row

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

    zapier
    actionbyzapier

Apps you need

Mailchimp

Mailchimp

Email Marketing

Email and marketing platform targeted for small Business

Mailchimp is an all-in-one marketing platform that helps you design email newsletters, automate campaigns, track results and more. Grow your business smarter, faster and easier with Mailchimp.

Microsoft Excel

Microsoft Excel

Spreadsheets

A spreadsheet tool for data management and analysis

Microsoft Excel is the industry standard for spreadsheet applications that enables data analysis, organization, and collaboration among multiple stakeholders in real-time.

Make.com

Make.com

Automation Platforms

Integromat now Make! A workflow automation service.

Make.com (Integromat) is a powerful automation tool that enables users to connect their favorite apps, services, and devices without any coding skills. With its unique features, users can automate even complex integrations easily and efficiently, saving time and effort. Integromat allows to connect apps and automate processes in a few clicks.