Blendr.io is an embedded integration and automation platform for SaaS companies
Offer your customers comprehensive integrations between your SaaS platform, Google Sheets and Marketo
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 Marketo to sync data between cloud tools, trigger certain actions in Google Sheets and Marketo 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.
Marketo
List new leads incrementally
List programs
List programs by tag
Create program
List new and updated programs incrementally
Delete lead
Get lead
Search leads by email
List new and updated lead changes incrementally
When working with sizeable data amounts in Marketo, we recommend using a different endpoint as this one approaches lead changes by paging through all lead changes in Marketo.
Create or update lead
List all lead ids
List leads by program
List new and updated leads by list incrementally
List leads by list
Push lead
List new and updated leads by program incrementally
Push lead
Upserts a lead and generates a Push Lead to Marketo activity.
Create or update lead
List leads by list
List lists
Add lead to list
Check list membership for lead
Get list
Remove lead from list
Create bulk lead extract job
List bulk lead extract jobs
Start bulk lead extract job
Get bulk lead extract job status
List leads from bulk extract job
List bulk activity jobs
Create bulk activity extract job
List activities from bulk extract job
Start bulk activity extract job
Get bulk activity extract job status
List activity types
Describe object
Add lead activity
List activities
List activities of lead
When working with sizeable data amounts in Marketo, we recommend using a different endpoint as this one approaches lead activities by paging through all lead activities in Marketo.
Add lead activities
List new activities incrementally
Create custom activity type
List custom lead activity types
Get custom activity type
Approve custom activity type
Add attribute to custom activity type
Remove attribute from custom activity type
Delete custom activity type
Describe all custom objects
Describe custom object
List custom object records
Create or update custom object
Delete custom object
List smart campaigns
List new and updated smart campaigns incrementally
List companies
Raw API list request
Raw API create or update request
Raw API request
Need another feature from Marketo?
Contact us, our
dedicated team can usually add new features in 48 hours.