[Blog](/blog) # Go1 product guide: JSON files Learn some tips and tricks of your Learning Platform, in this month's Go1 Product Guide. Published on August 01, 2019Last updated on September 02, 2026 ![Go1 product guide: JSON files](https://images.prismic.io/go1-com/aD_7v7h8WN-LVkgI_3fe2934e2bc30f540a0de7dd84760ad9a2231a57_screen-shot-2019-01-07-at-4.04.47-pm.png?auto=format%2Ccompress&fit=max&w=1920) ## Summary JSON report URLs let administrators move Go1 reporting data into tools such as Google Sheets for dynamic analysis and sharing. The process uses an ImportJSON function to retrieve report data and place selected fields into a spreadsheet. JSON exports can return the complete dataset or a specific piece of metadata, so the chosen path must match the reporting goal. Once configured, the sheet can refresh from the source URL and reduce the need to copy report results manually. ## Key takeaways * If you do follow the steps, it is a clear process to create a report outside of Go1. * In your original Google Sheet tab, input this formula into the bar. * JSON has limitations, it can only show you all the data or one specific piece of meta-data. * In today’s guide, discover everything you need to know about dynamically sharing your Go1 reporting data using the URL available in Administer reports. * In this article, we will be using Google Sheets for dynamic reporting. In today’s guide, discover everything you need to know about dynamically sharing your Go1 reporting data using the URL available in Administer reports. ![](https://images.prismic.io/go1-com/aD_7v7h8WN-LVkgI_3fe2934e2bc30f540a0de7dd84760ad9a2231a57_screen-shot-2019-01-07-at-4.04.47-pm.png?auto=format,compress) 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. ### Where do I find a link to share my reports? * Reporting is available to Admins via the Administer tab. * Within each reporting tab, you will find the first report, which is a pre-configured by Go1 with your user data. ![](https://images.prismic.io/go1-com/aD_6W7h8WN-LVkfM_cc0c56503eaa11a4222834a2e509b9076f49e062_screen-shot-2019-01-07-at-4.53.21-pm.png?auto=format,compress) * For each custom report you create, you will be able to generate a shared link. Select save-as for the share button to appear. _The pre-configured reports provided, do not create a shared link._ ### How do I use the link? 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](https://accounts.google.com/signup/v2/webcreateaccount?hl=en-AU&flowName=GlifWebSignIn&flowEntry=SignUp). * After creating your report in Go1 and generating a URL link, you will need to create a _new_ blank Google Excel Spreadsheet. * On your spreadsheet - select Tools from the top navigation bar-> and then Script Editor. ![](https://images.prismic.io/go1-com/aD_6bbh8WN-LVkfY_626d6f1f67197923d5ffda4b42850436efa541d6_screen-shot-2019-02-05-at-12.16.14-pm.png?auto=format,compress) * Google script will load in a new tab: _Delete all My function text from the sheet._ * Paste the code from [here](https://go1-com.cdn.prismic.io/go1prod/b2a78b66-7c60-456b-8f4d-5a91e6af9410%5Fin+tools+add+script+editor+add+rename+ImportJSONgs.txt) into the blank sheet. * From the top navigation bar of the script editor, select _File > Rename_. Rename the script: ImportJSON.gs * Click _Save_ ![](https://images.prismic.io/go1-com/aD_6jrh8WN-LVkfb_d696ebf759010fc11eb55675b0731cbe9d69d30d_screen-shot-2019-02-05-at-12.18.33-pm.png?auto=format,compress) ### Using the URL: ### In your original Google Sheet tab, input this formula into the bar: \= ImportJSON ("link", "/hits/hits/") ![](https://images.prismic.io/go1-com/aD_6nLh8WN-LVkfd_16c7ad61f96df79fe92f5cb16024800d882af34d_screen-shot-2019-02-05-at-12.19.51-pm.png?auto=format,compress) * "Link" is where you insert the share link from your Go1 report. Example: _https://share.go1.co/reports/1b9ukk4j5n..._ * "/hits/hits" - do not edit the format. _Example: =ImportJSON("https://share.go1.co/reports/1b9ukk4j5nujsgoeg2jkv5nfucd4e6ha", "/hits/hits/")_ ![](https://images.prismic.io/go1-com/aD_6s7h8WN-LVkfi_8da1a4e9dbeef8cfb2f8766731ac5dbc1efcc903_screen-shot-2019-02-05-at-12.21.10-pm.png?auto=format,compress) 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. ### Important: 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. * "/hits/hits/\_source/title" * "/hits/hits/\_source/name" * "/hits/hits/\_source/submitted\_date" * "/hits/hits/\_source/instance\_id" * "/hits/hits/\_source/lo\_id" (if its an LO) ![Stay Ahead in L&D](/_next/image?url=https%3A%2F%2Fcdn.go1static.com%2Fassets%2F202609101234%2F_next%2Fstatic%2Fmedia%2Fsubscribe.81448f2d.png&w=1920&q=75) ## Stay Ahead in L&D Subscribe to our emails to receive newsletters, product updates, and marketing communications. ## Related Articles [![](https://images.prismic.io/go1-com/cNPrv2JkHqEplA1W_compliance-readiness.png?auto=format%2Ccompress&fit=max&w=3840)BlogCompliance Training vs. Compliance Readiness: What 945 Leaders and Employees Told Us7 minute read](/blog/compliance-training-readiness)[![Guide to HR compliance training for employees](https://images.prismic.io/go1-com/VxnjXSyiF3xEoQS__hr-compliance-training-for-employees.png?auto=format%2Ccompress&fit=max&w=3840)BlogHR compliance training for employees: The essential topics every workplace must cover in 20267 minute read](/blog/workplace-compliance-training/hr-compliance-training-for-employees)[![Guide to health and safety compliance training](https://images.prismic.io/go1-com/tJT4Q2QbyEYwl0EY_health-and-safety-compliance.png?auto=format%2Ccompress&fit=max&w=3840)BlogHealth & safety compliance training: How to create a safe workplace environment13 minute read](/blog/workplace-compliance-training/health-and-safety-compliance)[![Guide to ethics and compliance training](https://images.prismic.io/go1-com/kX41hF_EFpynVKgc_ethics-and-compliance-training.png?auto=format%2Ccompress&fit=max&w=3840)BlogEthics and compliance training: How to build an ethical, accountable workforce8 minute read](/blog/workplace-compliance-training/ethics-and-compliance-training) ## Train smarter, spend less Connect with a Go1 expert to explore the best training options for your organization—no pressure, just solutions that work. [Speak with an expert](/speak-with-an-expert)