Cin7

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

What is Sheet Director?

Sheet Director is a G Suite 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 G Suite Marketplace. Please check 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.

Cin7

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