bradjasper/ImportJSON
Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet observed · 2026-08-28
Health v2 · maintenance only
10/100
- Activity 0
- Release rhythm 35
- Longevity 100
Flags: no_releases archived
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 5040
- days_rel: n/a
- days_push: 1386
- n_releases_24m: 0
Adoption not part of the score
2131 stars · 1043 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
A Google Apps Script library that adds ImportJSON functions to Google Sheets, letting users import JSON from any URL directly into spreadsheet cells. It supports GET/POST requests, Basic Auth, and path-based filtering of JSON data.
Use cases
- import json from an api into google sheets
- pull cryptocurrency prices into a spreadsheet
- query a rest api from google sheets with a formula
- import json feed with basic auth into a sheet
- parse nested json into spreadsheet rows and columns
When to choose
- you want to fetch JSON APIs into Google Sheets without writing code
- you need a lightweight spreadsheet formula for JSON data
- you want POST or Basic Auth support in Sheets formulas
When to avoid
- the project is unmaintained and looking for a new developer
- you need Excel or other spreadsheet support
- you need guaranteed fixes for Google Apps Script API changes
Facets
library · maturity abandoned
parser json http-client developer-tools spreadsheets developer-tools data-science cli google-sheets google-apps-script spreadsheet-functions json-import api-data automation web-server
1 source
- readme: https://github.com/bradjasper/ImportJSON · fetched 2026-08-28 · 8adea5e5709a
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| bradjasper/ImportJSON | main | 10 |
For agents
markdown · JSON · MCP: product_card(name="bradjasper/ImportJSON")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem