Google Calendar: Move Event to another Calendar
This item moves an event on Google Calendar to another calendar.
Google Workspace
Maintenance Service Request Registration Process
This is a workflow for registering maintenance service requests (SRs) to the central system. SRs are automatically added to a Google Sheet after being checked by the person in charge, and the RPA tool reads the Google Sheet and registers the SRs to the central system.
Google Sheets: Two ValueRanges, Xlookup Reference
Converts string B to string C by referring to the two spreadsheet areas. Searches lookup_string in range B, and if there is an exact match it returns the corresponding string in range C. If there is no match an empty string is returned. The search is executed in order from the top.
Google Sheets: Delete Sheet
This item deletes a single sheet in a Google Sheet. When the Google Sheet has only one sheet, it cannot be deleted.
Google Sheets: Create File
This item creates a new Spreadsheet in the specified folder on Google Drive.
Google Sheets: Append New Row
This item adds a row at the last of the sheet, and fills each cell of that row with data.
Inquiry Response Process, Gmail Start, AI Response Requirement Classification
This is a process to manage the progress from the receipt of a mail (Gmail) inquiry to its response. When an inquiry is received, AI classifies the purpose of the inquiry. In case of spam email, the inquiry response will be terminated without a response.
Meeting Documents Sharing Flow
This flow allows documents used in management meetings and other meetings to be shared with meeting participants. Attached meeting material files are automatically uploaded to a shared folder on Google Drive. When the sharing deadline is reached, the file is deleted from the shared folder.
Approval Flow
This approval flow determines approvers based on an externally managed list.
Approver information is obtained from an external list based on the project selected by the applicant and the approvers are determined.
This makes it easy to deal with frequent changes in approvers.
Customer Master Synchronisation Process, Google Sheet Integration
This workflow automatically imports the latest customer master. The master data held on Google Sheets is automatically synchronised to the choice master in Questetra. Regardless of whether you have the authority to edit the choice master, if you have the authority to execute this flow, you can execute the synchronisation process.
Order Reporting Process, LINE Notification
This is an order response process initiated by receipt of a fax mail.
Immediately after the process starts, the order is notified on line.
After confirmation by the sales leader and general manager, if the order amount is $5000 or more, the order is also reported to the executives.
*This system is designed to work with an Internet FAX service that converts received faxes into PDF attachment emails and sends them out.
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)
Quote Approval, Google Drive Create Folder
When quotes are approved, a folder will be created in Google Drive. The quotes are uploaded to the folder and its browsing URL is emailed to the customer. The created folder is automatically deleted on the deletion date determioned by the sales staff.
Quote Approval, Google Drive Delete
An approved quote will be automatically uploaded to Google Drive. The file viewing/downloading URL will be emailed to the customer. The quote file is automatically deleted on the deletion date which is entered by the sales representative.
Managing Employee Information in Google Spreadsheets with Workflow Apps
Introducing an application to manipulate employee information managed in Google Spreadsheets from Questetra.
Quote Approval, Google Drive Upload
An approved quote will be automatically uploaded to Google Drive. The file viewing/downloading URL will be emailed to the customer.
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.
Approval Flow-Budget Control
A Proposal-approval flow that automatically records the approved spending in a Google Sheet. When a new Issue is entered at the [1. Submit plan draft] Step, the “Budget Consumption Log” (Google sheet) is referred to, and the total expenditure so far is calculated automatically. At the Step of [2. Decision], the approver can make his/her decision confirming the budget consumption situation. The amount approved is automatically added to the “budget consumption log”.