Integrate Google Sheets with Exact Online

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

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

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 Exact Online to sync data between cloud tools, trigger certain actions in Google Sheets and Exact Online when some data changes in your SaaS platform and the other way around.

All Connectors

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

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?

Exact Online

List account owners

List contacts

Create contact

Get contact

List new and updated contacts incrementally

Update contact

List contacts in division

List new and updated contacts in division incrementally

List opportunities

List purchase invoices

Create purchase invoice

List purchase invoice lines

Create purchase invoice line

List sales invoices

Search sales invoices for account

Create sales invoice

Get sales invoice

Update sales invoice

Delete sales invoice

Get sales invoice line

Create sales invoice line

Update sales invoice line

Delete sales invoice line

List new and updated sales invoices incrementally

Print sales invoice

List new and updated purchase invoices incrementally

Get purchase invoice

List journals

Approve purchase

List sales orders

Get sales order

Create sales order

List sales orders lines

Get sales order line

Create sales order line

List goods deliveries

Create goods delivery

List goods delivery lines

Create goods delivery line

List shipping methods

Update sales order

Delete sales order

Update sales order line

Delete sales order line

Get goods delivery

Update goods delivery

Get goods delivery line

Update goods delivery line

Create invoice sales order

Create sales order

Update sales order

Get purchase order

List new and updated sales orders incrementally

List accounts

Get account

Get account in division

Create account

Create a new account

Update account

Update an account

List new and updated accounts incrementally

List accounts in division

List new and updated accounts in division incrementally

List projects

Search projects for account

Update project

Create project

Delete project

Get work breakdown structure (WBS) by project

Search opportunities for account

Create opportunity

Update opportunity

List divisions

Get division

Add address to entity

By specifying the account/contact id(or both) it will link this address to that account/contact.

Update entity address

List addresses

List bank accounts

Get bank account

Create bank account

Create a new bank account

Update bank account

Update a bank account

List GL accounts

List API rate limitations

List direct debit mandates

Get direct debit mandate

Create direct debit mandate

Create a new account

Update direct debit mandate

Generic create

Generic update

Generic delete

Generic get

Generic list

List items

List warehouses

Get item

Create item

Update item

Delete item

List subscriptions

List subscription lines

Get subscription

Get subscription line

Delete subscription line

Delete subscription

Create subscription line

Create subscription

List item groups

Get item group

Update subscription line

Update subscription

List new and updated subscription lines incrementally

List subscription types

List lines from subscription

List new and updated subscription incrementally

List users

List documents

List document attachments

Get PDF file

Returns the base64 encoded image of the PDF document

Get UBL XML of invoice

Returns the XML UBL of the invoice

List transaction lines

List general journal entries

List general journal entry lines

Create general journal entry

List general ledger accounts

Get transaction line

Get general journal entry

Get general journal entry line

Get general ledger account

List receivables

List revenue list by year

List revenue

List reporting balance

List reporting balance by classification

List GLSchemes

Get receivable

Get reporting balance

List quotations

Need another feature from Exact Online?

Integrate your SaaS platform with 500+ cloud tools

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

More about Blendr.io