bubastis
seanli1
/ JSONImporterExporter.gs
Last active
August 9, 2021 20:42
Import/Export JSON in Google Sheets - original: https://gist.github.com/pamelafox/1878143
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // IMPORT | |
| /** | |
| * Imports JSON data to your spreadsheet Ex: IMPORTJSON("http://myapisite.com","city/population") | |
| * @param url URL of your JSON data as string | |
| * @param xpath simplified xpath as string | |
| * @customfunction | |
| */ | |
| function IMPORTJSON(url,xpath){ | |