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
Local processing
Simple #JSONERROR! feedback
API exports
Pull IDs, prices, statuses, and nested fields out of webhook payloads or copied API responses.
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 Apps Script.