Blendr.io is an embedded integration and automation platform for SaaS companies

Offer your customers comprehensive integrations between your SaaS platform, Google Sheets and Pipedrive

Fast, flexible and powerful integrations

Blendr.io is an embedded integration platform for SaaS companies. Use the Blend Editor to create comprehensive integrations between your SaaS platform and 500+ marketing, sales and events cloud tools without coding.

Integrate your SaaS platform with Google Sheets and Pipedrive to sync data between cloud tools, trigger certain actions in Google Sheets and Pipedrive when some data changes in your SaaS platform and the other way around.

Supported features

Google Sheets

Get spreadsheet info by id
Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID
Create spreadsheet
Creates a spreadsheet, returning the newly created spreadsheet.
Remove sheet from spreadsheet
Deletes the requested sheet. Mention the ID of the sheet to delete.
Add sheet to spreadsheet
Adds a new sheet. When a sheet is added at a given index, all subsequent sheets' indexes are incremented.
List spreadsheets
Returns a list of all spreadsheets with id and names.
Delete spreadsheet
Deletes the spreadsheet with the fileid provided.
List sheets of spreadsheet
Returns info of all the sheets present in a given spreadsheet, as per the id.
Get data from spreadsheet
Append rows to sheet
Append one row to sheet
Delete rows
Clear sheet
Update range in sheet
Get data from sheet with headers
Update range in sheet
Set cell background color
Sets the background color of the cell. Represents a color in the RGBA color space.
Get data from sheet
Allows you to read values from cells, ranges, sets of ranges and entire sheets.
Append rows to sheet
Appends values to a spreadsheet. The input range is used to search for existing data and find a "table" within that range. Values will be appended to the next row of the table, starting with the first column of the table.
Append one row to sheet
Appends one row to the to a spreadsheet.
Delete rows
Allows you to remove rows in sheets
Clear sheet
Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept.
Get data from sheet with headers
Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.
Update range in sheet
Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range.
Update cell
Sets value of a cell in the row and column mentioned of a spreadsheet. The caller must specify the spreadsheet ID, row, column.
Append one row to sheet
Appends one row to the to a spreadsheet.
Append rows to sheet
Appends values to a spreadsheet. The input range is used to search for existing data and find a "table" within that range. Values will be appended to the next row of the table, starting with the first column of the table.
Update cells in sheet
Update row in sheet
Sets values in a row of a spreadsheet.
Get file info
Gets file info of the mentioned file id from google drive
Need another feature from Google Sheets?
Contact us, our dedicated team can usually add new features in 48 hours.

Pipedrive

List contacts
Create contact
Update contact
Delete contact
Search contacts by name
Pipedrive is removing this version of API (https://pipedrive.readme.io/docs/new-search-api-migration-guide). Please move to the newest version of the endpoint.
Get contact
Search contacts by email
Pipedrive is removing this version of API (https://pipedrive.readme.io/docs/new-search-api-migration-guide). Please move to the newest version of the endpoint.
List new updated and deleted contacts incrementally
Search contacts
Search contacts by name
Search contacts by email
Create company
Update company
Delete company
List companies
Search company by name
Pipedrive is removing this version of API (https://pipedrive.readme.io/docs/new-search-api-migration-guide). Please move to the newest version of the endpoint.
Get company
List new updated and deleted companies incrementally
Search company by name
List contact fields
List company fields
List deal fields
Search objects by field
Works only with the following field types: varchar, varchar_auto, double, address, text, phone, date
Create activity
List activities
List activity types
List deals
Create deal
Update deal
List products attached to a deal
Get deal
List deals summary
List new updated and deleted deals incrementally
Search deals
Search deals by person id
Add product to the deal
List users
Get user
Get user by name
Get user by email
List new and updated users incrementally
Get user subDomain
List pipelines
List pipeline stages
Get stage
Create note
List products
Get product
List product fields
Get product fields
List deals attached to a product
Create product
Update product
List new updated and deleted objects incrementally
List objects
Get object
Create object
Update object
Delete object
List leads
Get lead
List lead labels
List lead sources
Create lead
Create lead label
Delete lead
Delete lead label
Update lead
Update lead label
List new updated and deleted leads incrementally
Get subscription
Get subscription by deal
Need another feature from Pipedrive?
Contact us, our dedicated team can usually add new features in 48 hours.

Integrate your SaaS platform with 500+ cloud tools

Use Blendr.io to add comprehensive integrations to your SaaS platform

More about Blendr.io