Cin7 Omni

Google Sheets + Cin7 Omni Integration

Integrate Cin7 Omni and Google Sheets and automate data flows: Query, Post and Sync

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. 

Installation:

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.

> Sync: Synchronize data between Google Sheets and Cin7 Omni.

Looking for Cin7 Core integration? Check out Cin7 Core 

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)


Mapping

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