 |
Google Drive
*You can see the relevant auto-processing Tasks here
- Google Drive Files Copy
Creates a copy of the specified file in the Drive. Supports both Google Doc files and common files. File ID can be obtained from URI etc. (If Folder-ID not specified, the file will inherit any discoverable parents of the source file.)
- Google Drive: File, Convert
Converts file in Google Drive and save as another MimeType file. Supports both Google Doc files and common files. File ID can be obtained from URI etc. (If Folder-ID not specified, the file will inherit any discoverable parents of the source file.)
- Google Drive: File; Download
Downloads the specified file in the Drive to the Workflow Data Item. If a Google File (Docs / Sheets / Slides, etc.) is specified, an error will occur (Please use File Export). The File ID can be obtained from the sharing settings screen
- Google Drive: GFile; Export as PDF
Exports the specified file in the Drive to the Workflow Data Item in PDF format. If a file other than a Google file (Docs / Sheets / Slides etc.) is specified, an error will occur (Please use File Download). File ID can be obtained from URI
- Google Drive: GFile; Export as Microsoft-Office
Exports the specified file in the Drive to the Workflow Data Item in Microsoft format: docx, xlsx, or pptx. If a file other than a Google file (Docs / Sheets / Slides etc.) is specified, an error will occur. File ID can be obtained from URI
- Google Drive: GFile, Export as Text
Exports text information from a GFile in Google Drive. If a file other than a Google file (Docs / Slides) is specified, an error will occur (Please use File Download). File ID can be obtained from URI
- Google Drive: Create Permission
Create Permissions in the specified files on Google Drive
- 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 Document
- Google Docs: Document; Replace All Text
Replaces all instances of text matching the specified string with replace text. The search is case sensitive. The number of replacements is output as a log. In many cases, the automated step “Google Drive: File; Copy” is placed upstream
|
 |
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 Spreadsheets Cell Value Update
Updates the target cell on the target sheet of the specified Google Sheets with the value of the specified Data Item. The communication log is stored in the String-type Data Item
- Sum of cells in a Google Spreadsheet
Stores the sum of specified range of a Google Sheets into a Numeric-type Data Item, and stores its communication log in a String-type Data Item. Comma removal version corresponds to the case where the decimal separator “,” is mixed
- Get Google Sheets Values as TSV
Convert values on Google Sheets into TSV
- 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
- 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 Slide
|
 |
Google Groups
- Google Group members retrieve
Retrieves Google Group members (email address) list. By checking group members (ML members) on a regular basis, ML management becomes easier. It also helps to prevent e-mail transmission to unnecessary members or to prevent lefting out proper members from information sharing
- Google Group member add
Add a member (email address) to Google Group. You can create an newsletter subscriber list (ML) distributed for the requester for material document, or register to group at the same time when adding a new employee account
- Google Group Member Deletion
Deletes members (email address) from Google Group. It is possible to respond to email newsletter delivery cancellation, or to delete automatically from the group when employees move or leave the company
|
 |
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
|
 |
Google Analytics
Accesses to Google Analytics and get Ranking report (PV / Referrer / Domain). it is possible to specify duration and filter criteria, so you can get regular reports without having to sign in to Google Analytics
|
 |
Google Cloud Print
Prints the file specified by File-type Data Item with the specified printer, and stores its communication log in a String-type Data Item
|
 |
Google Fit
- Google Fit: Dataset; Aggregate Step Count
Aggregates data of Step Count and Distance (meters) in Google Fit. Multiple data sets from multiple sources (including manual input) can be aggregated. Note that the results of simultaneous measurement with multiple devices are all added up
|
 |
Salesforce
- Salesforce Order Create
Registers new order information in Salesforce specifying the Client and order details. Stores Order ID and communication logs into String-type Data Item
- Batch to Get Accounts from Salesforce
Stores business partner’s ID and Name inside Salesforce respectively into Data Items, and stores its communication log in a String-type Data Item
|
 |
Box
*You can see the relevant auto-processing Tasks here
- Box File Upload (Password / Expiration)
Uploads (one) file which set in File-type Data Item into "box" and obtain its URL for publication. At the same time, it sets and expiration date. It is recommended to set "Max number of files" of the File-type Data Item where the file to be uploaded as 1
- Create Box Webhook(folder)
Create a Box webhook to check events on the folder. In advance,you have to configure the OAuth2
- Parsing Box Webhook JSON
Parse the JSON object sent by a webhook on Box
- Delete Box Webhook
Delete the Box webhook. In advance,you have to configure the OAuth2
|
 |
Microsoft 365 Outlook
|
 |
kintone
*You can see the relevant auto-processing Tasks here
|
 |
Slack
*You can see the relevant auto-processing Tasks here
- Slack: Chat Post Ephemeral
Sends an ephemeral message, which is visible only to the assigned user in a specific public channel, private channel, or private conversation. The user should be in the channel specified. SLACK USER is ID of the user who will receive the message
|
 |
LINE
- Post message through LINE Notify
Post message to your LINE Group through LINE Notify. In advance you have to get a personal access token. When get the one, choose where messages are sent
|
 |
Hangouts Chat
|
 |
Microsoft Teams
|
 |
ChatWork
|
 |
Typetalk
|
 |
Sendgrid
|
 |
Backlog
- Backlog Add Issue
Adds an Issue based on its Project ID, Summary, Type ID, etc., and stores the communication log into Data Item respectively
|
 |
PayPal
- PayPal Invoicing Create (JPY)
Generates Paypal invoice automatically from the setting item information, and stores Paypal Invoice ID in a String-type Data Item
- PayPal Invoicing Create (USD)
Generates Paypal invoice automatically from the setting item information, and stores Paypal Invoice ID in a String-type Data Item
- PayPal: Invoice, Check Detail
Checks the status of Invoice on the payment platform PayPal. If in PAID status, payment date is retrievable
- 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
|
 |
Stripe
- Stripe: Customer Object, Create
Creates the Customer object on the payment platform Stripe. Once the object is created, subsequent card billing is possible. Token ID and the customer email etc are required. Realizes a billing environment that does not touch sensitive info
- Stripe: Charge Object, Create
Creates the Charge object on the payment platform Stripe to charge the Customer ID (cus_12345678901234) for any amount in any currency. If the charging process fails, Charge object is not created and error log such as expired_card is output
- Stripe: Charge Object, Create with Transfer Amount
Creates the Charge object with Transfer Amount to charge the Customer ID for any amount in any currency. Any Connected Account as the Transfer Destination, any Transfer Amount within the Charge amount are available. If fails, the object not created
|
 |
WordPress.Com
- WordPress.Com: Posts New
Creates a post as a draft. Content is stored as a draft HTML of POST type. If you want to dynamically change the WORDPRESS DOMAIN using the EL expression, set Scope to “global”
- Wordpress.Com: Media New
Uploads new pieces of media. If you want to dynamically change the WORDPRESS DOMAIN of the upload destination using the EL expression, set Scope to “global”
- WordPress.Com: Stats Views
Gets a post’s views. By specifying WORDPRESS-DOMAIN and POST’ID, the cumulative number of page views is stored
|
 |
Zendesk Support
|
 |
Twilio
|
 |
Corporate Number
- 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
|
 |
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]
- Check the user is in the 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: 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 multi-line TSV string from date-filtered processes. Items are specified in CSV format such as “string:0,date:2,select:3”. Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported
- 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 of Questetra BPM Suite. A line break is added between each data. It 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
- NHK Program Search
Stores program information matching the keyword specified in String-type Data Item into a String-type Data Item, and stores its communication log in a String-type Data Item
|
Comments
0 comments
Please sign in to leave a comment.