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.
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.
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.
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.
Downloads Choice Data in 2 specified columns from a Google Sheet.
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.
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.
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.
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.
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.
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.
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.
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.