Start: Gmail: Email Message Received
This item starts a Process when Gmail has received a new message.
Google Workspace
Google Drive: Search Folder
This item searches for a folder with a specific name, directly under the specified folder on Google Drive.
Google Drive: Export Google Workspace File as PDF
This item downloads the specified Google Workspace files (such as Google Docs, Sheets, or Slides) in PDF format. You can download multiple files at once. When you download multiple files, you should write one File ID per line.
Google Drive: Delete Shared Link
This item deletes the shared link accessible by anyone with the link or within the domain from the specified file or folder on Google Drive. Permissions for users or groups remain undeleted.
Google Drive: Create Shared Link
This item creates a shared link for the specified file or folder on Google Drive. An error occurs when the file/folder is already shared with anyone or within the domain.
Quote Approval Process, Google Drive/Sheets Connectivity
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.
Google Drive: Create Folder
This item creates a new folder in the specified folder on Google Drive.
Google Drive: Download File
This item downloads the specified files on Google Drive. You can download multiple files at once. When you download multiple files, you should write one File ID per line.
Starting a Process Triggered by Receiving a Gmail
Monitors the reception of Gmail in Google Workspace, and when an email with the specified conditions is received, it automatically starts a Process and saves the information contained in the email as Process Data. Gmail’s “label” is used as a condition to specify an email.
Lending Management Process, Random Responder Selection
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.
Personal Information Transfer Process
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.
Google Sheet: Copy Sheet
This item copies a single Google Sheet to the same or another spreadsheet.
Google Sheets: Download Choice Data
This item downloads Choice Data in specified 2 columns from Google Sheet.
Google Sheets: Update & Get Cells
This item updates values of cells and gets updated values of other cells on Google Sheets.
Google Sheets: Append New Rows (Table type data)
This item appends values of a Table type data item at the last of the sheet.
Gmail: Remove Label from Email Message
Removes labels from an email message in Gmail. You can remove multiple labels at once. When you remove multiple labels you should write one label per line.
Start: Google Calendar: Event Started
This item starts a process when Event’s start time has passed on Google Calendar.
