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.

Update your Google Sheets with data parsed from Gmail and send a reply automatically

Update your Google Sheets with data parsed from Gmail and send a reply automatically

A simple Text parser module with Gmail and Google Sheets. Use case scenario is when you receive bookings, orders etc via email. The text parser module will help you to parse text from the email. The regex code used can be used as a guideline to capture multiple groups in regex and be able to map them accordingly. The Google sheet link is shared here. The regex code used can be found under this link.

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

Watch a worksheet

Triggers when a user adds a new row to a selected worksheet.

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

Google Sheets

Update a row

Google Sheets

Delete a row

Google Sheets

Select rows

Returns rows that match the criteria specified in a selected worksheet.

Google Sheets

Update a cell

Google Sheets

Add a worksheet

Google Sheets

Delete a worksheet

Google Sheets

Get a cell

Returns the contents of a specified cell.

Google Sheets

List worksheets

Gets a list of worksheets in spreadsheet.

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.

Integrate Google Sheets, Tools with these services