Google Sheets, Capsule CRM, Trello Integrations

Capsule CRM
Google Sheets
Trello
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.

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.

Trello

Watch Activities

Triggers when a new activity occurs.

Trello

Watch Activities INSTANT

Triggers when new activity occurs.

Trello

Watch Attachments

Triggers when a new attachment is added to a card.

Trello

Watch Boards

Triggers when a new board is added.

Trello

Watch Cards

Triggers when a new card is added.

Trello

Watch Cards Moved to a List

Triggers when a card is moved to a specific list.

Trello

Watch Comments

Triggers when a new comment is added.

Trello

Watch Notifications

Triggers when you have a new notification.

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.

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

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.

Trello

Add a Label to a Card

Adds an existing label to a card.

Trello

Add a Member to a Card

Adds a selected member to a card.

Trello

Add an Attachment

Adds an attachment to a card.

Trello

Archive or Unarchive a Board

Archives or unarchives a board.

Trello

Archive or Unarchive a Card

Archives or unarchives a card.

Trello

Archive or Unarchive a List

Archives or unarchives a specific list.

Trello

Assign a Member to a Board

Assigns a specific member to a board.

Trello

Create a Board

Creates a new board.

Trello

Create a Card

Creates a new card.

Trello

Create a Comment in a Card

Creates a new comment in a specific card.

Trello

Create a Custom Field

Creates a new custom field on a board.

Trello

Create a Checklist

Creates a checklist on a given card.

Trello

Create a Checklist Item

Creates new checklist item to a specific checklist.

Trello

Create a Label

Creates a new label on a board.

Trello

Create a List

Creates a new list.

Trello

Delete a Card

Deletes a card.

Trello

Delete a Comment in a Card

Deletes a comment in a specific card.

Trello

Delete a Checklist

Deletes a specified checklist.

Trello

Delete a Label

Deletes a label.

Trello

Delete an Attachment

Deletes an attachment from a card.

Trello

Edit a Board

Edits an existing board.

Trello

Edit a Card

Edits an existing card.

Trello

Edit a Comment in a Card

Edits an existing comment in a specific card.

Trello

Edit a Checklist Item

Updates an item in a checklist on a card.

Trello

Edit a Label

Edits an existing label.

Trello

Edit a List

Edits an existing list.

Trello

Get a Board

Retrieves a board by ID.

Trello

Get a Card

Retrieves a card by ID.

Trello

Get a Custom Field

Retrieves information about a specific custom field.

Trello

Get a Checklist

Retrieves information about a specific checklist.

Trello

Get a Label

Gets information about a specific label.

Trello

Get a List

Retrieves a list by ID.

Trello

Get an Attachment

Gets a specific attachment on a card.

Trello

Make an API Call

Performs an arbitrary authorized API call.

Trello

Remove a Label from a Card

Removes a label from a card.

Trello

Remove a Member from a Card

Removes a specific member from a card.

Trello

Remove an Item from Checklist

Removes an item from checklist.

Trello

Set a Custom Field on a Card

Sets or updates a custom field value on a card.

Trello

Unassign a Member from a Board

Unassigns a specific member from a specific board.

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.

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.

Trello

Get a Card Checklists

Retrieves all checklists for given card.

Trello

Get Board Lists

Retrieves all lists from a given board.

Trello

Get Custom Field Options

Retrieves options of dropdown custom field.

Trello

List Attachments

Lists attachments on a card.

Trello

List Comments in a Card

Retrieves a list of comments for a card.

Trello

List Labels

Retrieves all labels from a board.

Trello

Search for Boards

Returns boards matching the search query.

Trello

Search for Cards

Returns cards matching the search query.

Trello

Search for Members

Returns members matching the search query.

Trello

Search for Organizations

Returns organizations matching the search query.