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.
Retrieves a list of all members’ email addresses (2000 addresses at a maximum) in a Google Groupe. It is also possible to narrow down to email addresses of the members with the OWNER role or MANAGER role as well as those of GROUP email.
Adds an email address to the specified group which is created in Google Groups. Adding the email address to multiple groups at once is also possible. You can automate the operations for a personnel change.
Removes an email address from the specified group which is created in Google Groups. Removing the email address from multiple groups at once is also possible. You can automate the operations for a personnel change.
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.
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.
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.)