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.
Creates a post as a draft. Content is stored as a draft HTML of POST type. If you want to dynamically change the WORDPRESS DOMAIN using the EL expression, set Scope to “global”.
Gets a post’s views. By specifying WORDPRESS-DOMAIN and POST’ID, the cumulative number of page views is stored.
Uploads new pieces of media. If you want to dynamically change the WORDPRESS DOMAIN of the upload destination using the EL expression, set Scope to “global”.
Updates the target cell on the target sheet of the specified Google Sheets with the value of the specified Data Item. The communication log is stored in the String type Data Item.
