PayPal: Invoice, Create Draft
Creates a draft invoice on the payment platform PayPal. To move the invoice from a draft to payable state, the SEND action is required. Billing automation and paperless operations are realized.
bearer(oauth2Token)
PayPal: Invoice, Send
Sends an Invoice on the payment platform PayPal. Both Recipient (customer) and Invoicer will receive an email notification. The invoice status updates to SENT from DRAFT, and anyone who knows the Invoice URL will be able to pay.
PayPal: Invoice, Check Detail
Checks the status of Invoice on the payment platform PayPal. If in PAID status, payment date is retrievable.
Google Calendar Get events list (schedules)
Accesses to Google Calendar and retrieves a list of events (schedules) registered in the specified period. Combining this Task with Workflows will make it possible to get the next week’s schedule, and notify (announce) it by email.
Google Drive: File Permissions, Add Reader
Creates a Reader permission. A Google account email address is required. It is also possible to retain the Permission ID.
Google Drive: File Permissions, Remove Reader
Deletes a Reader permission. The permissionId is required.
Google Drive: File Permissions, Add AnyoneWithLink
Creates AnyoneWithLink permission (a Reader permission to anyone who has the link) to the file. Viewers who are notified of the link do not need to sign in to their Google account.
Google Drive: File Permissions, Remove AnyoneWithLink
Deletes AnyoneWithLink permission (a Reader permission to anyone who has the link) from the file. There is no change in the other permissions for the file.
Google Sheets: Spreadsheets, Add Sheet
Adds a new sheet to the end of the spreadsheet. If the specified sheet name already exists, this Automated Task will end with an error. If needed, SheetId can also be specified.
Google Sheets: Master Table, Simple Xlookup
Returns a value by referencing master data in Google Spreadsheets. Searches for the Lookup Value in array C, and if an exact match, returns the value in array D at the same index. C and D are defined in A1Notation. The length must be the same.
Google Drive: File, Convert
Converts file in Google Drive and save as another MimeType file. Supports both Google Doc files and common files. File ID can be obtained from URI etc. (If Folder-ID not specified, the file will inherit any discoverable parents of the source file.)
Google Drive: GFile, Export as Text
Exports text information from a GFile in Google Drive. If a file other than a Google file (Docs / Slides) is specified, an error will occur (Please use File Download). File ID can be obtained from URI.
Google Sheets: Values, Export as TSV
Exports the values in the rectangular range as TSV text, which has the same number of tab delimiters on each line. Empty cells are regarded as the null string. Two range export are also supported: e.g. Freezed headings and recent data.
Google Sheets: Values, Sum Numbers
Sums the numeric values in the specified range. Values that cannot be recognized as numeric values are regarded as zero. Two ranges of simultaneous calculations are also supported. e.g. The budgeting progress in the general ledger is summarized.
Google Docs: Document; Replace All Text
Replaces all instances of text matching the specified string with replace text. The search is case sensitive. The number of replacements is output as a log. In many cases, the automated step “Google Drive: File; Copy” is placed upstream.
Google Drive: GFile; Export as Microsoft-Office
Exports the specified file in the Drive to the Workflow Data Item in Microsoft format: docx, xlsx, or pptx. If a file other than a Google file (Docs / Sheets / Slides etc.) is specified, an error will occur. File ID can be obtained from URI.
Google Drive: GFile; Export as PDF
Exports the specified file in the Drive to the Workflow Data Item in PDF format. If a file other than a Google file (Docs / Sheets / Slides etc.) is specified, an error will occur (Please use File Download). File ID can be obtained from URI.
Google Drive: File; Download
Downloads the specified file in the Drive to the Workflow Data Item. If a Google File (Docs / Sheets / Slides, etc.) is specified, an error will occur (Please use File Export). The File ID can be obtained from the sharing settings screen.
Google Slides: Page; Replace All Strings
Replaces all instances of text matching the specified string with replace text. The search is case sensitive.
Google Slides: Page; Refresh All Chart
Refreshes all embedded charts in the specified slide by replacing them with the latest version from Google Sheets.