Google Sheets: Download Choice Data
Downloads Choice Data in 2 specified columns from a Google Sheet.
JSON.parse()
Google Slides: Page, Export as PNG
Stores a PNG image file as Workflow data with converting the specified slide. Or gets the download URL to the PNG image which has a lifetime of 30 minutes. For example, it is used in the business process of the Sales Report by email with PNG image.
Google Slides: Page, Refresh Charts
Refreshes all embedded Google Sheets charts in the specified slide by replacing them with the latest version of the chart from Google Sheets. For example, you can build a system to automatically update the “sales summary” aggregated in Google Sheets.
Google Slides: Page, Replace Strings
Replaces all instances of text matching the Search string with the Replace string. The search is case sensitive. For example, you can model a Workflow that automatically replaces the title in the template page.
Google Slides: Page, Duplicate
Duplicates the specified slide page and inserts it on the next page. If no page is specified, the last page will be duplicated. It is used when you want to start by duplicating a template page, such as creating a header image or a summary report.
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.