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 Sheets spreadsheet as new rows and email it to a specified email address

Add new Google Calendar events to a Google Sheets spreadsheet as new rows and email it to a specified email address

Every time a new event is created in a Google calendar, Integromat will automatically add that event to your Google Sheets spreadsheet as a new row. The spreadsheet will be then sent to a specified email address. The template uses this example spreadsheet.


188
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 settings, you need to create a spreadsheet 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.


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


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


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


68
Import Wild Apricot registrations to an event

Import Wild Apricot registrations to an event

This template creates registrations in a Wild Apricot event based on the information in Google sheet


66
Export Wild Apricot registrations into Google sheet

Export Wild Apricot registrations into Google sheet

This template exports registrations from an event into Google sheet.


26
Create a reservation system using ManyChat and Google Sheets

Create a reservation system using ManyChat and Google Sheets

This scenario connects ManyChat and Google Sheets as part of a reservation system built for an AI-enhanced chatbot powered by ManyChat and Janis.ai


25
Social media distribution system

Social media distribution system

This scenario handles social media distribution system where the row with content is randlomly selected and the content is published to specified social media account. Here, the Facebook Pages, Twitter and LinkedIn social accounts are used.


13

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.

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

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.

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 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, Tools with these services