This workflow accepts subscription applications online. The customer makes a provisional application online using the trial version ID as a key. After the provisional subscription, the customer enters credit card information to make a full subscription. Billing is done periodically via Stripe.
This item updates values of cells and gets updated values of other cells on Google Sheets.
This item appends values of a Table type data item at the last of the sheet.
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.
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.
This item deletes a single sheet in a Google Sheet. When the Google Sheet has only one sheet, it cannot be deleted.
This item copies a single Google Sheet to the same or another spreadsheet.
This item creates a new Spreadsheet in the specified folder on Google Drive.
This item adds a row at the last of the sheet, and fills each cell of that row with data.
This workflow automatically reminds vacancy applicants to submit their documents.
Information such as address, deadline, etc. is read from the applicant list (TSV format) one by one.
Based on the imported information, a submission request email is sent daily to those who have not yet submitted their documents.
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.
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.
This item downloads Choice Data in specified 2 columns from Google Sheet.
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)
Introducing an application to manipulate employee information managed in Google Spreadsheets from Questetra.
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”.
Finds the row number that contains a specified value in the target column of a Google Sheet.
Adds the contents of a Table-type Data Item to a Google Sheet and retrieves the aggregated value. Various aggregations can be performed automatically depending on the spreadsheet settings.
