Blendr.io is an embedded integration and automation platform for SaaS companies
Offer your customers comprehensive integrations between your SaaS platform, Google Sheets and SugarCRM
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 SugarCRM to sync data between cloud tools, trigger certain actions in Google Sheets and SugarCRM 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.
SugarCRM
List contacts
Get contact
Create contact
Link contact with account
Update contact
List new and updated contacts incrementally
Create contact
Update contact
List contacts
Get contact
Link contact with account
List new and updated contacts incrementally
Create contact
Update contact
Search Contacts by Email
Link Contact to Opportunity
List Contacts Linked to an Opportunity
Delete contact
Get contact
Link contact with account
Create contact
Update contact
Link Contact to Opportunity
List Contacts Linked to an Opportunity
List leads
Get lead
Create lead
Update lead
Search leads by website
Search leads by postal code
List leads
Get lead
Create lead
Update lead
Search leads by website
Search leads by postal code
List new and updated leads incrementally
Delete lead
Get lead
Create lead
Update lead
List opportunities
Get opportunity
List new and updated opportunities incrementally
Search Opportunities by Account Id
List opportunities
Get opportunity
List new and updated opportunities incrementally
Search Opportunities by Account ID
Create opportunity
Update opportunity
Delete opportunity
Get opportunity
Search Opportunities by Account ID
Update opportunity
Create email address
Link email address with entity
Create email address
Link email address with entity
Link email address with entity
Create account
Update account
Get account
List accounts
List new and updated accounts incrementally
Create account
Update account
Get account
List accounts
List new and updated accounts incrementally
Delete account
Create account
Update account
Get account
List users
List new and updated users incrementally
List users
List new and updated users incrementally
List calls
Get call
Create call
List calls
Get call
Create call
Get call
Create call
Create note
Get siteURL
returns the site url requested while connecting the datasource
Search records by name
Search records by id
Get fields from a module
Create note
Search records by name
Search records by ID
List fields from a module
Create note
Search records by ID
List quotes
List quotes
List products
Products are called "Quoted line items" in the SugarCRM UI
List products
Products are called "Quoted line items" in the SugarCRM UI
Search accounts by website
Search accounts by website
Raw API request
Raw API list request
Need another feature from SugarCRM?
Contact us, our
dedicated team can usually add new features in 48 hours.