Connect MailerLite and Google Sheets

Lists rarely live in one place. Sign-ups arrive in a shared sheet from an event or a partner, and the newsletter goes out from MailerLite. FlowMattic moves people both ways: sheet rows become MailerLite subscribers in the right group, and MailerLite activity is written back as rows. It suits newsletter writers, small shops and marketing teams who report from Google Sheets.

Try FlowMattic free See example workflows

16 triggers 27 actions 7 example workflows 1 ready-made template Unlimited runs

Try a pairing

When this happens in MailerLite10 triggers

Do this in Google Sheets19 actions

1. TriggerSubscriber Added to Group

2. ActionAdd New Row

When MailerLite fires Subscriber Added to Group, FlowMattic runs Add New Row in Google Sheets with the data from that event.

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

MailerLite and Google Sheets 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.

Ready-made template

Add a row for each new subscriber in a MailerLite group

Whenever someone joins a group, their email, name and the date go into a sheet, so the people who report on list growth do not need a MailerLite login.

Subscriber Added to GroupAdd New Row

View the template

Subscribe people added to a sheet and put them in a group

Event sign-ups or partner leads collected in a sheet are created in MailerLite with Create or Update Subscriber and placed in the group that starts your welcome automation.

New Spreadsheet RowCreate or Update SubscriberAdd Subscriber to a Group

Mark unsubscribes on your master contact sheet

Lookup Row Data finds the person by email and Update Row fills in an unsubscribed date, so anyone using the sheet for other outreach knows to leave them out.

Subscriber UnsubscribedLookup Row DataUpdate Row

Save a weekly snapshot of a group to its own tab

Each Monday, Get Group Subscribers pulls the group, Create New Sheet adds a dated tab and the list is imported into it, giving you a week-by-week record of who was on it.

ScheduleGet Group SubscribersCreate New SheetImport CSV or JSON to Existing Sheet

Keep a sheet of every campaign you send

Campaign Sent writes the campaign name and send date to a log, which makes a simple content calendar and a reference for which subject lines went out when.

Campaign SentAdd New Row

Move a subscriber into the VIP group from the sheet

When someone types VIP in the status column, Fetch Subscriber finds the person in MailerLite and Add Subscriber to a Group places them in your VIP group.

Update Specific Column ValueFilterFetch SubscriberAdd Subscriber to a Group

Track spam complaints in a deliverability log

Each Spam Complaint adds a row with the address and the date, so you can spot whether one source of sign-ups is behind most of the complaints.

Spam ComplaintDate/Time FormatterAdd New Row

Set up: new group subscribers as rows

When you finish, each person added to your chosen MailerLite group appears as a new row in the sheet.

Prepare the sheet
Add a header row such as Email, Name, Group and Joined on.
Connect MailerLite and Google Sheets
In FlowMattic Connects, add your MailerLite account and a Google account that can edit the spreadsheet.
Trigger on Subscriber Added to Group
Create a workflow with MailerLite and Subscriber Added to Group, choose the group, then add a test subscriber to it.
Write the row
Add Google Sheets with Add New Row, pick the spreadsheet and tab, map the subscriber fields, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From MailerLite	To Google Sheets
Email	Email
Name	Name
Group name	Group
Date added	Joined on

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

Add Subscriber to a Group works on a subscriber who already exists, so create the person first or find them with Fetch Subscriber.
New Or Updated Spreadsheet Row fires again whenever a row is edited. For sheet-to-MailerLite workflows, New Spreadsheet Row or one watched column avoids repeat runs.
MailerLite custom fields depend on your account, so the mapping above is an example. Create the fields in MailerLite before mapping sheet columns to them.

MailerLite

Integration page

Triggers (10)

Subscriber CreatedTriggers when a new subscriber is added to an account.
Subscriber UpdatedTriggers when any of the subscriber's custom fields are updated.
Subscriber UnsubscribedTriggers when a subscriber becomes unsubscribed.
Subscriber Added to GroupTriggers when a subscriber is added to a group.
Subscriber Removed From GroupTriggers when a subscriber is removed from a group.
Subscriber Added Through FormTriggers when a subscriber is added though a form.
Subscriber BouncedTriggers when an email address bounces.
Subscriber Completed AutomationTriggers when a subscriber completed a selected workflow.
Spam ComplaintTriggers subscriber marks a campaign as a spam.
Campaign SentTriggers when a campaign has been sent out.

Actions (8)

Create New GroupCreates a new group
Create or Update SubscriberCreates a new or update existing subscriber with custom fields
Add Subscriber to a GroupAssign a existing subscriber to a existing group
Delete Subscriber From GroupUnassign a existing subscriber from an existing group
Fetch SubscriberSearch and retrieve subscriber details
Update GroupUpdate an existing group
Send CampaignSends a new campaign
Get Group SubscribersGet all subscribers belong to a specified group

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

Why run this pair with FlowMattic

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

Your list passes through your server

Subscriber data moves between MailerLite and Google through FlowMattic on your own WordPress site, without another automation provider in the middle.

Large imports cost nothing extra

Runs are unlimited, so pasting a thousand rows from an event into the sheet subscribes all of them at no extra charge.

Both directions with one tool

MailerLite and Google Sheets both have triggers and actions, so the same setup handles imports into MailerLite and reports out of it.

Common questions

How do I set up a Google Sheets MailerLite integration?

Connect both accounts in FlowMattic. For sheet to MailerLite, start from New Spreadsheet Row and add Create or Update Subscriber. For MailerLite to sheet, start from a trigger such as Subscriber Added to Group and add Add New Row.

Can I import a whole existing sheet into MailerLite?

Yes. Start from Schedule, read the rows with Get Row Data, loop with Iterator and run Create or Update Subscriber for each. Run it once, then let New Spreadsheet Row handle new additions.

Will existing subscribers be duplicated?

Create or Update Subscriber updates the subscriber when the email already exists in MailerLite, so running the same row twice does not create a second subscriber.

Can I send a campaign from the sheet?

Send Campaign is a MailerLite action, so a sheet change such as a Send column set to Yes can run it. Test the step on a small group before using it on your main list.

Can I record which subscribers finished an automation?

Yes. Subscriber Completed Automation fires when someone finishes the workflow you pick, and Add New Row can log them, which helps measure how many people finish an onboarding series.

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

Start automating MailerLite and Google Sheets

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. MailerLite integration 1.0.3, Google Sheets integration 2.2.4.