+are joining forces |Read moreabout the journey ahead!

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 New Contacts INSTANT

Triggers when a new contact is added in SmartTask

SmartTask

Watch New Tasks Added to Project INSTANT

Triggers when a new task is added to a project

SmartTask

Watch Tags 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 Custom Field Updates INSTANT

Triggers when the custom field is updated in a task

SmartTask

Watch Task Reminders INSTANT

Triggers on task reminder notification.

SmartTask

Watch Task Updates 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

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.

SmartTask

Add a Task Comment

Add comment to a task

SmartTask

Add File Link To Task

Add file link url to list of files in a Task

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

SmartTask

Update a Task's Description

Updates description of the task

SmartTask

Update a Task's Name

Update Taskname

SmartTask

Update a Task's Status

Update status of a 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

SmartTask

Search Contacts By Email or Phone Number

Fetches contacts as per queried email or phone number

SmartTask

Search Contacts By Name

Fetches Contacts with name matching the one in the query

SmartTask

Search Tasks

Search Tasks by tags, projects and contacts (Note: There is a limit of 10 pages or 500 tasks in place.)

Integrate Google Sheets, SmartTask with these services