 |
Google Drive
*You can see the relevant auto-processing Tasks here
- Google Drive: File, Copy
Creates a copy of a file in Google Drive. It supports saving as an arbitrary name. Note that the name of the file is not necessarily unique within a folder
- Google Drive: File, Convert
Converts any file in Google Drive to another MimeType file and save 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
- Google Drive: File, Download
Imports any file in Google Drive as Workflow data. It is also possible to change the file name when importing the file. If a Google file (Docs/Sheets/Slides, etc.) is specified, an error will occur (use GFile Export addon instead)
- Google Drive: GFile, Export as PDF
Stores Google file as Workflow data with converting 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 Google file as Workflow data with converting 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 Google file as Workflow data with converting 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 Permissions, Add AnyoneWithLink
Creates AnyoneWithLink permission (a Reader permission to anyone who has the link) to the file. Viewers who are notified of the link do not need to sign in to their Google account
- Google Drive: File Permissions, Remove AnyoneWithLink
Deletes AnyoneWithLink permission (a Reader permission to anyone who has the link) from the file. There is no change in the other permissions for the file
- Google Drive: File Permissions, Add Reader
Creates a Reader permission. A Google account email address is required. It is also possible to retain the Permission ID
- Google Drive: File Permissions, Remove Reader
Deletes a Reader permission. The permissionId is required
- Google Drive: Create Shared Link
Creates Permissions in the specified files and/or folders on Google Drive. An error occurs when a specified file/folder is already shared
|
 |
Google Document
- 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 replace the file in the upstream step
|
 |
Google Sheets
*You can see the relevant auto-processing Tasks here
- Google Sheets: Sheet, Append TSV
Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier “d” as Datetime, and column ID with an identifier “n” as Numeric; eg “0,2d,5n”
- Google Sheets: Spreadsheets Value, Update
Overwrites a cell of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formated, the value “12-24” will be converted to “12/24/2021”. Or, “’12-31” will be updated as the string “12-31”.
- Google Sheets: ValueRanges, Sum
Sums the numeric 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 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 exported at the same time
- Google Sheets: Two ValueRanges, Xlookup Reference
Converts stringB to stringC, referring to the two areas. Searches lookup_string in range B, and if an exact match, returns the corresponding string in range C. If no match, an empty string is returned. The search is executed in order from the top
- 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: Sheet Row, Update with Singleline TSV
Updates a Google Sheet with a single line of TSV data. Searches for an A-Column cell that exactly matches the first value of the TSV and overwrite only the first occurrence. The values will be parsed as if they were entered manually by the user. If no matching line exists, it will be appended at the end
- Google Sheets: Find Row Number By Specified Value
Finds the row number that contains a specified value in the target column of a Google Sheet
- Google Sheets: Row Range, Delete
Deletes rows in the specified range. Existing cells will be shifted upward. Both the start and end rows are specified by zero-based index. For example, “startIndex: 0, endIndex: 1” means only the first line. (End index is exclusive)
|
 |
Google Slides
- 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 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, 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, 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: Get Slide Page ID
Stores page object IDs of the specified slide.
|
 |
Google Groups
- Google Groups: Members, List
Retrieves a list of all members' email addresses (2000 addresses at a maximum) in a Google Groupe. It is also possible to narrow down to email addresses of the members with the OWNER role or MANAGER role as well as those of GROUP email
- Google Groups: Members, Insert
Adds an email address to the specified group which is created in Google Groups. Adding the email address to multiple groups at once is also possible. You can automate the operations for a personnel change
- Google Groups: Members, Delete
Removes an email address from the specified group which is created in Google Groups. Removing the email address from multiple groups at once is also possible. You can automate the operations for a personnel change
|
 |
Google Calendar
*You can see the relevant auto-processing Tasks here
- Google Calendar Get events list(schedules)
Accesses to Google Calendar and retrieves a list of events (schedules) registered in the specified period. Combining this Task with Workflows will make it possible to get the next week’s schedule, and notify (announce) it by email
|
 |
Gmail
*You can see the relevant auto-processing Tasks here
|
 |
Google Chat
- Google Chat: Space, Create Message
Posts a message in a Google Chat Space. Bold decoration (with asterisks) and Inline-code decoration (with backticks) are also applied as they are. It is also possible to attach some Process Data in card format
|
 |
Google Analytics
- Google Analytics Reports (Referrer ranking)
Creates Ranking report about Referrer. Aggregating it with a specified duration and filter criteria is also possible
- Google Analytics: Reports, Pageviews by Hostname-PagePath
Reports the page popularity in the specified period in ranking format. It is also possible to check the details of the number of page views, the number of sessions and initiations can also be viewed in TSV format. filtersExpression is also available
- Google Analytics: GA4 Report, PageViews by Hostname-PagePath
Reports the page popularity in the specified period in ranking format. The number of screen page views, sessions, engaged sessions and active users for each page are aggregated in TSV format. Dimension Filter “inListFilter” is also available
- Google Analytics: GA4 Report, Create Custom
Create a TSV report for any Metric from Google Analytics 4 property. One Dimension and one Metric can be specified arbitrarily. Extraction filter is also available. (exact match of the Dimension value)
- Google Analytics: GA4 Realtime Report, Create Custom
Creates a TSV report for any Metric from events in the last 30 mins (Google Analytics 4 property). One Realtime Dimension and one Realtime Metric can be specified arbitrarily. Extraction filter is also available. (exact match of the Dimension value)
|
 |
Google Fit
- Google Fit: FitnessData, Get Steps
Gets the step count data in Google Fit. Gets the aggregated value for any period. It is also possible to acquire travel distance data (meters). For example, the number of steps taken during working hours for care workers and delivery staff is acquired
|
 |
Google 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 (Neural Machine Translation) model is applied in most languages, while the PBMT (Phrase-Based Machine Translation) model is done in some languages
|
 |
Google BigQuery
*You can see the relevant auto-processing Tasks here
|
 |
DeepL
- 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)
|
 |
Salesforce
|
 |
Box
*You can see the relevant auto-processing Tasks here
|
 |
Microsoft 365
|
 |
Microsoft 365 Outlook
|
 |
Microsoft 365 Excel
*You can see the relevant auto-processing Tasks here
|
 |
Microsoft Teams
|
 |
Microsoft OneDrive
*You can see the relevant auto-processing Tasks here
|
 |
kintone
*You can see the relevant auto-processing Tasks here
|
 |
AirTable
|
 |
SendGrid
|
 |
Slack
*You can see the relevant auto-processing Tasks here
- Slack: Chat, Post Block
Posts a message in block format. A table data can be attached as needed. It is also possible to change to an ephemeral message that is displayed only to a specific user
- Slack: Get Slack Id By Questetra Account User
Retrieves the ID from the Slack user profile. The user profile is identified using the Questetra account email address as the key. You can post a message with mentions using your ID.
|
 |
LINE
- Post Message through LINE Notify
Posts a message to a LINE group through LINE Notify. Please obtain a personal access token in advance. The recipient of the message will be selected at the time of acquiring the token, either the user acquiring the token themself or a group in which that person participates
|
 |
Hangouts Chat
|
 |
ChatWork
|
 |
Typetalk
|
 |
Backlog
- 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
|
 |
PayPal
- PayPal: Invoice, Create Draft
Creates a draft invoice on the payment platform PayPal. To move the invoice from a draft to payable state, the SEND action is required. Billing automation and paperless operations are realized
- PayPal: Invoice, Send
Sends an Invoice on the payment platform PayPal. Both Recipient (customer) and Invoicer will receive an email notification. The invoice status updates to SENT from DRAFT, and anyone who knows the Invoice URL will be able to pay
- PayPal: Invoice, Check Detail
Checks the status of Invoice on the payment platform PayPal. If in PAID status, payment date is retrievable
|
 |
Stripe
*You can see the relevant auto-processing Tasks here
- Stripe: Customer, Create
Creates a Customer object on the payment platform Stripe. Customer objects allow you to perform recurring charges. Note that it is necessary to implement tokenization mechanism that directly interacts with the customer browser and Stripe in advance
- Stripe: Customer, Charge
Creates the Charge object on the payment platform Stripe. If the primary payment method (Customer object) fails, the backup payment method will be charged. If all method fails, no Charge object will be created and an Abended Error log will be output
- Stripe: Customer, Destination Charge
Creates the Charge object with Transfer Amount to charge the Customer ID for any amount in any currency. Any Connected Account are available. If the primary payment method (Customer object) fails, the backup payment method will be charged. If all method fails, no Charge object will be created and an Abended Error log will be output.
- Stripe: Payouts, Extract as TSV
Lists all Payouts on the payment platform Stripe. Payouts can be filtered by status and arrival date.
- Stripe: Balance Transactions, Extract as TSV by Payout ID
List all Balance Transactions on the payment platform Stripe. They can be filtered with Payout ID.
|
 |
ClimberCloud
(ClimberCloud® is a registered trademark of NTT Data Business Brains Corporation.)
|
 |
WordPress.Com
- WordPress.com: Posts, Create Draft
Creates a draft of the article on WordPress.com. Not only post type articles but also page type articles can be generated. It automates WordPress and saves time on post-publication tasks.
- Wordpress.com: Media, Upload
Uploads new pieces of media. Even if multiple files are attached to the workflow data, uploads them all. It is possible to upload not only image files such as PNG and GIF, but also PDF and DOCX files
- Wordpress.com: Media, List
Lists the URLs of the content in the media library. Up to 100 items are listed in order of new arrival. It is possible to narrow down by the uploaded datetime. For example, it is used for monitoring public files that can be viewed from the Internet
- WordPress.com: Stats, Get Views
Gets the number of the specified article has been viewed. Gets the “subtotal” for the specified period and the “total” for the entire period from Jetpack. It is also possible to obtain the daily values for the specified period in TSV format
|
 |
OpenAI
- OpenAI: Chat, Start
Starts a conversation with the OpenAI API (ChatGPT). The MODEL used is “gpt-4” by default (configurable). A response (COMPLETION) to an instruction question (PROMPT) is automatically obtained
- OpenAI: Chat, Interact with Parameters
Communicates with OpenAI API (ChatGPT); the default MODEL is “gpt-4” (configurable). Supports almost all Chat features, such as re-asking based on histories and/or parameters; sampling temperature-Top_P, Presence-Frequency penalty, Logit bias
- OpenAI: Audio, Transcribe
Transcribes from audio file. The “whisper-1” model in the OpenAI API converts speech data into text data. If set abbreviations and technical terms as summary (PROMPT), more accurate data conversion will be achieved
- OpenAI: Audio, Translate into English
Translates audio into English. English text data is generated from sound or video file containing Japanese or other, using the OpenAI API “whisper-1” model. Abbreviations and technical terms can be set as PRMOPT to achieve more accurate translation
- OpenAI: Audio, Transcribe to WebVTT
Transcribes audio and video files in caption format WebVTT, using the OpenAI API “whisper-1” model by default (configurable) to convert audio data into text data. Set abbreviations and technical terms as PROMPT for more accurate transcription
- OpenAI: Images, Generate
Creates an image given a prompt. By default a 1024×1024 image is generated, but you can change it to 256×256 or 512×512. Note that PROMPT must be defined within 1000 characters
- OpenAI: Images, Create Variation
Creates a variation of a given image. By default a 1024×1024 image is created. 256×256 or 512×512 are also creatable. The given image must be a square image less than 4MB. The maximum number that can be created at once is 10
- OpenAI: Images, Edit Specific Area
Completes the transparent areas of an original image with a PROMPT, by default 1024×1024. The areas to be edited can also be specified in another file. The given image must be square less than 4MB. The maximum number created at once is 10
|
 |
Image-Charts
- 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
- Image-Charts: Bar Chart, Create
Creates a Bar/Line Chart from numeric TSV (population by country, monthly sales) using Image-Chart. The Y-axis tick marks are automatically generated. The X-axis tick marks are refered to the first line of the TSV. The image is output in PNG format
|
 |
Zendesk Support
|
 |
National Tax Agency
- Corp Num Web-API: Organizations, Search Name with ID
Searches the corporate name, furigana, address, history, etc, with the 13-digit identifier, accessing to the Corporate Number System Web-API, about 5 million companies registered by National Tax Agency Japan. “Application ID” is required in advance
- Corp Num Web-API: Organizations, Search ID with Name
Searches the 13-digit identifier with the corporate name, etc., accessing to the Corporate Number System Web-API, about 5 million companies registered by National Tax Agency Japan. “Application ID” is required in advance
- Qualified Invoice Issuer Web-API: Search Name with ID
Searches the Qualified Invoice Issuer’s name, address, history, etc, with the registrated number, accessing to the Qualified Invoice Issuer System Web-API by National Tax Agency Japan. “Application ID” is required in advance
|
 |
OpenWeather
- 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
- 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
|
 |
NHK Program
- 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
|
 |
Questetra
- Questetra Role Membership Add
System Administrator Authority and User Manager Authority required 1. Get Secret: https://{YOUR}.questetra.net/Admin/OAuth2/Client/list 2. Config [OAuth 2.0 Setting]
- Questetra Role Membership Delete
Deletes a member from Questetra’s “Role” and stores the communication log in a String-type Data Item
- Questetra Org Membership Add
System Administrator Authority and User Manager Authority required 1. Get Secret: https://{YOUR}.questetra.net/Admin/OAuth2/Client/list 2. Config [OAuth 2.0 Setting]
- Questetra Org Membership Delete
System Administrator Authority and User Manager Authority required 1. Get Secret: https://{YOUR}.questetra.net/Admin/OAuth2/Client/list 2. Config [OAuth 2.0 Setting]
- Questetra Get Membership Mail Address Belong To Org
Gets the email address of members that belong to a specified Organisation in Questetra
- Questetra BPMS: User, Check Belonging to Organization
If the specified user is the leader of the specified organization, this task returns “L”. If he or she is one of the its members,it returns “M”. If he or she doesn’t belong to it, it returns nothing
- Questetra BPMS: User, Check Belonging to Role
If the specified user belong to the specified role, this task returns role name. If he or she doesn’t belong to it, it returns nothing.
- Questetra BPMS: Process, Extract as TSV
Extracts process data as single-line TSV string. Items are specified in CSV format such as “0,2,3”. Tab code and line feed code are automatically deleted. Discussion type, Table type, Guide-Panel type cannot be extracted (Warning Log)
- Questetra BPMS: Process, Batch Extract as TSV
Extracts process data as a multiline TSV string from local or remote workflow platform via API. Field-Items are specified in CSV format such as “string:0,date:2,select:3”. Range is specified by date: Start Date, End Date, or any date type.
- Questetra BPMS: Process, Batch Extract by Filter as TSV
Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance
- Questetra BPMS: Process, List All File URLs
Lists the download URLs for the files stored as workflow data of Questetra BPM Suite. If two files are attached, output two lines of text. This is useful for browser extensions and email text attachment
- Questetra BPMS: Process, Concat All Strings
Concatenates all string type data. Searches and joins string data and title strings stored as workflow data in Questetra BPM Suite. A line break is added between each data which is used for checking the existence of keywords
- Questetra BPMS: Process, Kick HttpStartEvent by TSV
Kicks HttpStartEvent with the specific line data of TSV. When assuming batch start using multiline TSV data, place it in a loop structure. LineIDs start at zero
|
 |
Misc
*You can see the relevant auto-processing Tasks here
- Google reCAPTCHA: Token, Verify
Verifies the reCAPTCHA token (reCAPTCHA user response token). Validation boolean (true: human) and/or validation score (1.0: human) are output. The token is valid for two minutes, and can only be verified once.
|
Comments
0 comments
Please sign in to leave a comment.