Cin7 Looker Studio (Data Studio) Connector
Connect Cin7 to Google Looker Studio (formerly Data Studio) to automate your reporting and create insightful and actionable dashboards.
What Is The Cin7 Looker Studio Connector?
The Cin7 Looker Studio connector (Data Studio connector) allows you to get data from Cin7 into Looker Studio. Including:
Adjustments, Bom Masters, Branches, Branch Transfers, Contacts, Credit Notes, Payments, Product Categories, Product Options, Production Jobs, Products, Purchase Orders, Quotes, Sales Orders, Serial Numbers, Stock, Users and Vouchers.
How Does The Cin7 Looker Studio Connector Work?
- Sign Up To Solo Plan
- Create API Credentials in Cin7
- Connect Looker Studio to Cin7 Using API Credentials
- Start Creating Dashboards & Reporting!
See below for details.
Pricing To Suit The Stage Your Business
Connector prices are based on the plan you choose/have
Solo
For a user who needs one to a few connectors, usually for their own needs
$
0
/mo
- 1 User
- First Cin7 account free
- All other connectors one or more accounts free
- Additional Users
Cin7 Accounts
USD
Consultant
For a user that needs many different connectors. Eg to work with many clients
$
60
/mo
- 1 User
- First Cin7 account free
- All other connectors one or more accounts free
- Additional Users
Cin7 Accounts
USD
Team
For multiple users needing many connectors. Eg staff of an agency with many clients
Coming Soon!
$
120
/mo
- 3 Users
- Additonal Users ($5 each)
Cin7 Accounts
USD
How To Get Started?
First Sign Up to a Plan
Choose a Google Account to Sign-Up
Sign up and access to the connector is based on the Google Account used. Make sure you are signed in to the Google account you want to use in the same browser before you click try.
For users that use many Google Accounts in chrome however, it can be tricky to select the account you want to use, if it is not the default account. This is because the current behaviour of Data Studio sends the user to the home screen when they attempt to change their account from the default, using the selector to the top right. The easiest way around this is to make sure to set up a Profile in Chrome for the Google Account you want to use, and switch to that Profile
Click the Authorise Button
For the connector to work, it must be allowed by your Google Account. Clicking the Authorisation button shown will present dialogues in order to achieve this.
Authorise the Connector With Your Google Account
Ensure the Google Account you want to use is presented. Select the account and then allow the permissions.
Select a Plan
Select the free Solo Plan to get started. The connector will be added as an add-on to the plan, with a 14 day free trial, in a later step.
Review Order
Review the order.
Enter Your Name & Email
Enter your first and last name. The email should be the Google Account you intend to use Data Studio with and will be the main email associated the subscription.
By default the email of the Google Account you used with Looker Studio is populated (if changed it must me an email of a Google Account you intend to use with Looker Studio).
No billing information is required to get started!
Click Subscribe!
Click the subscribe button to get the Solo Plan.
Add Cin7 Connector To Plan
Add Connector
Select yes from the dropdown, then click Next to add the connector to your plan for a 14 day trial.
Connect Cin7 to Looker Studio
Get Cin7 API Credentials
Cin7 API credentials are needed to use this connector. In order to get your Cins7 API credentials, an API connection must be created in your Cin7 account.
To setup a Cin7 API Connection
- While logged in to your Cin7 account click here to setup an API connection.
- Select Add API Connection.
- Enter a name for your API connection in the App Name text box, and select Save.
- After save, you will see your API Key. Please save this somewhere safe as this will only be shown upon creating/adding an API connection.
- Create permissions for the API Connection by selecting Permissions next to the created API connection.
- Ensure the checkbox for Read permissions for Users is checked. This is used to verify your credentials when connecting Cin7 to Data Studio.
- Ensure the checkbox for Read permissions for Resources you want to access in Google Data Studio are checked (or trying to get data for those resource will fail).
- Have both your App Name and API Key ready for adding your Cin7 account to the Google Data Studio connector.
Add An Account
- Select Add an Account from Connector Management.
- Click Next until the Credentials screen is shown.
- Enter the App Name into the Username Field.
- Enter the API Key into the Token field.
- Click Submit.
About Cin7
Cin7 is a cloud-based inventory management software that helps businesses streamline and automate their inventory control, order management, and fulfillment processes. It integrates with e-commerce platforms, accounting systems, and shipping providers for real-time inventory visibility and synchronization.
About Looker Studio (Data Studio)
Looker Studio (formerly Data Studio) is a visualisation and reporting to offered by Google. With Looker Studio, users can connect, transform and visualise data from various sources, creating dynamic and interactive reports and dashboards.