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:

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

Blog

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

Meelad Mashaw

2 Different Methods of Importing JSON in Google Sheets

1. Use a Google Sheets Add-on

Tutorials

2. Use a publicly available script from Github + Google Apps Script

Join Our Newsletter. No Spam, Only the good stuff.

Related