Fetch JSON from Any API
Connect to REST APIs, parse JSON responses, and pull live data directly into your spreadsheet. No backend required.
| A | B | C | |
|---|---|---|---|
| 1 | API Endpoint | Formula | JSON Data |
| 2 | api.weather.com/forecast | | — |
| 3 | api.github.com/repos/user | =AI_SCRAPE(A3, "repo name, stars") | awesome-project | 1,234 stars |
| 4 | api.coinbase.com/prices | =AI_SCRAPE(A4, "BTC price") | BTC: $43,567.89 |
API connectivity made simple
Fetch, parse, and transform API data directly in your spreadsheet.
JSON Parsing
Automatically parse JSON responses and extract fields.
REST APIs
Connect to any REST API endpoint with GET and POST.
Authentication
Support for API keys, OAuth, and custom headers.
Nested Data
Navigate deep JSON structures with simple dot notation.
Real-time Data
Fetch live data from APIs whenever your sheet refreshes.
Auto Refresh
Set up automatic data refresh on schedule.
API integration in action
See how to fetch and parse data from popular APIs.
=AI_SCRAPE("api.openweathermap.org/data/2.5/weather?q=NYC", "extract temperature, humidity, conditions")=AI_SCRAPE("api.coingecko.com/api/v3/simple/price?ids=bitcoin", "extract current price")=AI_SCRAPE("api.github.com/repos/facebook/react", "stars, forks, issues")=AI_SCRAPE(A2, "extract address, latitude, longitude")=AI_SCRAPE("api.store.com/products/123", "name, price, stock")=AI_SCRAPE("api.twitter.com/2/users/me", "followers, following, tweets")Frequently Asked Questions
Any REST API that returns JSON. Public APIs, authenticated APIs with API keys, and OAuth-protected endpoints with proper credentials.
Use JSONPath syntax to navigate nested structures. For example, 'data.users[0].name' extracts the name from the first user in a nested response.
Yes! Pass API keys as headers or query parameters. Store sensitive keys in a protected cell and reference them in your formula.
Data refreshes when the spreadsheet recalculates. For scheduled updates, use Google Sheets triggers or set up periodic refresh.
The function supports GET requests for data fetching. For POST/PUT/DELETE operations, you may need custom Apps Script.
Ready to connect your spreadsheet to APIs?
Fetch JSON data from any REST API.
Real-time data, automatic parsing, no coding.
No credit card required • Any REST API • Live data
