Gmail + Smartsheet

Add rows to Smartsheet when new emails matching search appear in Gmail

Effortlessly keep track of specific email activity in your Gmail account with this handy workflow. When a new email matches your search criteria in Gmail, the relevant data will be added to a Smartsheet spreadsheet. This automation aids in data organization, ensuring important email details are never missed and are always ready for review in Smartsheet.

When this happens...
New Email Matching Search
Triggers when you receive a new email that matches a search string you provide.
TriggerScheduled
automatically do this!
Add Row to Sheet
Add a row to a sheet.
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?

- 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
- 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

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

Add rows to Smartsheet when new emails matching search appear in Gmail

New Attachment

Label/Mailbox

Search String

New Labeled Email

New Email Matching Search

Search StringRequired

New Thread

Label/Mailbox

Create Draft

SubjectRequired

To

Cc

Bcc

From

From Name

Body Type

BodyRequired

Signature

Label/Mailbox

Attachments

Create Label

NameRequired

Remove Label from Email

Message to Remove Label(s) FromRequired

Label(s) to RemoveRequired

Find Email

Search StringRequired

Updated Row

Choose a SheetRequired

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