-
●
TSV String; Re-order Columns
Extracts a new TSV string re-arranged by a column ID list from TSV string. ID repetition in the list is also possible. It can be used to narrow down necessary information or conform to the format. Removes whitespace from both ends of…
-
●
Multiline String, Get Number of Lines
Gets the number of lines of text. The number of lines that do not count the trailing newline codes can also be stored.
-
●
Multiline String, Get Specific Line
Gets a specific line of a multi-line string. The line ID specification starts with 0.
-
●
TSV String, Filter by Numeric
Filters TSV strings using a numeric range. Only the rows where the specified numeric column is included in the numeric range are output. If you want to OR multiple ranges, specify them in comma separated form like “-100
-
●
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…
-
●
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.
-
●
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.
-
●
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.
-
●
-
●
Microsoft 365 Outlook: Insert Calendar Event
Inserts an event in the Outlook Calendar. A maximum of three participants can 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…
-
●
any data-type, Output to Log
Outputs business data to the Auto-Processing Log. Administrators of the Workflow App can verify the data that was stored when the Process reached this step.
-
●
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.
-
●
Multiline String, Dequeue First
Removes the first line from the multiline string. One line less than the original string. By placing in a loop flow or in a recursive workflow, data list can be processed sequentially.
-
●
Singleline TSV String, Extract Cell
Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and…
-
●
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…
-
●
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.
Add-ons
-
TSV String; Re-order Columns
Extracts a new TSV string re-arranged by a column ID list from TSV string. ID repetition in the list is also possible. It can be used to narrow…
-
Multiline String, Get Number of Lines
Gets the number of lines of text. The number of lines that do not count the trailing newline codes can also be stored.
-
Multiline String, Get Specific Line
Gets a specific line of a multi-line string. The line ID specification starts with 0.
-
TSV String, Filter by Numeric
Filters TSV strings using a numeric range. Only the rows where the specified numeric column is included in the numeric range are output. If you want to OR…
-
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…
-
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…
-
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…
-
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…
-
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…
-
PayPal #Invoice: Check Detail
Checks the status of Invoice on the payment platform PayPal. If in PAID status, payment date is retrievable.
-
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…
-
Sendgrid: Send Bulk Emails
Send a mail from SendGrid.
-
Microsoft 365 Outlook: Insert Calendar Event
Inserts an event in the Outlook Calendar. A maximum of three participants can 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…
-
any data-type, Output to Log
Outputs business data to the Auto-Processing Log. Administrators of the Workflow App can verify the data that was stored when the Process reached this step.
-
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…
-
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”…
-
Multiline String, Dequeue First
Removes the first line from the multiline string. One line less than the original string. By placing in a loop flow or in a recursive workflow, data list…
-
Singleline TSV String, Extract Cell
Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but…
-
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…
-
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.