Google Sheets, Autotask Integrations

Google Sheets
Autotask
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.

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 function. Sheets Add-On required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Autotask

Delete Entity

Deletes an Autotask entity.

Autotask

Update Entity

Updates an entity by its id.

Autotask

Create Entity

Creates any Autotask entity.

Autotask

Sparse Update Entity

Updates an entity with only the fields and UDFs that are provided. *Use this action instead of Update Entity when you need to update fields to blank values*.

Searches

Google Sheets

Get 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. This module doesn't return a row number.

Autotask

Get Zone Info

Gets Autotask zone information so web service calls are directed to the correct API service zone.

Autotask

Get Entity Info

Gets entity level metadata for all the exposed Autotask web service data entities.

Autotask

Search Accounts

Search for Accounts

Autotask

Get Field Info

Gets field and additional metadata for a given entity.

Autotask

Get UDF Info

Returns an array of User Defined Fields (UDFs) representing non-standard fields that can be used on a given entity.

Autotask

Query

Query any Autotask entity. Returns an array of entities meeting the search criteria.

Integrate Google Sheets, Autotask with these services