Import JSON Google Sheets - How To Parse JSON in Google Sheets

Опубликовано: 29 Март 2026
на канале: Apipheny

20,060

159

Here's the 2 best ways to import JSON into Google Sheets. The first method involves copying and pasting a publicly available importjson script from Github. The second method involves installing a Google Sheets add-on called Apipheny that allows you to GET and POST JSON directly from your Google Sheet.

Learn more: https://apipheny.io

Install Apipheny Here: https://apipheny.io/install

Import JSON script on Github: https://gist.github.com/paulgambill/c...

import JSON Tutorial/Blog Post: https://apipheny.io/import-json-googl...

Apipheny Website: https://apipheny.io

Apipheny Tutorials: https://apipheny.io/tutorials/

Contact Nate Page: https://www.nathanielpage.me/

JSON API URLs for testing:
Pokemon API: https://pokeapi.co/api/v2/pokemon/1/
Cat Facts API: https://cat-fact.herokuapp.com/facts
Chuck Norris Jokes API: https://api.chucknorris.io/jokes/random

Table of contents:
0:00 Introduction
1:35 ImportJSON with free Github script
5:54 Importing JSON with Apipheny.io