Salesforce-icon-color

Salesforce

Microsoft Dynamics 365 - Icon

Microsoft Dynamics 365

Asana-icon-color

Asana

Zendesk Sell

Monday-icon-color

Monday

ConnectWise - Icon

ConnectWise

Airtable-icon-color

Airtable

Pipedrive - Icon

Pipedrive

Copper - Icon

Copper

Smartsheet

Mindbody - Icon

Mindbody

SugarCRM - Icon

SugarCRM

Workfront-icon-color

Workfront

Zoho CRM - Icon

Zoho CRM

Trello - Icon

Trello

Pipeliner-icon-color

Pipeliner

Freshsale

Freshsales

Virtuous-icon-color

Virtuous CRM

AgileCRM-icon-color

Agile CRM

Wrike

List worksheets

Perform a raw HTTP request with some pre-configuration and processing by the connector, such as authentication.

Raw HTTP request (advanced)

Add values to spreadsheet

Create column headers for sheet

Add a column or row to the end of a Google Sheet.

Create empty column or row

Create row

Create a new spreadsheet for your Google Sheets.

Create spreadsheet

Create worksheet

Delete column

Delete worksheet

Get row by index

Get details about a spreadsheet, including information about its worksheets.

Get spreadsheet details

Get total active rows

Get data from a worksheet of a spreadsheet.

Get worksheet data

Get data from a worksheet of a spreadsheet using a cell range.

Get worksheet data using range

Insert empty column

Insert empty row

List worksheet column headers DDL

List worksheet column headers using ID DDL

Set the value of an individual cell in a Google Sheet.

Update cell value

Update a row, by its number, within a worksheet.

Update row

Delete row

Get rows

List worksheet column headers

Update the values of a spreadsheet in a given range.

Update values in spreadsheet

marketing tools by tray.io

How Automation is Changing the Face of Business

hot-topics-blog-header-3@2x

Streamline strategic sales with an automated deal desk

Tray-IO Blog 6

The ultimate guide to automating the entire lead lifecycle

Vox Media is on the Tray platform

Vox Media connects and automates pre- and post-sales to streamline workflow

business-automation blog post cover image

business-automation

GDPR compliance for US companies: What you need to know

Connector Department - All - Cards

New Relic - Full - Dark

New Relic - Anonymous

Google Sheets - Icon

Google Sheets

Project Management

Get box

Creates a comment associated with a particular box.

Create comment

Searches for box by name using an exact search.

List boxes

Assigns an email (thread) to a box.

Use the Gmail API to obtain the thread ID.

Assign email to box

Gets a contact by providing the contact key.

Get contact

List current user's teams

Assign organisation to box

Updates the message text of a specific comment.

Update comment

List comments (beta)

Gets a given organization by providing the contact key.

Get organization

List organizations

Moves boxes to a different pipeline (batch).

Update pipelines of boxes

Updates an organization by providing the organization key.

Update organization

Updates a pipeline.

To change the fields or the stages property, you must use different endpoints. The fields and stages are only provided as a convenience here. The necessary endpoints are specified in the Field and Stage section of this document.

Update pipeline

Deletes a pipeline. You can only delete pipelines that are empty and have no boxes in them.

Delete pipeline

Lists the field values for the box specified.

List field values for box

Lists all files associated with a particular box.

You can only get the contents of files that are of the type GMAIL_API.

List files in box

List pipelines

List teams

List fields in pipeline

Gets binary contents of file.

The mime type of the response contents is based on the file type.

Get file contents

List boxes in pipeline

Creates a field for a pipeline.

This defines the field in the pipeline so that you can add values for that field for each box in the pipeline.

Create field

Delete comment

Get task

Deletes a contact by providing the contact key.

Upon deleting a contact, the contact will also be removed from any associated boxes.

Delete contact

Deletes an organisation by providing the organisation key.

Upon deleting a organisation, the organisation will also be removed from any associated boxes.

Delete organisation

Updates multiple fields at once in a box.

Update fields in box

Creates a box based on the Pipeline Key you provide.

Create box

Lists all tasks associated with a particular box.

List tasks in box

Get comment

Get current user

Get file

Gets a specific stage defined in a pipeline.

Get stage

Create stage

Update stage

Update box

Gets the public details for the user specified.

Get user

Deletes a particular box. Also deletes all of the relevant data such as files, emails, and tasks for that box.

Delete box

Get thread

Get team

Deletes a stage defined in a pipeline.

This call will only succeed if there are no boxes tagged with the key of this stage, else it throws a 400.

Delete stage

List fields in pipeline DDL

Deletes a field defined in a pipeline.

Note: this will also remove the values of this field for every box in the pipeline.

Delete field

Lists all the threads in a particular box.

List threads in box

Gets a specific field defined in a pipeline.

Get field

List stages

Delete task

List stages DDL

Update field

Updates the value of a field for a particular box.

Update field value

A search by query which returns results on orgs, boxes and contacts.

List boxes, contacts and organisations

Update task

Updates a contact by providing the contact key.

Update contact

Creates a new contact.

All contacts are scoped to a particular team so a Team Key is required. Contacts must have at least one of Name or Email Address set.

Create contact

Create pipeline

Creates a new organisation.

All organisations are scoped to a particular team so a Team Key is required. Must have at least one of Name or Domains set.

Create organisation

Get pipeline

Create task

LEAD-LIFECYCLE

How to Automate Lead-to-Account Matching

sales marketing mix

Sales ops best practices

pipedrive-color-logo

Pipedrive's CRM integrates with the Tray Platform to provide full visibility for sales activities and connect them to all other components of the sales & marketing stack.

Google Sheets and Streak integration + automation

Popular Google Sheets and Streak integrations

Google Sheets and Streak Connector Details

Google Sheets

Streak

Tray is the leading AI ready integration and automation platform

Similar connectors to Google Sheets and Streak