Email by Zapier + Google Sheets

Add Google Sheets rows for new inbound email messages

Let Zapier automatically add Google Sheets rows to save new inbound emails, as soon as they hit your inbox. After the integration is set up, every new inbound email will be added to a row in a specified Google Sheets worksheet.

When this happens...
New Inbound Email
Triggers when an email is forwarded to your own custom zapiermail.com address.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Inbound Email
Triggers when an email is forwarded to your own custom
Trigger
Instant
New Read Receipt
Triggers when an email that you've enabled read receipts on via our
Trigger
Instant
Send Outbound Email
Send an email from your own custom
Action
Write
New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger
Instant

New Spreadsheet
Triggered when you create a new spreadsheet.
Trigger
Scheduled
New or Updated Spreadsheet Row (Team Drive)
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Trigger
Scheduled

New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
Trigger
Instant

Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action

About Email by Zapier

Send and receive email via a custom Zapier email address at "zapiermail.com". This is great for triggering off of emails and sending custom emails. (Max of 10 email sends per hour.) Have direct access to your own email servers? Check out our IMAP and SMTP services!