Emma + Google Sheets

Add new subscribers to Emma from new or updated rows in Google Sheets

Effortlessly keep your email marketing list up-to-date with this convenient Google Sheets to Emma workflow. When you add or update a row in your Google Sheets, this automation will create a new subscriber in your Emma account. Save time and ensure accurate email management, making it simpler to stay connected with your valued contacts.

When this happens...
New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Add Member Order
Create an Order for the given member.
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