Gmail + Smartsheet

Send emails with Gmail when new Smartsheet rows are added

Want to send out automated emails based on information you add to a spreadsheet, or to send a notification whenever new data is added? Use this Zapier integration to automatically send an email via Gmail whenever a new row is added to a Smartsheet spreadsheet. It'll copy the data you choose from your spreadsheet, and then send it in an email to the contact you add to this Zap.

When this happens...
New Row
Triggers when a new row is added.
TriggerScheduled
automatically do this!
Send Email
Triggers when a new e-mail appears in the specified mailbox.
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

What does this mean?

- Choose a SheetRequired
Trigger
Scheduled
Try It
- Choose a SheetRequired
Trigger
Scheduled
Try It
- Workspace NameRequired
Action
Write
- Choose a SheetRequired
- RowRequired
- TitleRequired
- CommentRequired
Action
Write
- Source FolderRequired
- Destination FolderRequired
- New Folder NameRequired
Action
Write

- WorkspaceRequired
- New NameRequired
- What to Include?
- Skip Remap
Action
Write
- DestinationRequired
- Sheet to CopyRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write

- Choose a SheetRequired
- Row IDRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- FormatRequired
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a WorkspaceRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row
Find a row in a specified sheet using a query.
Action
Write
New Label
Triggers when you add a new label.
Trigger
Scheduled
Try It
- Label/Mailbox
Trigger
Scheduled
Try It
New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Scheduled
Try It
- Label(s) to Add
- Message to be LabeledRequired
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Body Type
- BodyRequired
- Signature
- Label/Mailbox
- Attachments
Action
Write
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body Type
- BodyRequired
- Signature
- Label/Mailbox
- Attachments
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- Body Type
- BodyRequired
- Label/Mailbox
- Attachments
Action
Write
- Search StringRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body Type
- BodyRequired
- Signature
- Label/Mailbox
- Attachments
Action
Search or write

- Choose a SheetRequired
Trigger
Scheduled
Try It
- Choose a SheetRequired
Trigger
Scheduled
Try It
- SheetRequired
- RowRequired
- File AttachmentRequired
Action
Write
- Choose a SheetRequired
- Add Row to Top or Bottom
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- DestinationRequired
- TemplateRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- Choose RowRequired
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a SheetRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Label/Mailbox
- Search String
Trigger
Scheduled
Try It
- Label/MailboxRequired
Trigger
Scheduled
Try It
- Search StringRequired
Trigger
Scheduled
Try It
- Label/Mailbox
Trigger
Scheduled
Try It
- SubjectRequired
- To
- Cc
- Bcc
- From
- From Name
- Body Type
- BodyRequired
- Signature
- Label/Mailbox
- Attachments
Action
Write
- NameRequired
Action
Write
- Message to Remove Label(s) FromRequired
- Label(s) to RemoveRequired
Action
Write
- Search StringRequired
Action
Search

About Gmail

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Learn more Help

Related categories

Similar apps

IMAP by Zapier

Email, Zapier

SMTP by Zapier

Email, Zapier

Microsoft Office 365

Email, Microsoft

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

Help

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

PRODUCTS

CAPABILITIES

By team

Gmail + Smartsheet

Send emails with Gmail when new Smartsheet rows are added

Updated Row

New Comment

Choose a SheetRequired

Create Workspace

Workspace NameRequired

Add Discussion to Row

Choose a SheetRequired

RowRequired

TitleRequired

CommentRequired

Copy Folder

Source FolderRequired

Destination FolderRequired

New Folder NameRequired

Copy Workspace

WorkspaceRequired

New NameRequired

What to Include?

Skip Remap

New Sheet From Existing Sheet

DestinationRequired

Sheet to CopyRequired

Copy Cells?Required

Copy Attachments?Required

Copy Discussions?Required

Sheet NameRequired

New Row Update

Choose a SheetRequired

Row IDRequired

Send Sheet

Choose a SheetRequired

Email Address(es)Required

FormatRequired

Email Subject

Message

CC Me?

Paper Size

Share Workspace

Choose a WorkspaceRequired

Email Address(es) to Share ToRequired

Access LevelRequired

Notify via Email?Required

Email Subject

Message

CC Me?

Find sheet Row

New Label

New Email

Label/Mailbox

New Starred Email

Add Label to Email

Label(s) to Add

Message to be LabeledRequired

Create Draft Reply

Trigger Instructions

ThreadRequired

To

Cc

Bcc

From

From Name

Body Type

BodyRequired

Signature

Label/Mailbox

Attachments

Send Email

To

Cc

Bcc

From

From Name

Reply To

SubjectRequired

Body Type