Asana, Capsule CRM, Google Sheets Integrations

Asana
Capsule CRM
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

Asana

Watch New Projects

Checks whether new projects have been made.

Asana

Watch New Stories

Checks whether new (task) stories have been made.

Asana

Watch New Tags

Checks whether new tags have been made.

Asana

Watch New Tasks

Checks whether new tasks have been made.

Asana

Watch Webhook Events INSTANT

Watches webhook events.

Capsule CRM

Watch Cases INSTANT

Triggers when a case is created, updated or deleted.

Capsule CRM

Watch new Cases

Checks if a new case was created.

Capsule CRM

Watch new Opportunities

Checks if a new opportunity was created.

Capsule CRM

Watch new Parties

Checks if a new party was created.

Capsule CRM

Watch new Tasks

Checks if a new task was created.

Capsule CRM

Watch Opportunities INSTANT

Triggers when an opportunity is created, updated or deleted.

Capsule CRM

Watch Parties INSTANT

Triggers when a party is created, updated or deleted.

Capsule CRM

Watch Tasks INSTANT

Triggers when a task is created, updated or deleted.

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

Asana

Add an Option to a Custom Field

Creates an enumeration option for a custom field.

Asana

Add a Story Comment

Adds a comment to a task.

Asana

Add a Task to a Project

Adds a task to a project or section at a specific location.

Asana

Add a User to a Team

Adds a user to a team.

Asana

Create a Custom Field

Creates a (workspace) custom field.

Asana

Create a Project

Creates a project.

Asana

Create a Project Section

Creates a project section.

Asana

Create a Project Status

Creates a project status.

Asana

Create a Tag

Creates a tag.

Asana

Create a Task or a Subtask

Creates a task or a subtask.

Asana

Delete a Custom Field

Deletes a custom field.

Asana

Delete an Attachment

Deletes an attachment.

Asana

Delete a Project

Deletes a project.

Asana

Delete a Project Section

Deletes a project section.

Asana

Delete a Project Status

Deletes a project status.

Asana

Delete a Story

Deletes a story.

Asana

Delete a Task

Deletes a task.

Asana

Duplicate a Project

Duplicates a project.

Asana

Duplicate a Task

Duplicates a task.

Asana

Get a Custom Field

Retrieves a (workspace) custom field.

Asana

Get an Attachment

Retrieves an attachment.

Asana

Get a Project

Retrieves a project.

Asana

Get a Project Section

Retrieves a project section.

Asana

Get a Project's Task Count

Retrieves the task count of a project.

Asana

Get a Project Status

Retrieves a project status.

Asana

Get a Story

Retrieves a (task) story

Asana

Get a Tag

Retrieves a tag.

Asana

Get a Task

Retrieves a task.

Asana

Get a Team

Retrieves a team.

Asana

Get a User

Retrieves a user.

Asana

Get a Workspace

Retrieves a workspace.

Asana

Make an API Call

Performs an arbitrary authorized API call.

Asana

Move a Project Section

Moves a project section relative to other project sections in the project's board view.

Asana

Remove a Task from a Project

Removes a task from a project.

Asana

Remove a User From a Team

Removes a user from a team.

Asana

Update a Custom Field

Updates a custom field.

Asana

Update a Custom Field Option

Updates an enumeration option.

Asana

Update a Project

Updates a project.

Asana

Update a Project's Custom Fields

Updates the custom fields of a project.

Asana

Update a Project Section

Updates a project Section.

Asana

Update a Story

Updates a Story.

Asana

Update a Tag

Updates a tag.

Asana

Update a Task

Updates a task.

Asana

Update a Task's Dependencies

Updates the dependencies of a task. A task can have maximum 15 dependencies.

Asana

Update a Task's Dependents

Updates the dependents of a task. A task can have maximum 30 dependents.

Asana

Update a Task's Followers

Updates the followers of a task.

Asana

Update a Task's Parent

Updates the parent task of a task.

Asana

Update a Task's Tag

Updates a tag of a task.

Asana

Update a Workspace's Users

Updates the users of a workspace.

Asana

Upload an Attachment

Uploads an attachment to a task.

Capsule CRM

Add an Additional Party in Case

Adds an person or organisation as an additional contact to the case.

Capsule CRM

Add an Additional Party in Opportunity

Adds an person or organisation as an additional contact to the opportunity

Capsule CRM

Create a Case

Creates a new case.

Capsule CRM

Create a Custom Field

Creates a new party, opportunity or case custom field.

Capsule CRM

Create a Milestone

Creates a new opportunity milestone.

Capsule CRM

Create an Entry

Creates a new entry.

Capsule CRM

Create an Opportunity

Creates a new opportunity.

Capsule CRM

Create a Party

Creates a new party.

Capsule CRM

Create a Tag

Defines a new party, opportunity or case tag.

Capsule CRM

Create a Task

Creates a new task.

Capsule CRM

Create a Task Category

Creates a new task category.

Capsule CRM

Create a Track

Applies a track definition to a case or opportunity to create a track.

Capsule CRM

Delete a Case

Deletes a specific case.

Capsule CRM

Delete a Custom Field

Removes a custom field from your capsule account

Capsule CRM

Delete a Milestone

Removes a Milestone from the capsule account. You cannot delete a Milestone while it is still being used on an Opportunity. First you need to update the Milestone on all such Opportunities.

Capsule CRM

Delete an Entry

Removes an entry from the capsule account and any associated attachments.

Capsule CRM

Delete an Opportunity

Deletes a specific opportunity.

Capsule CRM

Delete a Party

Deletes a specific party.

Capsule CRM

Delete a Tag

Removes a tag from the capsule account. NOTE that this will remove the tag from any parties, opportunities and cases it was assigned to.

Capsule CRM

Delete a Task

Deletes a specific task.

Capsule CRM

Delete a Task Category

Removes a category from your capsule account. Any tasks under this category will be retained but will become uncategorized.

Capsule CRM

Delete a Track

Removes a track and related tasks from case or opportunity.

Capsule CRM

Make an API Call

Performs an arbitrary authorized API call.

Capsule CRM

Remove an Additional Party in Case

Removes that person or organisation as an additional contact of the case.

Capsule CRM

Remove an Additional Party in Opportunity

Removes a party or organisation as an additional contact of the opportunity.

Capsule CRM

Show a Case

Shows a specific case

Capsule CRM

Show a Custom Field

Shows a specific custom field.

Capsule CRM

Show a Milestone

Shows a specific milestone.

Capsule CRM

Show an Entry

Shows a specified note, email or the details of a completed party task.

Capsule CRM

Show an Opportunity

Returns a specific opportunity.

Capsule CRM

Show a Party

Shows a specific person or organisation.

Capsule CRM

Show a Tag

Shows a specific tag.

Capsule CRM

Show a Task

Shows a specific task.

Capsule CRM

Show a Task Category

Shows a specific task category.

Capsule CRM

Show a Track

Shows a specific track.

Capsule CRM

Update a Case

Updates an existing case

Capsule CRM

Update a Custom Field

Updates the details of a party, opportunity or case field definition.

Capsule CRM

Update a Milestone

Updates the name, description or probability of a milestone.

Capsule CRM

Update an Entry

Updates the content of notes and emails.

Capsule CRM

Update an Opportunity

Updates an existing opportunity

Capsule CRM

Update a Party

Updates an existing party. Fields that are not included in the request will remain unchanged.

Capsule CRM

Update a Tag

Updates the details of a party, opportunity or case tag.

Capsule CRM

Update a Task

Updates an existing task.

Capsule CRM

Update a Task Category

Allows to rename or change the colour of the task category.

Capsule CRM

Update a Track

Updates basic details about a track.

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.

Searches

Asana

List a Project's Custom Fields

Retrieves all the custom fields of a project.

Asana

List a Project's Sections

Retrieves all sections of a project.

Asana

List a Task's Attachments

Retrieves all attachments of a task.

Asana

List a Task's Dependencies

Retrieves all the dependencies of a task.

Asana

List a Task's Dependents

Retrieves all the dependents of a task.

Asana

List a Task's Projects

Retrieves the projects of a task.

Asana

List a Task's Stories

Retrieves the stories of a task.

Asana

List a Task's Subtasks

Retrieves the subtasks of a task.

Asana

List a Task's Tags

Retrieves all the tags of a task.

Asana

List a Team's Users

Retrieves the users in a team.

Asana

List a User's Teams

Retrieves all teams of a user.

Asana

List a Workspace's Custom Fields

Retrieves all custom fields of a workspace.

Asana

List a Workspace's Teams

Retrieves all teams in an organization.

Asana

List a Workspace's Users

Retrieves all users in an organization.

Asana

List Projects

Retrieves all projects.

Asana

List Project's Statuses

Retrieves the history of project statuses of a project.

Asana

List Tags

Retrieves all tags.

Asana

List Tasks

Retrieves tasks of a workspace, project, tag or assignee.

Asana

List Users

Retrieves all users.

Asana

List Webhooks

Retrieves all registered webhooks.

Asana

List Workspaces

Retrieves all workspaces.

Capsule CRM

List Additional Parties in Case

Lists additional parties related to specific case.

Capsule CRM

List Additional Parties in Opportunity

Lists additional parties related to specific opportunity.

Capsule CRM

List Cases

Lists all cases.

Capsule CRM

List Custom Fields

Lists all custom fields.

Capsule CRM

List Deleted Cases

Lists all deleted cases.

Capsule CRM

List Deleted Opportunities

Lists all deleted opportunities.

Capsule CRM

List Deleted Parties

Lists all parties that have been deleted from capsule since the date specified in the since parameter.

Capsule CRM

List Employees

Lists all employees linked to specific organisation.

Capsule CRM

List Entries

Lists notes, emails and completed tasks for parties, cases and opportunities.

Capsule CRM

List Entries by Date

Lists notes, emails and the details of completed party tasks in descending order starting with the most recent entry date first.

Capsule CRM

List Milestones

Lists all milestones.

Capsule CRM

List Opportunities

Lists all opportunities.

Capsule CRM

List Opportunities by Party

Lists all opportunities associated with the specific party.

Capsule CRM

List Parties

Lists all parties.

Capsule CRM

List Tags

Lists all tags for either party, opportunity or case.

Capsule CRM

List Task Categories

Lists all task categories.

Capsule CRM

List Tasks

Lists all tasks.

Capsule CRM

List Track Definitions

Lists track definitions with the option to filter for only the track definitions for cases or opportunities.

Capsule CRM

List Tracks

Lists tracks for a specific case or opportunity.

Capsule CRM

Search Cases

Searches for cases. This will return the same results as the global search inside Capsule.

Capsule CRM

Search Opportunities

Searches for opportunities. This will return the same results as the global search inside Capsule.

Capsule CRM

Search Parties

Searches for parties. This will return the same results as the global search inside Capsule.

Capsule CRM

Show Multiple Cases

Allows to load a list of cases by providing their unique ids.

Capsule CRM

Show Multiple Opportunities

Returns a list of opportunities, specified by the opportunityIds provided.

Capsule CRM

Show Multiple Parties

Allows to load a list of parties by providing their unique ids.

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.