Start: Gmail: Email Message Received
This item starts a Process when Gmail has received a new message.
This item starts a Process when Gmail has received a new message.
This item starts a process when Event’s start time has passed on Google Calendar.
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)
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.
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.
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.
Introducing an application to manipulate employee information managed in Google Spreadsheets from Questetra.
An approved quote will be automatically uploaded to Google Drive. The file viewing/downloading URL will be emailed to the customer.
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.
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”.
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.
Reads the appointments in your Google Calendar and starts a Process if the start time of the appointment has elapsed.
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.
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.
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.
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.
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.
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.
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.
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.