PARSEJSON reference
ParseJSON
Extract nested fields from JSON strings with a formula-first JSONPath function built for spreadsheet workflows.
JSONPath-style paths
Range input support
Parses supplied JSON text
Native errors with IFERROR
API exports
Extract identifiers, prices, statuses, and nested fields from webhook payloads or API responses already copied into cells.
Bulk cleanup
Point the same path at an entire column of JSON strings and spill clean results into adjacent cells.
Schema exploration
Use wildcards, indexes, slices, and filters to inspect messy data without writing Google Apps Script™.