Cin7 Omni

Google Sheets + Cin7 Omni Integration

Query from Cin7 into Google Sheets and post data from Google Sheets into Cin7 Omni

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 Omni?

Cin7 Omni is a fully integrated, cloud-based inventory management software that streamlines stock management across multiple channels. Solutions Connected Inventory 

Cin7 Omni and Google Sheets: Use Cases

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

> Bulk Post: Post data from Google Sheets into Cin7 Omni.

Demo Video: How to integrate Google Sheets & Cin7 Omni?

Setting up Cin7 Omni in Sheet Director

Choose App and Service:

How to get API Key

Query from Cin7 Omni and present on Google Sheets

Destination Settings:

Scheduler Settings:

Notification Settings:

Sample Output

Bulk post data from Google Sheet into Cin7 Omni

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 Omni - Sync

Synchronize settings:

Synchronization Keys:

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

Conflict Resolution: 

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

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

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 Omni Wins

Sample Output

Google Sheet Wins

Sample Output