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.

When this happens...
New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Add Member to Group
Add a single member to a group.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write

- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
Field Created
Triggers when a new member field is created.
Trigger
Instant
Try It
Field Updated
Triggers when a field is updated.
Trigger
Instant
Try It
Group Deleted
Triggers when a group is deleted.
Trigger
Instant
Try It
Mailing Finished
Triggers when a mailing is finished.
Trigger
Instant
Try It
Member Added to Group
Triggers when a member is added to a group.
Trigger
Instant
Try It
Member Removed From Group
Triggers when a member is removed from a group.
Trigger
Instant
Try It
Member Updated
Triggers when a member is updated.
Trigger
Instant
Try It
Mailing Forwarded
Triggers when a mailing is forwarded.
Trigger
Instant
Try It
Mailing Shared
Triggers when a member shares a mailing.
Trigger
Instant
Try It
Member Unsubscribed
Triggers when a subscriber opts-out.
Trigger
Instant
Try It
- 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
Action
Write
- From Group IDRequired
- To Group IDRequired
- Member Status IDRequired
Action
Write
- Shortcut NameRequired
- Display nameRequired
- Widget TypeRequired
- Options
- Column OrderRequired
- Field Type
Action
Write
- CriteraRequired
- NameRequired
Action
Write
- Group NameRequired
Action
Write
- EmailRequired
Action
Write
- Member IDRequired
- Group IDsRequired
Action
Write
- EmailRequired
- SMS Phone Number
- SMS Promotional Status
- SMS Transactional Status
- Group Ids
- Field Triggers
- Subscriber Consent Tracking
Action
Write
- Member IDRequired
- Order IDRequired
- Status
- Updated At
- Cancelled Reason
- Cancelled At
- Subtotal
- Shipping Cost
- Tax
- Total Cost
Action
Write
- Group IDRequired
Action
Search
- Member IDRequired
Action
Search
- Product IDRequired
Action
Search
- Count
- Start
- End
- Sort Column
- Sort Order
- Source
- Source Product ID
- SKU
- Name
- Price
- Product URL
- Image URL
- Categories
Action
Search
- Member IDRequired
- EmailRequired
- SMS Phone Number
- SMS Promotional Status
- SMS Transactional Status
- Group Ids
- Field Change Autoresponders
- Subscriber Consent Tracking
- Signup Form ID
Action
Search or write

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
Field Deleted
Triggers when a field is deleted.
Trigger
Instant
Try It
Group Created
Triggers when a new member group is created.
Trigger
Instant
Try It
Group Updated
Triggers when a group is updated.
Trigger
Instant
Try It
New Member Added
Triggers when a new member is added to your audience.
Trigger
Instant
Try It
Member Deleted
Triggers when a member is deleted.
Trigger
Instant
Try It
Member Status Updated
Triggers when a member's status is updated.
Trigger
Instant
Try It
Mailing Clicked
Triggers when a mailing is clicked.
Trigger
Instant
Try It
Mailing Opened
Triggers when a mailing is opened.
Trigger
Instant
Try It
Mailing Share Clicked
Triggers when a member shares a link to a mailing and someone clicks on it.
Trigger
Instant
Try It
- Mailing IdRequired
- Member IdRequired
Trigger
Polling
Try It
- Member IDRequired
- Group IDRequired
Action
Write
- EmailRequired
- Event NameRequired
- DataRequired
Action
Write
- Source
- Source Product ID
- Product Name
- Source Variant IDs
- Variant Names
- Variant SKUs
- Variant Prices
- Variant Product URL
- Variant Image URL
- Categories
- Deleted At
Action
Write
- Mailing IDRequired
- Member IDRequired
- Recipient Emails
- Heads Up Emails
Action
Write
- EmailRequired
- SMS Phone Number
- SMS Promotional Status
- SMS Transactional Status
- Group Ids
- Field Change Autoresponders
- Subscriber Consent Tracking
- Signup Form ID
Action
Write
- Member IDRequired
- Group IDRequired
Action
Write
- Group NameRequired
- Group IDRequired
Action
Write
- Member IdRequired
Action
Write
- Member IDRequired
Action
Search
- Mailing IDRequired
Action
Search
- Mailing IdRequired
Action
Search
- Mailing IDRequired
Action
Search
- EmailRequired
Action
Search
- EmailRequired
- SMS Phone Number
- SMS Promotional Status
- SMS Transactional Status
- Group Ids
- Field Change Autoresponders
- Subscriber Consent Tracking
- Signup Form ID
Action
Search or write