Add-ons

  • Google Sheets: ValueRanges, Export as TSV

    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…

  • Zendesk Ticket Update

    Zendesk Ticket Update

    Updates a specified Zendesk Support ticket.

  • Image-Charts: QR Code, Create

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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)

    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)

    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

    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

    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

    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

    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

    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

    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.

Tag cloud