Gmail
Smartsheet
zapier

An automated workflow using zapier

Connects Gmail + Smartsheet

Add Smartsheet rows for new emails in Gmail [Business Gmail Accounts Only]

About this workflow template

This automation scenario allows you to connect Gmail and Smartsheet

It can be build using Zapier, a no-code workflow automation tool. Zapier allows you to create automated scripts using a simple drag-and-drop interface for non-technical users. This is a ready-made scenario, but it can be customized by adding more apps, actions, filters or branches.

Gmail and Smartsheet can also be integrated using automation tools other than zapier:

Diagram

Add Smartsheet rows for new emails in Gmail [Business Gmail Accounts Only]
Workflow diagram: Gmail + Smartsheet integration

How it works?

When this trigger fires in Gmail

Gmail

New Email in Gmail

Triggers when a new e-mail appears in the specified mailbox.

Then this action happens in Smartsheet

Smartsheet

Add Row to Sheet in Smartsheet

Add a row to a sheet.

How to set up this workflow

This guide contains information on how to set up an automatic workflow that allows to Add Smartsheet rows for new emails in Gmail [Business Gmail Accounts Only].

Part I

Configure Applications

First, we need to connect Gmail and Smartsheet to Zapier.

  • Create Zapier account.

    Create Zapier account.

    Create Zapier account if you don't have one.

  • Connect Gmail to Zapier.

    Connect Gmail to Zapier.

    Give Zapier access to your Gmail account, using Gmail credentials.

  • Connect Smartsheet to Zapier.

    Connect Smartsheet to Zapier.

    Give Zapier access to your Smartsheet account, using Smartsheet credentials.

Part II

Build an integration workflow

Next, we need to create a workflow automation scenario using graphical no-code web interface of Zapier.

  • Set up a Trigger action for Gmail

    Set up a Trigger action for Gmail

    Choose the following trigger: New Email (Triggers when a new e-mail appears in the specified mailbox.).

  • Then set up an Action for Smartsheet

    Then set up an Action for Smartsheet

    Choose this action: Add Row to Sheet (Add a row to a sheet.).

Part III

Test and Publish

Finally, we need to test this automation and publish it.

  • Customize data flow

    Customize data flow

    Configure the data that is exchanged between Gmail and Smartsheet.

  • Test the workflow and turn it on for production use

    Test the workflow and turn it on for production use

    Test your scenario and publish to production. Now you have an automatic workflow, that will Add Smartsheet rows for new emails in Gmail [Business Gmail Accounts Only]!

Supported triggers and actions

  • Gmail

    New email

    Triggers when a new e-mail appears in the specified mailbox.

    zapierautomateioalbato
    triggerbyzapierautomateioalbato
  • Gmail

    New email matching search

    Triggers when you receive a new email that matches a search string you provide.

    zapieralbatopipedream
    triggerbyzapieralbatopipedream
  • Gmail

    New labeled email

    Triggers when you label an email.

    zapierpipedream
    triggerbyzapierpipedream
  • Gmail

    New attachment

    Triggers when you receive a new attachment (triggers once per attachment).

    zapier
    triggerbyzapier
  • Gmail

    Watch emails

    Triggers when a new email is received to be processed according to specified criteria.

    integromat
    triggerbyintegromat
  • Gmail

    New starred email

    Triggers when you receive a new email and star it within two days.

    zapierautomateio
    triggerbyzapierautomateio
  • Smartsheet

    Add row to sheet

    Add a row to a sheet.

    zapierpabbly-connectpipedream
    actionbyzapierpabbly-connectpipedream
  • Smartsheet

    Create a row

    Inserts a row into the specified sheet.

    integromat
    actionbyintegromat
  • Smartsheet

    New row update

    Update an existing row with new values. Requires a row ID.

    zapier
    actionbyzapier
  • Smartsheet

    Add attachment to row

    Adds a file attachment to a row.

    zapier
    actionbyzapier
  • Smartsheet

    New sheet from template

    Create a new sheet from a template.

    zapierpabbly-connectpipedream
    actionbyzapierpabbly-connectpipedream
  • Smartsheet

    Create workspace

    Creates a Workspace.

    zapierintegratelypabbly-connectalbato
    actionbyzapierintegratelypabbly-connectalbato

Apps you need

Zapier

Zapier

Automation Platforms

No-code automation service

Zapier simplifies busy people's lives by automating web app data transfers, reducing tedious tasks, and allowing teams to collaborate effortlessly. With over 5,000 popular apps connected, it's never been easier to streamline your workflow.