Google Sheets: Download Choice Data
Download Choice Data in specified 2 columns from Google Sheet.
JSON.parse()
Google Translate: Translation API Basic, Translate
Translates using Google Translation API v2. Specifying the target language is mandatory, but specifying the source language is optional (Detected). The NMT model is applied, but in some languages the PBMT model is applied.
OpenWeather: Weather History, Get by Time
Gets weather history for the specific time from OpenWeather (corrected to zero minutes) with the specified latitude and longitude. Temperature, humidity and wind speed can be obtained as well as snow volume and wind gust.
NHK Program Guide: Programs, Search
Searches the program guide of the specified area channel and date. You can filter by keywords, program genre or time range. The keyword search is applied to the string that combines the program title, subtitle, content, and performers.
OpenWeather: Weather Forecast, Get by Time
Gets weather forecast for the specific time (corrected to zero minutes) from OpenWeather with specifying latitude and longitude of the world. Not only temperature, humidity and wind speed, but also visibility and sensible temperature can be obtained.
OpenWeather: Weather Forecast, Get by Date
Gets weather forecast for the specific date from OpenWeather with specifying latitude and longitude of the world. Not only temperature, humidity and wind speed, but also sunset time and dew point temperature can be obtained.
JSON String, Extract Value using JSON-Path
Extracts value from JSON using JSON Path. It is used when extracting necessary data from JSON received by the Incoming Webhook function. It is also possible to set the path to get multiple values.
Google Sheets: Spreadsheets, Add Sheet
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
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.