How to link gini to Google Data Studio
In order to leverage the power of Google Data Studio, we recommend using a connection method that leverages the native Google Sheet connector rather than a 3rd party connector.
Sign up to gini
Click here to see how to Sign Up
Create the Financial Report Dashboard
This dashboard contains a Google Sheet with data in an optimal format for GDS
To create the data required to power your GDS Dashboard, find the “Financial Performance Dashboard” flow in the gini webapp. Ensure you have connected the required apps - this flow requires at least one accounting app (either Xero or QuickBooks) and Google Sheets.
Then from the flow page, select the organisation you want to create the report for and click the “Create Report” button.
Once your flow is created, you will be able to find it in the “My flows” section of the dashboard. Click on the “Open flow” button to see the report in Google Sheets.
Link your GDS to your Google Sheet Data
We have created an intermediary sheet that contains all of the journals needed to power the dashboard. This is not designed to be edited by a user
- In the top left, click
Createor start with a
- Select Data Source.
- Select the Google Sheets connector.
- Select the gini spreadsheet you just created - named “gini - [Company Name] - Financial Performance Dashboard”
- Select the Worksheet with the suffix
- Make sure that the option to “Use first row as headers” is enabled, and type in
A4:Kas the Optional Range
- Connect the data source
- Create your GDS report