Google Sheets and Gmail integrations

Connecting Google Sheets and Gmail on Make

Share

Connect Google Sheets and Gmail with any of your favorite apps in just a few clicks. Design, build, and automate anything for your work by integrating apps like Google Sheets and Gmail to create visual automated workflows. Choose from thousands of ready-made apps or use our no-code toolkit to connect to apps not yet in our library.

Get started free

Browse our documentation

Build your Google Sheets and Gmail integrations.

Create custom Google Sheets and Gmail workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.

Add a Conditional Format Rule

Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.

Action

Add a Row

Appends a new row to the bottom of the table.

Action

Add a Sheet

Adds a new sheet.

Action

Clear Values from a Range

Clears a specified range of values from a spreadsheet.

Action

Clear a Cell

Cleares a specific cell.

Action

Clear a Row

Clears values from a specific row.

Action

Copy a Sheet

Copies a sheet to another spreadsheet.

Action

Copy an email

Copies an email or a draft into a selected folder.

Action

Create a Spreadsheet

Creates a new spreadsheet.

Action

Connect any app with Google Sheets and Gmail

Get started free

Popular Google Sheets and Gmail workflows.

Looking to get more out of Google Sheets and Gmail? With Make you can visually integrate Google Sheets and Gmail into any workflow to save time and resources — no coding required. Try any of these templates in just a few clicks.

Add client inbox label to Gmail

The Google Sheets module checks for matches between the sender’s email address and the list of client email addresses. If a match is found, the label client_mailbox is added to the email. More information here.

Try It ➔

Save a Gmail email containing a specific phrase to Google Sheets as a new row

Use this template to save a Gmail message containing a specific phrase to your Google Sheets spreadsheet as a new row.

Try It ➔

Send a Gmail email from a new Google Sheets row

Use this template to send a Gmail message when a new row is added to your Google Sheets spreadsheet.

To work with the template's default settings, your Google Sheets spreadsheet should contain these columns: Email address, Subject of the email and Content of the email.

Try It ➔

Save a Gmail email to Google Sheets as a new row

Use this template to save a Gmail email message to your Google Sheets spreadsheet as a new row.

Try It ➔

Create a Gmail draft message from a new Google Sheets row

Use this template to create a Gmail draft message when a new row is added to your Google Sheets spreadsheet.

To work with the template's default settings, your Google Sheets spreadsheet should contain these columns: Email address, Subject of the email and Content of the email.

Try It ➔

Save a Gmail email from a specific sender to Google Sheets as a new row

Use this template to save a Gmail message from a specific sender to your Google Sheets spreadsheet as a new row.

Try It ➔

Save Gmail emails and attachments to Google Sheets and Google Drive

Use this template to save a Gmail message to your Google Sheets spreadsheet as a new row and its attachments to Google Drive.

Try It ➔

Create a link in Rebrandly for each contact in Google Sheets and send it via Gmail

List all contacts in Google Sheets meeting specified criteria and create a link for each contact using Rebrandly. Contain the Rebrandly link in the e-mail for the recipient. Add the record with the e-mail address together with the Rebrandly link in Google Sheets, so this scenario can find which person clicked on the link.

Try It ➔

Automatically forward new Gmail emails containing a specific word to another email address

Every time a new email arrives in your Gmail mailbox, Make will check whether it contains a word that you specify. If yes, Make will forward that email to a specified email address.

Try It ➔

FAQ

How do I get started with Make?

What is a scenario?

What is a module?

What is mapping?

How Make works

Thousands of fast-scaling businesses create and automate on Make

See Make in action

See how Make works

Google Sheets and Gmail integrations

Build your Google Sheets and Gmail integrations.

Connect any app with Google Sheets and Gmail

How Make works

Trusted by 500,000+ Makers