Google Sheets + MailerLite
Unsubscribe MailerLite subscribers when new or updated rows appear in Google Sheets
Streamline your email marketing campaign with this handy workflow. Whenever modifications are made in your Google Sheets, it immediately reflects in your MailerLite subscriber list. This real-time update keeps your MailerLite dataset up-to-date, boosting the efficacy of your digital marketing initiatives.
Streamline your email marketing campaign with this handy workflow. Whenever modifications are made in your Google Sheets, it immediately reflects in your MailerLite subscriber list. This real-time update keeps your MailerLite dataset up-to-date, boosting the efficacy of your digital marketing initiatives.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Unsubscribe SubscriberSets the contact's status to "Unsubscribed".
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Subscriber Clicked Campaign Link
Triggers when a subscriber clicks a link in a campaign.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Campaign Sent
Triggers when a campaign has been sent out.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscriber GroupRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscriber Bounced
Triggers when an email to a subscriber bounces.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscriber Deleted
Triggers when a subscriber is deleted or forgotten.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscriber Fields Updated
Triggers when the subscriber fields have been updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
New EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Group nameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscriber GroupRequired
EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email or nameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSubscriber Opened Campaign
Triggers when a subscriber opens a campaign.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Spam Complaint
Triggers when a subscriber issues a spam complaint about an email.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscriber Created
Triggers when a subscriber was created on your mailing list.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscriber GroupRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscriber Unsubscribed
Triggers when a subscriber has unsubscribed from your mailing list.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscriber GroupRequired
EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Campaign nameRequired
Email subjectRequired
Email sender nameRequired
Email from addressRequired
Email contentRequired
Subscriber Groups
Subscriber Segments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscriber Groups
EmailRequired
Resubscribe
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Campaign nameRequired
Email subjectRequired
Email sender nameRequired
Email from addressRequired
Email contentRequired
Subscriber Groups
Subscriber Segments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Group nameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Related categories
About MailerLite
Related categories
Related Zap Templates
- Create or update MailerLite subscribers with new rows in Google Sheets
- Create Google Sheets rows for new MailerLite group subscribers
- Create rows in Google Sheets for new subscribers added to MailerLite group
- Add subscribers to MailerLite from newly-updated rows on Google Sheets
- Record unsubscribed MailerLite subscribers in a Google Sheets spreadsheet row
- Add new Google Sheets rows as MailerLite subscribers in a group.
- Add New MailerLite Subscribers to Google Sheets as Rows
- Add new Google Sheets rows as MailerLite group subscribers
- Add MailerLite subscribers to a group from new or updated rows in Google Sheets
- Send MailerLite campaigns for new or updated Google Sheets rows
- Send MailerLite campaigns for new or updated Google Sheets team drive spreadsheet rows
- Create MailerLite campaigns from new Google Sheets spreadsheet rows on team drive
- Add new MailerLite subscribers to a Google Sheets spreadsheet
- Create multiple Google Sheets rows for new MailerLite subscribers
- Create MailerLite campaigns from new Google Sheets spreadsheets
- Add new MailerLite subscribers to Google Sheets and update rows
- Create multiple Google Sheets rows for each new MailerLite campaign sent
- Create or update MailerLite subscribers from new rows in your Google Sheets team drive
- Add new or updated Google Sheets rows to a group as subscribers in MailerLite
- Create Google Sheets rows for new MailerLite subscribers
- Add new MailerLite group subscribers to a Google Sheets spreadsheet
- Update Google Sheets rows when new subscribers are added to a group in MailerLite
- Add new MailerLite group subscribers to Google Sheets as multiple rows
- Track MailerLite subscriber triggered automations by creating new rows in Google Sheets
- Remove subscribers from a group in MailerLite when new or updated rows appear in Google Sheets
- Create or update MailerLite subscribers with new or updated rows in Google Sheets team drive
- "update Google Sheets rows when new subscribers are added to a group in MailerLite"
- Update Google Sheets rows with every new MailerLite subscriber created
- Update Google Sheets rows when subscriber fields are updated in MailerLite
- Track completed MailerLite subscribers' automations by creating rows in Google Sheets
- Create spreadsheet columns in Google Sheets for each new subscriber in MailerLite
- Create multiple spreadsheet rows in Google Sheets when new subscriber-triggered automations occur in MailerLite
- Create spreadsheet rows in Google Sheets for sent campaigns from MailerLite
- Track bounced MailerLite subscribers by creating rows in Google Sheets
- Add new Google Sheets rows to MailerLite group as subscribers
- Add MailerLite subscribers from new Google Sheets rows with emails validated by EmailListVerify
- Update Google Sheets rows whenever MailerLite subscriber fields are modified
- Copy worksheets in Google Sheets when new subscribers are added to a group in MailerLite
- Create or update MailerLite subscribers from new Google Sheets spreadsheets
- Send MailerLite campaigns when new rows are added to Google Sheets
- Log MailerLite subscriber campaign link clicks as new rows in Google Sheets
- Unsubscribe subscribers in MailerLite when new or updated rows are added to Google Sheets team drive
- Track removed MailerLite subscribers by creating new rows in Google Sheets
- Copy worksheets in Google Sheets when new campaigns are sent in MailerLite
- Record completed MailerLite subscriber automations in Google Sheets rows instantly
- Update Google Sheets rows when new MailerLite subscribers click campaign link
- Track MailerLite campaign openers by creating new rows in Google Sheets
- Create or update MailerLite subscribers from new rows in Google Sheets
- Add new or updated Google Sheets rows to a group in MailerLite as subscribers
- Add new MailerLite group subscribers to a Google Sheets row
- Add new MailerLite subscribers to group and create multiple rows in Google Sheets
- Add new Google Sheets rows to a group as subscribers in MailerLite
- Create or update MailerLite subscribers from new rows in Google Sheets
- Create Google Sheets worksheets for new MailerLite group subscribers
- Add new MailerLite group subscribers to Google Sheets as top row entries
- Add new MailerLite group subscribers to a Google Sheets document
- Create MailerLite subscribers group from new Google Sheets rows
- "track MailerLite subscribers who click campaign links by creating new rows in Google Sheets"
- Create MailerLite subscribers group from new or updated rows in Google Sheets
Related Zap Templates
- Create or update MailerLite subscribers with new rows in Google Sheets
- Add subscribers to MailerLite from newly-updated rows on Google Sheets
- Add New MailerLite Subscribers to Google Sheets as Rows
- Send MailerLite campaigns for new or updated Google Sheets rows
- Add new MailerLite subscribers to a Google Sheets spreadsheet
- Add new MailerLite subscribers to Google Sheets and update rows
- Add new or updated Google Sheets rows to a group as subscribers in MailerLite
- Update Google Sheets rows when new subscribers are added to a group in MailerLite
- Remove subscribers from a group in MailerLite when new or updated rows appear in Google Sheets
- Update Google Sheets rows with every new MailerLite subscriber created
- Create spreadsheet columns in Google Sheets for each new subscriber in MailerLite
- Track bounced MailerLite subscribers by creating rows in Google Sheets
- Update Google Sheets rows whenever MailerLite subscriber fields are modified
- Send MailerLite campaigns when new rows are added to Google Sheets
- Track removed MailerLite subscribers by creating new rows in Google Sheets
- Update Google Sheets rows when new MailerLite subscribers click campaign link
- Add new or updated Google Sheets rows to a group in MailerLite as subscribers
- Add new Google Sheets rows to a group as subscribers in MailerLite
- Add new MailerLite group subscribers to Google Sheets as top row entries
- "track MailerLite subscribers who click campaign links by creating new rows in Google Sheets"
- Create Google Sheets rows for new MailerLite group subscribers
- Record unsubscribed MailerLite subscribers in a Google Sheets spreadsheet row
- Add new Google Sheets rows as MailerLite group subscribers
- Send MailerLite campaigns for new or updated Google Sheets team drive spreadsheet rows
- Create multiple Google Sheets rows for new MailerLite subscribers
- Create multiple Google Sheets rows for each new MailerLite campaign sent
- Create Google Sheets rows for new MailerLite subscribers
- Add new MailerLite group subscribers to Google Sheets as multiple rows
- Create or update MailerLite subscribers with new or updated rows in Google Sheets team drive
- Update Google Sheets rows when subscriber fields are updated in MailerLite
- Create multiple spreadsheet rows in Google Sheets when new subscriber-triggered automations occur in MailerLite
- Add new Google Sheets rows to MailerLite group as subscribers
- Copy worksheets in Google Sheets when new subscribers are added to a group in MailerLite
- Log MailerLite subscriber campaign link clicks as new rows in Google Sheets
- Copy worksheets in Google Sheets when new campaigns are sent in MailerLite
- Track MailerLite campaign openers by creating new rows in Google Sheets
- Add new MailerLite group subscribers to a Google Sheets row
- Create or update MailerLite subscribers from new rows in Google Sheets
- Add new MailerLite group subscribers to a Google Sheets document
- Create MailerLite subscribers group from new or updated rows in Google Sheets
- Create rows in Google Sheets for new subscribers added to MailerLite group
- Add new Google Sheets rows as MailerLite subscribers in a group.
- Add MailerLite subscribers to a group from new or updated rows in Google Sheets
- Create MailerLite campaigns from new Google Sheets spreadsheet rows on team drive
- Create MailerLite campaigns from new Google Sheets spreadsheets
- Create or update MailerLite subscribers from new rows in your Google Sheets team drive
- Add new MailerLite group subscribers to a Google Sheets spreadsheet
- Track MailerLite subscriber triggered automations by creating new rows in Google Sheets
- "update Google Sheets rows when new subscribers are added to a group in MailerLite"
- Track completed MailerLite subscribers' automations by creating rows in Google Sheets
- Create spreadsheet rows in Google Sheets for sent campaigns from MailerLite
- Add MailerLite subscribers from new Google Sheets rows with emails validated by EmailListVerify
- Create or update MailerLite subscribers from new Google Sheets spreadsheets
- Unsubscribe subscribers in MailerLite when new or updated rows are added to Google Sheets team drive
- Record completed MailerLite subscriber automations in Google Sheets rows instantly
- Create or update MailerLite subscribers from new rows in Google Sheets
- Add new MailerLite subscribers to group and create multiple rows in Google Sheets
- Create Google Sheets worksheets for new MailerLite group subscribers
- Create MailerLite subscribers group from new Google Sheets rows