JSON to Google Sheets JSON + Google Sheets to JSON Google Spreadsheets =

KPIBees Google Add-on.

How to import JSON to Google Sheets

What is JSON?

JSON, also known as JavaScript Object Notation,  is an open standard and data interchange format that empowers much of communications done today by modern software applications.

It’s an incredibly compact format that requires a lot less storage space than XML and it’s even a lot more easier to read! But even in a beautified form, when we try to understand it something is just not there – you got it, it’s not in a spreadsheet!

One easy way to pull your JSON to spreadsheets is with the Google Sheets Add-on KPIBees. With just a few clicks, JSONs can be imported into Google Sheets. 

Connect JSON data to Google Sheets

Step 1: Go to the KPIBees Gsuite Marketplace listing  and install the Google Sheets Add-on.

Step 2: Grant access to KPIBees on your Google account – we are GDPR compliant!

Step 3: Open any google spreadsheet and go to Add-ons in the page menu and click on Launch.

Step 4: Click on the JSON integration.

Step 5:  Add your JSON url and click save.

Connect JSON API to google sheets

 

Here all the integrations to Google Sheets that KPIBees supports.