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

- Label or mailbox
- Search keywords
Trigger
Polling
Try It
- Label or mailboxRequired
Trigger
Polling
Try It
- Label or mailbox
Trigger
Polling
Try It
New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Polling
Try It
- Label
- MessageRequired
Action
Write
- Email message to be DeletedRequired
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- To
- Send message to Google Contacts Group/Label
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- ThreadRequired
- Label(s) to removeRequired
Action
Write
- Search StringRequired
Action
Search
- Choose a SheetRequired
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
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
Polling
Try It
- Label or mailboxRequired
Trigger
Polling
Try It
- Search keywordsRequired
Trigger
Polling
Try It
- Label/Mailbox
Trigger
Polling
Try It
- MessageRequired
Action
Write
- Recipient Instructions
- To
- Cc
- Bcc
- SubjectRequired
- From
- From Name
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- Name of labelRequired
Action
Write
- MessageRequired
- Label(s) to removeRequired
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- Search StringRequired
- To
- Send message to Google Contacts Group/Label
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Search or write
- Choose a SheetRequired
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
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
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet IDRequired
- Row IDRequired
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

Related categories

Similar apps

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.

Related categories

Spreadsheets

Similar apps

Related Zap Templates

Add rows to Smartsheet for new labeled emails in Gmail

Gmail + Smartsheet

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

Supported triggers and actions

New Attachment

New Labeled Conversation

New Email

New Starred Email

Add Label to Email

Delete Email

Create Draft Reply

Send Email

Remove Label From Conversation

Find Email

New Attachment

New Row

Create Workspace

Add Discussion to Row

Copy Folder

Copy Workspace

Create Sheet From Existing Sheet

Update Row

Send Sheet

Share Workspace

Find sheet Row

New Label

New Labeled Email

New Email Matching Search

New Conversation

Archive Email

Create Draft

Create Label

Remove Label From Email

Reply to Email

Find or Send Email

New Comment

Updated Row

Add Attachment to Row

Add Row to Sheet

Copy Row

Move Row

Create Sheet From Template

Send Row

Share Sheet

API Request (Beta)

Find Attachment

About Gmail

Related categories

Similar apps

IMAP by Zapier

SMTP by Zapier

Microsoft Office 365

About Smartsheet

Related categories

Similar apps

MySQL

Zoho Creator

Knack

Related Zap Templates

Related Zap Templates