New: SHEETAI_API & SHEETAI_PJSON Functions

SHEETAI_API — Call Any API from a Cell

Make HTTP requests to any REST API directly from Google Sheets. Fetch live data, send form submissions, update external systems — all from a spreadsheet formula.

1. 1Type =SHEETAI_API("url") in any cell to make a GET request
2. 2Add method, headers, body for POST/PUT/PATCH/DELETE requests
3. 3Use the keyPath parameter to extract a specific value from the JSON response

Use Case: Live Currency & Crypto Prices

Pull real-time exchange rates and cryptocurrency prices directly into your spreadsheet. Great for financial dashboards, pricing sheets, and expense tracking across currencies.

Use Case: Company & Domain Enrichment

Have a list of domains or company names? Enrich them with metadata — logo URLs, descriptions, social profiles, employee counts. Turn a plain list into a research database.

Use Case: Weather Data for Any Location

Building a travel planner, event spreadsheet, or logistics tracker? Pull current weather for any city.

Use Case: GitHub & Dev Metrics

Track open-source project stats, monitor your repos, or build a developer dashboard inside Google Sheets.

Use Case: IP Geolocation & Visitor Data

Look up geographic info for IP addresses — useful for analytics, fraud detection, or understanding where your traffic comes from.

Use Case: Send Data to External Services (POST)

Not just reading data — you can also send data. Submit form entries, create records in your CRM, trigger webhooks, or post to Slack.

SHEETAI_PJSON — Parse JSON in Cells

When you have JSON data stored in a cell (from an API response or any other source), use SHEETAI_PJSON to extract exactly the value you need using dot notation and array indexing.

1. 1Put your JSON string in a cell (e.g. A1)
2. 2Use =SHEETAI_PJSON(A1, "path.to.value") to extract a specific field
3. 3Supports nested objects and arrays: "data.users[0].name", "results[2].email"