JSON.parse()

Google Sheets: Spreadsheets, Add Sheet

Add-ons / 2020-10-05 2021-01-20 / bearer(oauth2Token), Google Sheets API v4, JSON.parse()

Adds a new sheet to the end of the spreadsheet. If the specified sheet name already exists, this Automated Task will end with an error. If needed, SheetId can also be specified.

Google Sheets: Master Table, Simple Xlookup

Add-ons / 2020-02-06 2021-01-20 / bearer(oauth2Token), Google Sheets API v4, JSON.parse()

Returns a value by referencing master data in Google Spreadsheets. Searches for the Lookup Value in array C, and if an exact match, returns the value in array D at the same index. C and D are defined in A1Notation. The length must be the same.