Google Sheets, Tools Integrations

Google Sheets
Tools
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, Tools integrations

Add new Google Calendar events to a Google Sheet spreadsheet as new rows and get the updated spreadsheet via email

Add new Google Calendar events to a Google Sheet spreadsheet as new rows and get the updated spreadsheet via email

Every time a new event is created in a Google calendar, Integromat will automatically add that event to a selected Google Sheet spreadsheet as a new row. The spreadsheet will be then sent to a specifed email address . This template uses a spreadsheet created according to this example.

Get RSS feed updates in a single email summarizing all posts that contain a specific keyword

Get RSS feed updates in a single email summarizing all posts that contain a specific keyword

Integromat will watch RSS feeds you specify in a Google Sheets spreadsheet for new posts that contain a specific keyword. It will merge all these posts into a single email summary and send it to a specific email address. If you wish to use this template without further modification, you need to create a spreadsheet exactly according to this example. In the RSS column, you specify the RSS feeds you want to watch and in the KEYWORD column the keyword to find.

Send email when a specified name is added to a Google Sheets spreadsheet

Send email when a specified name is added to a Google Sheets spreadsheet

Integromat watches a certain column in a Google Sheets spreadsheets for specified names being added. If any of these names appear in the column, Integromat will automatically send a message to a specified email address.

Update selected Google Sheets rows with Google Analytics visits to specific websites

Update selected Google Sheets rows with Google Analytics visits to specific websites

Every time this scenario is run, Integromat will automatically update selected Google Sheets rows with Google Analytics data. This template monitors the number of visits to specified websites for last 7 and 365 days. It uses a spreadsheet created according to this example.

Get a Google Sheet spreadsheet with 15 days weather forecast via email

Get a Google Sheet spreadsheet with 15 days weather forecast via email

Integromat will automatically add 15 days weather forecast to a Google Sheet spreadsheet as new rows and send that spreadsheet to an email address you specify. This template uses a table created according to this example.

Add new WooCommerce orders to a Google Sheet spreadsheet as new rows and at the same time save the WooCommerce order details as a text file to a new Dropbox folder created by Integromat

Add new WooCommerce orders to a Google Sheet spreadsheet as new rows and at the same time save the WooCommerce order details as a text file to a new Dropbox folder created by Integromat

Every time a new order is created in WooCommerce, Integromat will automatically add that order to a new row in a Google Sheets spreadsheet. At the same time, Integromat will create a new Dropbox folder and save the WooCommerce order details to that folder as a text file.

Send data received by a ManyChat bot to a webhook, search through a Google sheet and respond with a dynamic Gallery

Send data received by a ManyChat bot to a webhook, search through a Google sheet and respond with a dynamic Gallery

This is a ManyChat template wherein a bot's custom fields data is received by a webhook, a Google Sheet search is performed, and a response is sent back to the ManyChat bot user in the form of a dynamic gallery.

Triggers

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT_EXEC 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.

Tools

Basic trigger

Generates bundles with their own structure.

Transformers

Tools

Compose a string

Composes a string for easier mapping of scenarios.

Tools

Convert the encoding of a text

Converts a text from one codepage to another.

Tools

Switch

Switches the output based on the input.

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

Get a Cell

Gets a specific cell.

Google Sheets

Perform a Function - Responder

Returns processed data as a result of the INTEGROMAT_EXEC function. Sheets Add-On Required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Tools

Get variable

Get the value of a previously stored variable.

Tools

Increment function

Returns a value of 1 after first run. Every subsequent run will increment the returned value by 1.

Tools

Set variable

Sets the value of the variable.

Tools

Sleep

Delays execution for a specified period of time.

Aggregators

Tools

Numeric aggregator

Applies the aggregate function to selected rows.

Tools

Table aggregator

Aggregates selected values into a table.

Tools

Text aggregator

Aggregates multiple strings into one text.

Searches

Google Sheets

Get a Range Values

Gets a range content.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

Returns results matching the given criteria.

Integrate Google Sheets, Tools with these services