-
●

Google Sheets: ValueRanges, Export as TSV
Stores a specified rectangular range of data as a TSV String. Empty cells are regarded as an empty string. Exporting two ranges at the same time is also supported. For example, the heading line and the 10th and subsequent lines can be…
-
●
-
●

Image-Charts: QR Code, Create
Creates a QR Code using the Image-Chart QRCode web service generation. It is possible to encode any string data to the QR code. The QR Code image will be output in png format.
-
●

Google Sheets: ValueRanges, Sum
Sums the numerical data in a specified range. Cells that cannot be recognized as numbers are considered zero. It also supports simultaneous calculation of two ranges. For example, you can sum debits and credits at the same time.
-
●

Google Drive #File: Copy
Creates a copy of a file and saves it in Google Drive. You can save it with any name you like. Note that the name of the file does not necessarily have to be unique within the folder.
-
●

Google Docs #Document: Replace All
Replaces all instances of text matching the FindWhat string with the ReplaceWith string in a case-sensitive way. It is also possible to replace multiple replacement patterns at once. If you are using a template file, you will often need to duplicate and…
-
●

Google Drive #GFile: Export as PDF
Stores a Google file as Workflow data after converting it to a PDF file. It is also possible to change the file name. If a file other than a Google file (Docs/Sheets/Slides, etc.) is specified an error will occur.
-
●

Google Drive #GFile: Export as MS-Office
Stores a Google file as Workflow data after converting it to an MS-Office file. It is also possible to change the file name. If a file other than a Google file (Docs/Sheets/Slides, etc.) is specified,an error will occur.
-
●

Google Drive #GFile: Export as Text
Stores a Google file as Workflow data after converting it to a Text file. It is also possible to change the file name. If a file other than a Google file (Docs/Slides) is specified an error will occur.
-
●

Google Drive #File: Download
Imports any file in Google Drive as Workflow data. It is also possible to change the file name. If a Google file (Docs/Sheets/Slides, etc.) is specified, an error will occur (use GFile Export addon instead).
-
●

Google Drive #File: Convert
Converts any file in Google Drive to another MimeType file and saves as a new one. Supports not only Google files but also common files. Converting image files (JPEG, PNG, GIF, PDF) to “Google Docs” will perform OCR text extraction.
-
●

URL String, Extract Parts
Parses the URL/URI string to extract each component, such as Protocol (Scheme), Host, Hostname, Path, Query, Fragment, etc. For components that require URL decoding, decodeURIComponent processing is required separately in the downstream process.
-
●

UrlEncoded String, Decode UriComponent
Decodes a URL-encoded string that is an encoded component of a Uniform Resource Identifier. “5%25off%3F” will be decoded to “5%off?” and “%E3%81%82%20%E3%81%84” will be decoded to “あ い”.
-
●

Google Analytics Reports (Referrer ranking)
Creates a ranking report related with your referrer page. It is also possible to aggregate it with a specified duration and filter criteria.
-
●

Google Analytics Reports (PV ranking)
Creates a ranking report (TSV) for the number of page views. It is also possible to aggregate it with a specified duration and filter criteria.
-
●

DeepL #Text: Translate
Translates using DeepL API v2. Specifying the target language is mandatory, but specifying the source language is optional (Detected). It is also possible to translate into more formal or broken sentences (Formality).
-
●

Questetra BPMS: User, Check Belonging to Organization
If the specified User is the leader of the specified Organization this task returns “L”. If they are one of its members it returns “M”. If the User doesn’t belong to the Organization it returns nothing.
-
●

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.
-
●

Backlog Add Issue
Adds an Issue based on its Project ID, Summary, Type ID, etc., and stores the communication log in a respective Data Item.
-
●

Converter: Datetimes in different time zones
Converts the datetime in time zone A to the datetime in time zone B. Any time zone can be set for either datetimes. If nothing is set the Workflow Platform time zone will be applied.
-
●

Converter: Workflow Datetime to ISO-Datetime-String
Converts Datetime type data (“2021-12-31 20:34” JST) into ISO 8601 datetime string data (“2021-12-31T20:34:00+09:00” or “2021-12-31T11:34:00Z”). As a general rule Datetime type data is regarded as the time of the Workflow Platform time zone.
