2 Different Methods of Importing JSON in Google Sheets
In this article we'll discuss a couple different ways you can consume JSON in Google Sheets.
1. Use a Google Sheets Add-on
There's a Google Sheets add-on called Apipheny that you can use to import JSON into Google Sheets.
Here's the steps:
A. Install Apipheny in the G-Suite Marketplace
B. Open a Google Sheet
C. Click "Add-ons" > Apipheny > Import API
D. In the sidebar, enter your JSON API URL and headers/key
E. Click "Run"
Your JSON data will then import into your Google Sheet.
Demo video: Pull API into Google Sheets
Pros:
- Easy to use
- No scripts/code required
- GET and POST requests
- Advanced features and functionality
Cons:
- Costs money but has a free trial
Tutorials
Here's some tutorials showing you how to use the Apipheny add-on to connect various APIs to Google Sheets:
Connect Youtube API to Google Sheets
Connect Quickbooks API to Google Sheets
Connect Coinmarketcap API to Google Sheets
Connect Surveymonkey API to Google Sheets
Connect Paypal API to Google Sheets
Connect Github API to Google Sheets
Connect Facebook Page API to Google Sheets
Connect Binance API to Google Sheets
Connect Facebook Ad API to Google Sheets
Connect Hubspot API to Google Sheets
Connect Trello API to Google Sheets
Connect Asana API to Google Sheets
Connect Harvest API to Google Sheets
Connect WorldTradingData API to Google Sheets
Connect Mailchimp API to Google Sheets
Connect Typeform API to Google Sheets
Connect Shopify API to Google Sheets
Connect CoinAPI to Google Sheets
2. Use a publicly available script from Github + Google Apps Script
You can import JSON into Google Sheets using a publicly available script from Github.
To import JSON data into Google Sheets using Google Apps Script, follow these steps:
A. Open a Google Sheet
B. In the menu, choose "Tools" > "Script Editor"
C. Delete the content that's in the editor
D. Copy and paste a script from Github such as this one into the editor
E. Choose "File" > "Save"
F. Title the code "ImportJSON"
G. Close Script Editor and go back to the Google Sheet
H. In the A1 cell, type ImportJSON("X") but replace X with your API endpoint
I. Press enter and the JSON will be imported into your Google Sheet
Pros:
- Free
Cons:
- Limited in functionality
- Requires some coding
Disclosure: I am the co-founder of Apipheny
Top comments (1)
Great blog post and video! I really liked the approach you described in the blog post. While researching this topic, I also stumbled upon this other article showing a bit different way of automating JSON import to Google Sheets that might be of interest to your audience blog.coupler.io/how-to-import-json...