ImportJSON

The premium Open Source alternative to Supermetrics

🎯 Best for:Users needing to pull live API data into Google Sheets without recurring costs.

What is ImportJSON?

A Google Apps Script library that enables custom functions for fetching and parsing JSON APIs directly into spreadsheets. It automates the process of syncing external data sources without manual CSV exports.

Tech Stack
HTMLAutomation & Workflow

Why ImportJSON?

  • Zero infrastructure required
  • Easy setup via Apps Script
  • Completely free to use

Limitations

  • Google Sheets execution limits
  • No real-time streaming
  • Script execution timeouts
3/4/2026
Last Update
1,054
Forks
175
Issues
LGPL-3.0
License
Financial Leak Detected

Stop the "SaaS Tax"

Your team could be burning cash. Switching to ImportJSON instantly boosts your runway.

Competitor Cost
-$1,440
/ year (est. based on Supermetrics)
Self-Hosted
$0
/ year
Team Size10 Users
150+
SAVE 100%

Community Discussion

Comments