What is JSON?
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.