SmartTask, BigQuery, Airtable Integrations

Airtable
BigQuery
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

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

BigQuery

Watch Query Jobs Completed

Triggers when a query job has completed processing successfully or unsuccessfully.

BigQuery

Watch Tables

Triggers when a new table is created in a dataset.

Airtable

Watch Records

Returns all newly created or updated records in a view (requires "Created Time" or "Last Modified Time" fields).

Airtable

Watch Responses INSTANT

Triggers when a new response is submitted.

Actions

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

BigQuery

Create a Dataset

Creates a new dataset.

BigQuery

Create a Table

Creates a new, empty table in the dataset.

BigQuery

Delete a Dataset

Deletes the dataset specified by ID.

BigQuery

Delete a Table

Deletes the table specified by ID.

BigQuery

Get a Dataset

Returns the dataset specified by dataset ID.

BigQuery

Get a Table

Gets the specified table resource by table ID.

BigQuery

Make an API Call

Performs an arbitrary authorized API call.

BigQuery

Update a Dataset

Updates information in an existing dataset.

BigQuery

Update a Table

Updates information in an existing table.

BigQuery

Upload a File

Uploads a new file.

BigQuery

Upload Data (Streaming)

Creates a new row of data in a table.

BigQuery

Write Query

Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.

Airtable

Create a Record

Creates a new record in Airtable.

Airtable

Delete a Record

Deletes a record by its ID.

Airtable

Get a Record

Retrieves a single record by its ID.

Airtable

Make an API Call

Performs an arbitrary authorized API call.

Airtable

Update a Record

Updates a record by its ID.

Airtable

Upsert a Record

Creates new or updates an existing record.

Searches

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.)

BigQuery

List Datasets

Lists all datasets in the specified project to which the user has been granted the READER dataset role.

BigQuery

List Jobs

Lists all jobs that user started in the specified project.

BigQuery

List Table Data

Lists the content of a table in rows.

BigQuery

List Tables

Lists all tables in the specified dataset.

Airtable

Search Records

Searches for specific records or returns all records.