Emma + Google Sheets
Add Emma Subscribers from a Google Sheets spreadsheet
Want a quick way to add subscribers to your Emma mailing list from a Google Sheets spreadsheet? This Zapier automation is what you need. It'll watch your spreadsheet for new entries, then whenever a new contact is added to your spreadsheet, Zapier will copy the info and add them to your Emma mailing list.
Want a quick way to add subscribers to your Emma mailing list from a Google Sheets spreadsheet? This Zapier automation is what you need. It'll watch your spreadsheet for new entries, then whenever a new contact is added to your spreadsheet, Zapier will copy the info and add them to your Emma mailing list.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Add Member to GroupAdd a single member to a group.
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 ZapPollingZapier 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.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.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
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
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
Field Deleted
Triggers when a field is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Group Created
Triggers when a new member group is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Group Updated
Triggers when a group is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Member Added
Triggers when a new member is added to your audience.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Deleted
Triggers when a member is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Status Updated
Triggers when a member's status is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mailing Clicked
Triggers when a mailing is clicked.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mailing Opened
Triggers when a mailing is opened.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mailing Share Clicked
Triggers when a member shares a link to a mailing and someone clicks on it.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mailing IdRequired
Member IdRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planMember IDRequired
Group IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Event NameRequired
DataRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source
Source Product ID
Product Name
Source Variant IDs
Variant Names
Variant SKUs
Variant Prices
Variant Product URL
Variant Image URL
Categories
Deleted At
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Mailing IDRequired
Member IDRequired
Recipient Emails
Heads Up Emails
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
SMS Phone Number
SMS Promotional Status
SMS Transactional Status
Group Ids
Field Change Autoresponders
Subscriber Consent Tracking
Signup Form ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member IDRequired
Group IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Group NameRequired
Group IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMailing IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMailing IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMailing IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
SMS Phone Number
SMS Promotional Status
SMS Transactional Status
Group Ids
Field Change Autoresponders
Subscriber Consent Tracking
Signup Form ID
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
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 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.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.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
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
Output format
First row
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 foundField Created
Triggers when a new member field is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Field Updated
Triggers when a field is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Group Deleted
Triggers when a group is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mailing Finished
Triggers when a mailing is finished.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Added to Group
Triggers when a member is added to a group.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Removed From Group
Triggers when a member is removed from a group.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Updated
Triggers when a member is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mailing Forwarded
Triggers when a mailing is forwarded.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mailing Shared
Triggers when a member shares a mailing.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Unsubscribed
Triggers when a subscriber opts-out.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member IDRequired
Status
Mailing ID
Source Member IDRequired
Created AtRequired
Updated At
SourceRequired
Cancelled Reason
SubtotalRequired
Shipping CostRequired
TaxRequired
Total CostRequired
Source Order IDRequired
Product IDsRequired
Product PricesRequired
Product QuantitiesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From Group IDRequired
To Group IDRequired
Member Status IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Shortcut NameRequired
Display nameRequired
Widget TypeRequired
Options
Column OrderRequired
Field Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CriteraRequired
NameRequired
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.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member IDRequired
Group IDsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
SMS Phone Number
SMS Promotional Status
SMS Transactional Status
Group Ids
Field Triggers
Subscriber Consent Tracking
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member IDRequired
Order IDRequired
Status
Updated At
Cancelled Reason
Cancelled At
Subtotal
Shipping Cost
Tax
Total Cost
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Group IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMember IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCount
Start
End
Sort Column
Sort Order
Source
Source Product ID
SKU
Name
Price
Product URL
Image URL
Categories
ActionThis is an event a Zap performs.SearchFind existing data in your appMember IDRequired
EmailRequired
SMS Phone Number
SMS Promotional Status
SMS Transactional Status
Group Ids
Field Change Autoresponders
Subscriber Consent Tracking
Signup Form ID
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
Related categories
