Google Sheets: Create File
Creates a new Spreadsheet in a specified folder on Google Drive
Google Workspace
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.
Google Drive: Search Folder
Searches for a folder with a specific name directly under the specified folder on Google Drive.
Google Sheets: Delete Sheet
Deletes a single sheet in a Google Sheet. When the Google Sheet has only one sheet it cannot be deleted.
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.
Google Drive: GFile, Export as PDF
Stores a Google file as Workflow data after converting it to a PDF file. It is also possible to change the file name. If a file other than a Google file (Docs/Sheets/Slides, etc.) is specified an error will occur.
Google Drive: GFile, Export as MS-Office
Stores a Google file as Workflow data after converting it to an MS-Office file. It is also possible to change the file name. If a file other than a Google file (Docs/Sheets/Slides, etc.) is specified,an error will occur.
Google Drive: GFile, Export as Text
Stores a Google file as Workflow data after converting it to a Text file. It is also possible to change the file name. If a file other than a Google file (Docs/Slides) is specified an error will occur.
Google Drive: File, Download
Imports any file in Google Drive as Workflow data. It is also possible to change the file name. If a Google file (Docs/Sheets/Slides, etc.) is specified, an error will occur (use GFile Export addon instead).
Google Drive: File, Convert
Converts any file in Google Drive to another MimeType file and saves as a new one. Supports not only Google files but also common files. Converting image files (JPEG, PNG, GIF, PDF) to “Google Docs” will perform OCR text extraction.