Google Sheets, Ganttic, Google Data Studio Integrations

Ganttic
Google Data Studio
Google Sheets
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.

Ganttic

Watch Project Created INSTANT

Triggers when a new project has been created.

Ganttic

Watch Project Deteled INSTANT

Triggers when a project has been deleted.

Ganttic

Watch Project Updated INSTANT

Triggers when a project has been updated.

Ganttic

Watch Resource Created INSTANT

Triggers when a new resource has been created.

Ganttic

Watch Resource Deleted INSTANT

Triggers when a resource has been deleted.

Ganttic

Watch Resource Updated INSTANT

Triggers when a resource has been updated.

Ganttic

Watch Task Created INSTANT

Triggers when a new task has been created.

Ganttic

Watch Task Deleted INSTANT

Triggers when a task has been deleted.

Ganttic

Watch Task Updated INSTANT

Triggers when a task has been updated.

Google Data Studio

New Request INSTANT

Triggers when Google Data Studio requests Integromat for new data.

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

Make an API Call

Performs an arbitrary authorized API call.

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.

Ganttic

Create a Project

Creates a new project.

Ganttic

Create a Resource

Creates a new resource.

Ganttic

Create a Task

Creates a new task.

Ganttic

Delete a Project

Deletes a project.

Ganttic

Delete a Resource

Deletes a resource.

Ganttic

Delete a Task

Deletes a task.

Ganttic

Get a Project

Retrieves an existing project.

Ganttic

Get a Resource

Retrieves an existing resource.

Ganttic

Get a Task

Retrieves an existing task.

Ganttic

Make an API Call

Performs an arbitrary authorized API call.

Ganttic

Update a Project

Updates an existing project.

Ganttic

Update a Resource

Updates an existing resource.

Ganttic

Update a Task

Updates an existing task.

Google Data Studio

New Response

Send data back from Integromat to Google Data Studio.

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.

Ganttic

Search Projects

Searches for projects or lists them all.

Ganttic

Search Resources

Searches for resources or lists them all.

Ganttic

Search Tasks

Searches for tasks or lists them all.