Google Sheets, SmartTask Integrations

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

SmartTask

Watch: On Tag added to Task INSTANT

Triggers when a particular tag is added to a task in the organization

SmartTask

Watch: Task Completion INSTANT

Triggers when a task is completed in a project

SmartTask

Watch: Task Reminders INSTANT

Triggers on task reminder notification.

SmartTask

Watch: Task Update INSTANT

Triggers when tasks are updated in a project

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.

SmartTask

Add Task Reminder

Adds reminder to a task

SmartTask

Create Contact

Creates a new contact in SmartTask

SmartTask

Create Task

Creates a new task in SmartTask

SmartTask

Get Task

Fetches a particular task

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.

SmartTask

Get Project Members

Fetches all project members

SmartTask

Get Subtasks

Fetches subtasks of a task

SmartTask

Get Task Contacts

Fetches contacts attached in a task

SmartTask

Get Task Reminders

Fetches reminders set on a task

Integrate Google Sheets, SmartTask with these services