Connect Google Sheets and Mailchimp

Event lists, shop customers and partner leads often sit in Google Sheets before anyone mails them. FlowMattic adds those rows to your Mailchimp audience, tags members from a column and writes subscriber changes back to the sheet. It suits small marketing teams who manage lists in a spreadsheet but send from Mailchimp, with the workflow on their WordPress site.

Try FlowMattic free See example workflows

12 triggers 35 actions 6 example workflows 3 ready-made templates Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in Mailchimp16 actions

1. TriggerNew Spreadsheet Row

2. ActionAdd New Member

When Google Sheets fires New Spreadsheet Row, FlowMattic runs Add New Member in Mailchimp with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Google Sheets and Mailchimp workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Add each new row to your Mailchimp audience

Rows added by event staff, a partner or another tool are added as Mailchimp members with their merge fields, so no CSV import is needed.

New Spreadsheet RowAdd New Member

Log every new Mailchimp subscriber in a sheet

A row per subscriber with email, name and date gives you a growth log you can chart and share with people outside Mailchimp.

New SubscriberAdd New Row

Mark the row when someone unsubscribes

Find the person's row by email and set a status column to unsubscribed, so a sales or event sheet does not mail them again by hand.

New UnsubscriberLookup Row DataUpdate Row

Tag members by typing in a column

Write Attended or VIP in a Tag column and the matching tag is added to that member in Mailchimp, ready for a segment or journey.

Update Specific Column ValueAdd Member Tag

Keep the sheet's email current when a subscriber changes it

When a subscriber updates their address in Mailchimp, look up the old email in the sheet and replace it, so the two lists still match.

Email Address ChangesLookup Row DataUpdate Cell Data

Process removal requests from a sheet

Privacy and removal requests logged in a sheet remove the member from the audience, giving you one place to record what was done.

New Spreadsheet RowDelete List Member

Set up: new rows added to Mailchimp

By the end, each row added to your sheet is added to your Mailchimp audience as a member.

Check the sheet
Make sure the sheet has Email, First name and Last name columns, plus any merge fields you use.
Connect Google Sheets and Mailchimp
Under Connects in FlowMattic, add both connections with accounts that can edit the sheet and the audience.
Trigger on new rows
Create a workflow with New Spreadsheet Row, choose the spreadsheet and tab, and add a test row with your own email.
Add the member
Add Mailchimp Add New Member, pick the audience, map the email and merge fields, test the step and switch the workflow on.

From Google Sheets	To Mailchimp
Email	Email address
First name	FNAME merge field
Last name	LNAME merge field
Phone	PHONE merge field

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

Only add people who agreed to hear from you. Keep a consent column and add a Filter before Add New Member if the sheet mixes contacts.
Add Member Tag and Add Member Note work on existing members, so add the person first if they may not be in the audience yet.
Merge field names such as FNAME come from your Mailchimp audience settings, so the mapping above is an example.
New Campaign can also start a workflow, for example to add a row to a sheet of sent campaigns.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Mailchimp

Integration page

Triggers (6)

New SubscriberTriggers when a new subscriber is added
New UnsubscriberTriggers when any current subscriber unsubscribes
Profile UpdatesTriggers when a profile updated
Cleaned EmailsTrigger when emails cleaned
Email Address ChangesTrigger when email address changes
New CampaignTriggers when a new campaign is created or sent

Actions (16)

Add New MemberAdd a new member to the list
Add Member TagAdd a new tag to the existing member. New tags will be added if they are not exist.
Remove Member TagRemove a tag from the list member.
Add Member NoteAdd a new note to the existing member.
Delete List MemberRemove a member from the audience list.
Update MemberUpdate an existing member. Fails if the member does not already exist on the list.
Find MemberLook up a member by email and return their full record
Archive MemberArchive a member from the audience list. Their data is kept but they no longer count toward the list size. Reversible (unlike Delete List Member).
Add Member EventRecord a custom event for a member. Useful for triggering customer-journey automations
Add Member to SegmentAdd an existing member to a static segment
Remove Member from SegmentRemove a member from a static segment
Get All MembersFetch a page of members from the audience list
Send CampaignSend an existing campaign by ID
Create CampaignCreate a new regular campaign for an audience list
Create AudienceCreate a new audience list
Make API CallSend a custom request to any Mailchimp Marketing API endpoint. Power-user escape hatch

Why run this pair with FlowMattic

Google Sheets and Mailchimp connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

No more CSV imports

Rows reach Mailchimp as they are added, so nobody exports, cleans and uploads a file before each send.

Contacts pass through your site

Emails go from Google to Mailchimp through your own WordPress server, not an outside automation account.

Long lists, same plan

Runs are unlimited, so adding thousands of rows to Mailchimp costs nothing extra in FlowMattic.

Common questions

Can I import a sheet that already has many rows?

Yes. Start with Schedule, read the rows with Get Row Data, loop with Iterator and run Add New Member for each. Run it once, then let the New Spreadsheet Row workflow handle new rows.

Can I send rows to different audiences?

Yes. Add a Router that checks a column such as Region or Brand, with an Add New Member step for each audience.

Will people who unsubscribed be added back?

Mailchimp keeps its own record of unsubscribed members. Log unsubscribes in the sheet with the New Unsubscriber trigger, and Filter those rows out of any re-import.

Can I add notes from the sheet?

Yes. Map a Notes column into Add Member Note to keep context, such as the event where you met the person, on the Mailchimp profile.

Which sheet triggers can I use?

New Spreadsheet Row, New Or Updated Spreadsheet Row, Deleted Spreadsheet Row and the cell and column triggers. Use Update Specific Column Value when only one column should start the workflow.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Google Sheets and Mailchimp

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Google Sheets integration 2.2.4, Mailchimp integration 2.1.0.