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”.
Finds the row number that contains a specified value in the target column of a Google Sheet.
This is a process that manages everything from drafting quotations and their approval to recording whether they are won or lost.
After approval by a supervisor, a PDF file of the quotation with a stamp is automatically generated (using Google Sheets and Google Drive).
After the order is confirmed, the result is automatically posted to the in-house SNS.
This workflow accepts requests to borrow company-owned items. All employees can apply using the public form. A staff member in charge of the material management in the General Affairs Department is in charge of lending out the items. The person in charge is automatically assigned at random from the staff list (Google Sheet). When a person who wishes to borrow an item registers the item, the person in charge approves/records it, and the borrowing of the item is notified to the applicant by email. The return schedule is managed by year and month, and the end of the loan is automatically notified by email in the month when the item is scheduled to be returned. The person in charge records that the item has been returned in the “3. Return Confirmation” step.
This workflow is for authorizing permission for personal information to be taken out of the system. Authorization is automatically recorded in the control ledger (G sheet). When a return check is performed, the work result is automatically updated.
This item copies a single Google Sheet to the same or another spreadsheet.
This item downloads Choice Data in specified 2 columns from Google Sheet.
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 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 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 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.