MailerLite and Google Sheets automations
MailerLite holds subscribers and campaigns, and Google Sheets keeps the row that “Update Spreadsheet Row” changes after “Subscriber Unsubscribed”.
Set up an automation: when subscriber unsubscribed in MailerLite, update spreadsheet row in Google Sheets
Build itOr have an AI agent work across MailerLite and Google Sheets: it decides what to do in each on every run, on a schedule or when you ask it in its chat.
MailerLite and Google Sheets in practice
Used for
MailerLite holds subscribers and campaigns, and Google Sheets keeps the row that “Update Spreadsheet Row” changes after “Subscriber Unsubscribed”.
Best template
“Subscriber Unsubscribed” in MailerLite, then “Update Spreadsheet Row” in Google Sheets. An unsubscribe is a status worth recording, and the action updates columns in a sheet row.
Watch out
“Update Spreadsheet Row” changes an existing row, so the subscriber’s row must exist before “Subscriber Bounced” reaches it.
MailerLite and Google Sheets templates
Pick one and Captain builds it with you.


When spam complaint in MailerLite, update spreadsheet row in Google Sheets
Build this

When subscriber opened campaign in MailerLite, update spreadsheet row in Google Sheets
Build this

When subscriber clicked campaign link in MailerLite, update spreadsheet row in Google Sheets
Build this

When campaign sent in MailerLite, update spreadsheet row in Google Sheets
Build this

When subscriber bounced in MailerLite, update spreadsheet row in Google Sheets
Build this

When subscriber deleted in MailerLite, update spreadsheet row in Google Sheets
Build this

When subscriber fields updated in MailerLite, update spreadsheet row in Google Sheets
Build this

When subscriber removed from group in MailerLite, update spreadsheet row in Google Sheets
Build this

When subscriber unsubscribed in MailerLite, update spreadsheet row in Google Sheets
Build this

When subscriber created in MailerLite, update spreadsheet row in Google Sheets
Build this
MailerLite and Google Sheets triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
11- Subscriber createdTriggers when a subscriber was created on your mailing list.
- Subscriber unsubscribedTriggers when a subscriber has unsubscribed from your mailing list.
- Subscriber added to groupTriggers when a subscriber is added to a group.
- Subscriber removed from groupTriggers when a subscriber has been removed from a group.
- Subscriber fields updatedTriggers when the subscriber fields have been updated.
- Subscriber deletedTriggers when a subscriber is deleted or forgotten.
- Subscriber bouncedTriggers when an email to a subscriber bounces.
- Campaign sentTriggers when a campaign has been sent out.
- Subscriber clicked campaign linkTriggers when a subscriber clicks a link in a campaign.
- Subscriber opened campaignTriggers when a subscriber opens a campaign.
- Spam complaintTriggers when a subscriber marks a campaign as spam.
No triggers match.
Actions
13- Create or update subscriberCreate or update a subscriber
- Add subscriber to a groupAdds a subscriber to a group
- Change subscriber emailChange an existing subscriber email.
- Unsubscribe a subscriberUnsubscribe an existing subscriber by its id or email
- Remove subscriber from groupRemove subscriber from group
- Find a groupSearch for a group by name.
- Create subscribers groupCreates a new subscribers group.
- Get account detailsRetrieve account details.
- Get groups by nameSearch single group by the name.
- Create draft automationCreate a new draft automation.
- Update a segmentUpdate a specific segment.
- Create a fieldCreate a new field.
- Delete fieldDelete an existing field.
No actions match.
Triggers
1- Row added or updatedRuns when row added or updated
No triggers match.
Actions
23- Update spreadsheet rowUpdate columns in sheet row
- List rows in sheetGet rows from a sheet tab as objects with row numbers. Supports an optional header row, offset/limit paging, and fetching from the last row.
- Delete rowsDelete one or more rows from a specific sheet in a Google Spreadsheet using a row range or row numbers.
- Add new row to sheetRuns as a step in Google Sheets.
- Lookup spreadsheet rowsFind rows in a Google Sheet that match a column value or an advanced filter.
- Copy sheet to spreadsheetCopy a sheet to another file
- Add multiple rowsAdd one or more rows to a specific sheet in a Google Spreadsheet. Provide data column-by-column or paste a JSON array for bulk inserts. If the sheet has no headers, they will be auto-created from your JSON keys.
- Create subsheetAdd a new subsheet to a spreadsheet and optionally set its position and add column headers in the first row.
- Create sheet columnInsert a new column into the specified Google Sheets sheet at the given index (or append to the end) and optionally set its header.
- Get rows from rangeRetrieve rows from sheet range
- Create a spreadsheetCreate a new spreadsheet.
- Find subsheetSearches a sheet in a spreadsheet by name and returns the sheet name, column titles, and number of rows.
- Get row detailsRetrieve values and metadata for a specific row in a spreadsheet sheet.
- Clear spreadsheet rowClears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
- Create spreadsheet from templateCreate sheet from template
- List spreadsheetsFetch all spreadsheets
- List spreadsheet tabsLists all tabs (sheets) in a spreadsheet and returns the total count.
- Batch update cell valuesUpdate multiple cells at once
- Format spreadsheet rowFormat row font and background
- Add conditional formatting ruleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values
- Update sheet nameRenames an existing sheet (tab) within a Google Spreadsheet to a new name you specify.
- Update multiple rowsUpdate values in one or more rows of a Google Sheet.
- Permanently delete spreadsheetPermanently delete a spreadsheet from Google Drive, including files on shared drives.
No actions match.
Questions about MailerLite and Google Sheets
What can start a MailerLite and Google Sheets automation?
“Spam complaint”, “Subscriber opened campaign”, “Subscriber clicked campaign link”, “Campaign sent” and “Subscriber bounced”, and the others in the templates above.
Which other apps work with both MailerLite and Google Sheets?
TallyPrime, SprintOps, Pitchit, Cal ID and Signwell. Each one has templates with MailerLite and with Google Sheets, so a third app can join the same job.
All MailerLite integrations · All Google Sheets integrations · Every app, A to Z
Connect MailerLite and Google Sheets
Or pick another template above. Free to start.
Build it with Captain