Cin7 Core

Google Sheets + Cin7 Core Integration

Query from Cin7 Core into Google Sheets 

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho, Zendesk, Twitter, etc. 


It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on. 

What is Cin7 Core?

Cin7 Core, formally known as DEAR, is an app that makes enterprise-level inventory management, manufacturing, sales integration, reporting, and automation accessible to all businesses. 

Cin7 Core and Google Sheets: Use Cases

> Query: Pull data from Cin7 Core and present on Google Sheets

Cin7 Core

Sheet Director

Google Sheets

Setting up Cin7 Core in Sheet Director

Choose App and Service:

How to get API Key

Query from Cin7 Core and present on Google Sheets

Destination Settings:

Scheduler Settings:

Notification Settings:

Sample Output

Bulk post data from Google Sheet into Cin7 Core

Choose App and Service:

Source Sheet

(the default value is A1, if you change the value you need to refresh the header by clicking on refresh icon on side)


Sample data & Output

It will show the count of number of records posted successfully and failed to post.

Google Sheet to Cin7 Core - Sync

Synchronize settings:

Synchronization Keys:

The keys will be used for matching rows in Google Sheets with data in Cin7 Core.

Conflict Resolution: 

Cin7 Core Wins: Latest data from Cin7 Core will be updated in Google Sheets.

Google Sheet Wins: Latest data from Google Sheets will be updated in Cin7 Core.

Note: The major requirement in synchronization is the synchronize keys. If any of the keys is not having a value in the Google Sheet then Sheet Director will create it first and then the service will be executed.

Cin7 Core Wins

Sample Output

Cin7 Core Wins

Sample Output