loading...
Cover image for How To Import JSON In Google Sheets (With & Without Code)

How To Import JSON In Google Sheets (With & Without Code)

meeladmashaw profile image Meelad Mashaw Updated on ・3 min read

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

Posted on by:

meeladmashaw profile

Meelad Mashaw

@meeladmashaw

Hey I'm Meelad from Silicon Valley. I worked in tech for a few years and now I do digital marketing for SaaS.

Discussion

pic
Editor guide