Google Sheets, Tools, Autopilot Integrations

Google Sheets
Tools
Autopilot
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!

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.

Autopilot

Watch Events INSTANT

Responds to events (contact added, updated, unsubscribed, added to list, removed from list, entered segment and left segment). Will return related contact ID, contact and possibly related list ID or segment ID.

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.

Autopilot

Add Contact to Journey

Add contacts to journeys.

Autopilot

Add Contact to List

Adds a contact to a list.

Autopilot

Add List

Add a new list.

Autopilot

Create Contact

Allows you to create or update a contact.

Autopilot

Delete Contact

Removes the contact from your database.

Autopilot

Delete Contact Activity Feed

Deletes the activity feed of a contact.

Autopilot

Get Contact

Retrieves the given contact record given the contact ID or email.

Autopilot

Get Email

Retrieves an email campaign's data based on an ID received in the Autopilot Activity Stream.

Autopilot

Check if Contact on List

Checks if a contact belongs to a particular list.

Autopilot

Make an API Call

Performs an arbitrary authorized API call.

Autopilot

Remove Contact from List

Removes a contact from a list.

Autopilot

Unsubscribe Contact

Unsubscribes the contact from receiving emails from your Autopilot Journeys.

Autopilot

Update Contact

Updates the details of a contact. This method will return the contact's ID number.

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.

Autopilot

List all Contacts

Returns a list of your contacts.

Autopilot

List all Lists

Returns a list of all available lists.

Autopilot

List Contacts on List

Returns a list of all of the contacts which are on this list.

Autopilot

List Contacts on Smart Segment

Returns a list of all of the contacts which are on this smart segment.

Autopilot

List Journeys with API Triggers

Returns a list of API Triggers along with the journey name to help you identify the correct one.

Autopilot

List Smart Segments

Returns a list of all available smart segments.