# bradjasper/ImportJSON

Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet

Repository: https://github.com/bradjasper/ImportJSON
Canonical: https://ross.abutalabs.com/products/importjson
Language: HTML
License: LGPL-3.0
License Family: copyleft
Topics: spreadsheet, google-sheets, importjson, parsing, cryptocurrencies
Archived: true
Last push: 2022-11-16T19:26:06+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 5040, "days_push": 1386, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, archived
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2131, forks 1043 (observed 2026-08-28T04:06:17.196000+00:00)

## What it is
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
- artifact type: library
- maturity: abandoned
- function: parser, json, http-client, developer-tools
- domain: spreadsheets, developer-tools, data-science
- platform: cli
- tags: google-sheets, google-apps-script, spreadsheet-functions, json-import, api-data, automation, web-server

## Member repositories
- bradjasper/ImportJSON (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:17.196000+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:52:07.640912+00:00, confidence not recorded.
  - readme: https://github.com/bradjasper/ImportJSON (fetched 2026-08-28T04:06:17.196000+00:00, sha 8adea5e5709a)
- Data as of 2026-08-30T08:39:29.467469+00:00.