Gmail, Google Sheets Integrations

Gmail
Google Sheets
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Gmail, Google Sheets integrations

Create a Document from a Template when a new row is added in a Google Sheet

Create a Document from a Template when a new row is added in a Google Sheet

Every time a new row is added in a Google Spreadsheet, Integromat will automatically create a new Google Doc from a previously created Google Docs template. Then it is attached and sent by email. This example uses the sample sheet in this link and the sample template in this Google Docs document


201
Add client inbox label to Gmail

Add client inbox label to Gmail

When an email is received, 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, prompting Google Multiple Inboxes filter to show that email in the “Client Inbox”. More information here.


34
Add a new record to Google Sheets about a new project in BeLazy and upload files to Google Drive

Add a new record to Google Sheets about a new project in BeLazy and upload files to Google Drive

When a new project is approved, data of the project are stored in a Google Sheets spreadsheet and the files are uploaded to Google Drive. If the file is bigger than 50MB, the e-mail with the notification about this issue is sent to Gmail.


13
Send a Gmail email from a new Google Sheets row

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.


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

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.


9
Save Gmail emails and attachments to Google Sheets and Google Drive

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.


4
Save a Gmail email to Google Sheets as a new row

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.


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

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.


2
Create GIF with GIPHY from Google Sheet rows and send an email

Create GIF with GIPHY from Google Sheet rows and send an email

Every time a new Google Sheets row is created, Integromat will automatically translate a word to a GIF using GIPHY and send it in an email. This example uses the spreadsheet in this link.


2

Triggers

Gmail

Watch emails

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

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Google Sheets

Watch Changes INSTANT

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

Google Sheets

Watch Rows

Watches for new rows.

Actions

Gmail

Copy an email

Copies an email or a draft into a selected folder.

Gmail

Create a draft

Creates a new draft and adds it to a selected folder.

Gmail

Delete an email

Removes an email or a draft from a selected folder.

Gmail

Mark an email as read

Marks an email or a draft in a selected directory as read by setting the "Read" flag.

Gmail

Mark an email as unread

Marks an email or draft in a selected directory as unread by setting the "Unread" flag.

Gmail

Modify email labels

Modifies labels on the specified email message.

Gmail

Move an email

Moves a chosen email or a draft to a selected folder.

Gmail

Send an email

Sends a new email.

Google Sheets

Add a Row

Appends a new row to the bottom of the table.

Google Sheets

Add a Sheet

Adds a new sheet.

Google Sheets

Clear a Cell

Cleares a specific cell.

Google Sheets

Clear a Row

Clears values from a specific row.

Google Sheets

Create a Spreadsheet

Creates a new spreadsheet.

Google Sheets

Delete a Row

Deletes a specific row.

Google Sheets

Delete a Sheet

Deletes a specific sheet.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Make an API Call

Performs an arbitrary authorized API call.

Google Sheets

Perform a Function - Responder

Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Iterators

Gmail

Iterate attachments

Iterates through received attachments.

Searches

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

List Sheets

Gets a list of all sheets in a spreadsheet.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

Returns results matching the given criteria. This module doesn't return a row number.

Integrate Gmail, Google Sheets with these services