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.
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.
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.
Checks the status of Invoice on the payment platform PayPal. If in PAID status, payment date is retrievable.
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.
Creates a Reader permission. A Google account email address is required. It is also possible to retain the Permission ID.
Deletes a Reader permission. The permissionId is required.
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.
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.
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.
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.
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.)
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.
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.
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.
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.
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.
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.
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.
Replaces all instances of text matching the specified string with replace text. The search is case sensitive.
Refreshes all embedded charts in the specified slide by replacing them with the latest version from Google Sheets.