In today’s guide, discover everything you need to know about dynamically sharing your Go1 reporting data using the URL available in Administer reports.
You might previously have spotted this button when creating reports in Go1, it asks if you want to make the data from this report available through a URL - continue reading if you want to find out how to use the link to generate reports in a Google Sheet application.
Important: It's worth noting, given you are transmitting data from a web application like Go1, the link that is generated is in the form of a JSON file and therefore it will require some manual steps and data manipulation to make the information consumable.
If you do follow the steps, it is a clear process to create a report outside of Go1.
In this article, we will be using Google Sheets for dynamic reporting. Google Sheets is a free application but you will need to set up an account here.
In your original Google Sheet tab, input this formula into the bar:
= ImportJSON ("link", "/hits/hits/")
Example: =ImportJSON("https://share.go1.co/reports/1b9ukk4j5nujsgoeg2jkv5nfucd4e6ha", "/hits/hits/")
As you can see, now you can access all the Go1 data (including the meta-data) from the original Go1 customer report, in your Google sheet. It is available for you to dynamically share outside of the Go1 Platform.
JSON has limitations, it can only show you all the data or one specific piece of meta-data.
If there is a single piece of information from the original Go1 report you want to display in the report. You can easily choose to limit it by using one of these suggested additions to the end of the formula.