Start: Gmail: Email Message Received
This item starts a Process when Gmail has received a new message.
Google Workspace
Start: Google Calendar: Event Started
This item starts a process when Event’s start time has passed on Google Calendar.
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)
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.
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”.
Adding Table Values to Google Sheets and Getting the Aggregate Value
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.
Start Processes from Appointments in Google Calendar
Reads the appointments in your Google Calendar and starts a Process if the start time of the appointment has elapsed.
Google Slides #Page: Export as PNG
Stores a PNG image file as Workflow data with converting the specified slide. Or gets the download URL to the PNG image which has a lifetime of 30 minutes. For example, it is used in the business process of the Sales Report by email with PNG image.
Google Slides #Page: Refresh Charts
Refreshes all embedded Google Sheets charts in the specified slide by replacing them with the latest version of the chart from Google Sheets. For example, you can build a system to automatically update the “sales summary” aggregated in Google Sheets.
Google Slides #Page: Replace Strings
Replaces all instances of text matching the Search string with the Replace string. The search is case sensitive. For example, you can model a Workflow that automatically replaces the title in the template page.
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: ValueRanges, Export as TSV
Stores a specified rectangular range of data as a TSV String. Empty cells are regarded as an empty string. Exporting two ranges at the same time is also supported. For example, the heading line and the 10th and subsequent lines can be exported at the same time.
Google Sheets: ValueRanges, Sum
Sums the numerical data in a specified range. Cells that cannot be recognized as numbers are considered zero. It also supports simultaneous calculation of two ranges. For example, you can sum debits and credits at the same time.
Google Drive #File: Copy
Creates a copy of a file and saves it in Google Drive. You can save it with any name you like. Note that the name of the file does not necessarily have to be unique within the folder.
Google Docs #Document: Replace All
Replaces all instances of text matching the FindWhat string with the ReplaceWith string in a case-sensitive way. It is also possible to replace multiple replacement patterns at once. If you are using a template file, you will often need to duplicate and replace the file in the upstream step.