Gmail + Smartsheet

Get reports from Smartsheet and send emails in Gmail

This workflow initiates when a report is retrieved in Smartsheet and will consequently send an email through Gmail. This automation is designed to streamline your report sharing process, reducing time and effort by sending critical report updates to necessary recipients in a timely manner. Not only does it improve your productivity, but also ensures no important information is missed out on.

When this happens...
Get Reports
[PRIVATE] Generates report list for dropdown.
TriggerPolling
automatically do this!
Send Email
Triggers when a new email 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

Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
Try It
- Select a ReportRequired
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

- 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
- 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
- LabelRequired
- 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
- Signature delimiter
- 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
- Signature delimiter
- Label or mailbox
- Attachments
Action
Write
- ThreadRequired
- Label(s) to removeRequired
Action
Write
- Message IDRequired
- Attachment FilenameRequired
- Attachment Size
Action
Search
- Search StringRequired
- To
- Send message to Google Contacts Group/Label
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Signature delimiter
- Label or mailbox
- Attachments
Action
Search or write

- Choose a SheetRequired
Trigger
Polling
Try It
- 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
- SheetRequired
- ColumnRequired
- Parent Row
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 (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet IDRequired
- QueryRequired
Action
Search
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
- Signature delimiter
- 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
- Subject
- Body type
- BodyRequired
- Add signature default
- Signature delimiter
- Label or mailbox
- Attachments
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

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 matching Gmail emails

Add rows to Smartsheet for new labeled emails in Gmail

Add attachments to Smartsheet rows from new Gmail emails

Gmail + Smartsheet

Get reports from Smartsheet and send emails in Gmail

Get Reports

New Comment

New or Updated Report Row

Create Workspace

Add Discussion to Row

Copy Folder

Copy Workspace

Move Row

Create Sheet From Template

Send Row

Share Sheet

API Request (Beta)

Find Attachment

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

Get Attachment by Filename

Find or Send Email

New Attachment

New Row

Updated Row

Add Attachment to Row

Add Row to Sheet

Copy Row

Export Column

Create Sheet From Existing Sheet

Update Row

Send Sheet

Share Workspace

Find sheet Row (Legacy)

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 Email

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