Google Sheets, Gmail Integrations

Google Sheets
Gmail
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!

Google Sheets, Gmail 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


21
Parse email signatures and add/update contacts in a Google Sheets spreadsheet

Parse email signatures and add/update contacts in a Google Sheets spreadsheet

Parse Gmail emails using SigParser for the sender's signature details (phone, address, title...). Creates a new SalesForce contact or update an existing contact. Filters out automated/spam emails.


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


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


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


1

Triggers

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.

Gmail

Watch emails

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

Actions

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

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.

Gmail

Add labels

Adds labels to an email message.

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

Delete an email

Removes an email or a draft from a selected folder.

Gmail

Delete labels

Removes labels from an email message.

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.

Gmail

Set labels

Sets up new labels for an email message.

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 Google Sheets, Gmail with these services