Cin7 to Google Sheets: Query from Cin7 into Google Sheets using Sheet Director.

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?

Cin7 is a fully integrated, cloud-based inventory management software and POS system that streamlines stock management across multiple channels.

Cin7 to Google Sheets: Use Case

> Pull all data from Cin7 and store it into a Spreadsheet.


Sheet Director

Google Sheets

Setting up Cin7 in Sheet Director

Choose App and Service:

  • Select Cin7 from the list of applications.

  • Select service as Query.

  • Authorize Sheet Director to access your account.

  • Mention your User Name.

  • Mention the API Key.

  • Click on Connect to CIN7 to connect with Sheet Director.

How to get API Key

  • Go to Your Cin7 Account → Settings

  • From the Settings , choose “ Integrations” and then click on “ API v1 “

  • From the screen appearing, you will be able the see the API Username.

  • Then click Add API Connection

  • Give an APP name.

  • After save, you will get to see the API key.

  • Select the required entity.

  • Select the fields that are required.

  • Select the Max Results required.

Destination Settings:

  • Configure the destination settings to save the executed data.

Scheduler Settings:

  • Switch on Run automatically to execute services automatically in background.

Notification Settings:

  • Configure the Notification settings to setup the email templates and add attachments.

  • Click Execute to execute the services.

  • Click Save to save the services.

  • Click Back to exit.

Sample Output