How to import JSON into Google Data Studio

How to import JSON into Google Data Studio

I’m a bit late to the game and have only just discovered Google Data Studio and how it allows you to seriously level up your Analytics.

The tool lets you combine data from multiple sources and display them in graphs, tables and an array of other ways on your own personal analytics dashboard.

Better still, you can overlay information from these different sources onto one graph, so you can start to discover trends between your visitor data and, for example, sales, social media follows, and so on.

Connecting a JSON data source to Google Data Studio with a Connector

While you can add a CSV or spreadsheet into Data Studio for free, there isn’t yet a built in way to add a JSON data source to your Data Studio report, so you’ll need to use a 3rd party Connector.

A CSV is fine if you’re working with data that isn’t updated on a regular basis (as you’ll have to manually update your CSV or spreadsheet into Google Drive), but if you’re working with a dynamic and regularly updated data source, you’ll probably want to connect directly into a JSON feed.

Supermetrics has a number of Data Studio connectors, including a very simple and effective JSON data connector. You can use it to add any JSON data source directly into your Data Studio report, whether it’s publicly accessible or needs authentication.

Just sign up to Supermetrics here. They’ve got a 14 day trial which gets you access to all of their connectors, so you can try it out and see if it’s worth the investment.

Once you’re all signed up, sign into your Google Data Studio account and start a blank report.
Google Data Studio welcome screen, with 'Add Blank Report' button

Click into the ‘Connect to Data’ tab if you’re not already in it, and search for ‘custom json’.

The 'Add data to report' screen, with the ability to add a Custom JSON connector from Supermetrics

Under Partner Connectors, you should see ‘Custom JSON/CSV/XML by Supermetrics‘.

Click this and you’ll get to an Authorisation screen, and a title reading “Data Studio requires authorisation to use this community connector.

Click the blue ‘AUTHORISE’ button and follow the instructions, which grant Supermetrics permission to access your Google account.

Authorization screen to allow access to the Custom JSON / CSV / ML connector

Once done, a second Authorisation box should appear to the right of the first one, this time reading “Custom JSON/CSV/XML requires authorization to connect to data.

Click ‘AUTHORISE’ again. This time you’ll be prompted to sign into your Supermetrics account.

Now you can add the JSON source, specifying authentication if necessary. Once done, it’ll show up as a managed data source

The data sources screen showing Custom JSON on Google Data Studio

It will automatically refresh every 12 hours, which is fixed by Supermetrics. If you want to manually refresh the data, just edit the Data Source and click the ‘REFRESH FIELDS’ button at the bottom left.