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
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
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

- 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
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- 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

About Emma

Grow your business with smart, stylish email marketing campaigns.

Learn more

Related categories

Email Newsletters

Similar apps

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Related Zap Templates

Add Emma Subscribers from a Google Sheets spreadsheet

Add new Emma subscribers to Google Sheets as rows

Emma + Google Sheets

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

Supported triggers and actions

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

Field Deleted

Group Created

Group Updated

New Member Added

Member Deleted

Member Status Updated

Mailing Clicked

Mailing Opened

Mailing Share Clicked

Specific Member Opened a Mailing

Add Member to Group

Create Event

Create or Update Product

Forward Mailing

Create Member

Remove Member From Group

Update Group

Update a Member's Field Information

Get Groups to Which a Member Belongs

Get List of Members Whom Was Sent a Mailing

Get List of Optouts for Specific Mailing

Get Response Summary for a Mailing by ID

Get Member by Email

Find Member by Email or Create Member

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

Field Created

Field Updated

Group Deleted

Mailing Finished

Member Added to Group

Member Removed From Group

Member Updated

Mailing Forwarded

Mailing Shared

Member Unsubscribed

Add Member Order

Copy All the Members of One Group Into Another Group

Create Field

Create Segment

Create Group

Opt Out a Member's Status Based on Email Address

Remove a Member From One or More Groups

Update Member

Update Member Order

Get Members of a Group

Get Member by ID

Get Product

Lookup Product

Find or Create Member

About Emma

Related categories

Similar apps

Mailchimp