Google Calendar: Get events list (schedules)
Accessing to Google Calendar and retrieves a list of events (schedules) registered during the specified time period.
Add-ons
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.
Microsoft Teams Chat: Message Post (API)
Posts a message to Microsoft Teams Chat using the API (Microsoft Graph REST API).
Google Slides #Pages: Export as PNG
Stores one or multiple PNG image files as Workflow data by converting specified slide pages. If not specified, only the last page will be converted into PNG. If “all” is specified, all pages will be converted. Also supports download URLs (valid for 30 mins).
Google Sheets #Sheet: Overwrite with TSV
Pastes TSV data to the specified coordinates in the specified sheet. Only the selected columns can be pasted. Specify the column ID with “d” for datetime data and “n” for numeric data. Example of column specification: “0,2d,5n”.
IP2WHOIS #Domain-WHOIS-API: Obtain Domain-Info
Obtains domain information (WHOIS records: “Registered Domain Name” and “Domain Age”) from domain names including subdomains. Returns an error if the domain is not registered. Free API license is limited to a maximum of 500 queries per month.
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.
#TSV-String: Add Thousands Separators
Formats the specified range of columns from START index to END index of the TSV (END not included). The index starts from “0”. Negative index counts back from the end. If START is omitted “from the beginning”, and if END is omitted “to the end”.
#TSV-String: Extract Range Columns
Extracts the specified range of columns from START index to END index of the TSV (END not included). The index starts from “0”. Negative index counts back from the end. If START is omitted “from the beginning”, and if END is omitted “to the end”.
#TSV-String: Basic Math on Numeric Strings
Adds the calc result as a new column. The result of binary calculations such as “adding column A and column B” or “multiplying column C by 1.1” are added to the end of each TSV row. Subtraction, division, remainder, and exponentiation also supported.
#Files: Filter by FileName
Extract only files to match the conditions from the files stored in FILE type. The conditions can be specified as “equal to”, “contains”, “starts with”, or “ends with”. A case-insensitive can be specified. You can also store the remaining files.
#String: Extract Subpattern by RegExp
Extracts one string that matches the regular expression and extracts its subpatterns (Capturing groups). If “(\d{4})-(\d{2})-(\d{2})”, the first YYYY-MM-DD that matches perfectly in the text will be extracted. Then the YYYY MM DD are extracted.
#Multiline-String: Remove Blank Lines
Deletes blank lines. There are two modes: delete all blank lines and combine consecutive blank lines into one line.
#Collab-Chat: Post
Posts any text to CollabChat in the Questetra Platform by specifying the channel. To post to an organization channel or a process channel, specify the ID (eg. “g12” or “p123”), and to a user-created channel, the channel name (eg. “general”).
#String: Replace All by RegExp
Replaces all strings that match the regular expression. For example, all Phone Numbers ‘\d{3}-\d{3}-\d{4}’ in a text string can be replaced with “999-999-9999”.
#TSV-String: Extract by RegExp for each Line
Extracts a string that match the RegExp for each line. If set an “Email String”, the email address in the specified cell will be added as a new cell at the end of the line. If no match, an empty will be added. The capture group also available.
#String: Extract by RegExp
Extracts all strings that match the regular expression. For example, if set “URL regular expression”, all URLs in the text will be extracted.
Converter: #TSV String to #Markdown String
Converts a TSV string to a Markdown string. The first line of the TSV is recognized as a header line, and the second and subsequent lines are recognized as data lines. Also supports column settings such as right alignment and center alignment.
TSV String: Extract Cells
Extracts the values of specified cells in A1 notation. The extracted 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 ORG type data if the format allows.
Google Sheets: Spreadsheets Multiple Cells Value, Update
Overwrites multiple cells of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formatted, the value “12-24” will be converted to “12/24/2021”. Or, “’12-31” will be updated as the string “12-31”.
Microsoft 365 OneDrive for Business: Create PDF
This process converts files on OneDrive to PDF for data item.