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 RowTriggered 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
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
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 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
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text Strikethrough
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
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
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 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
About Google Sheets
Related categories
About MailerLite
Related categories
Related Zap Templates
- Add subscribers to MailerLite from newly-updated rows on Google Sheets
- Create Google Sheets rows for new MailerLite group subscribers
- Create or update MailerLite subscribers with new 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 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
- Record unsubscribed MailerLite subscribers in a Google Sheets spreadsheet row
- 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
Related Zap Templates
- Add subscribers to MailerLite from newly-updated rows on Google Sheets
- Create rows in Google Sheets for new subscribers added to MailerLite group
- 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
- Record unsubscribed MailerLite subscribers in a Google Sheets spreadsheet row
- 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
- Create Google Sheets rows for new MailerLite group subscribers
- 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 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
- Create or update MailerLite subscribers with new rows in 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
- 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