Google Sheets: Append New Row
Adds new cells after the last row with data in a sheet, inserting new rows into the sheet if necessary.
bearer(oauth2Token)
Google Sheets: Download Choice Data
Downloads Choice Data in 2 specified columns from a Google Sheet.
Questetra Org Membership Add
Adds a member to a Questetra “Organization” and stores the communication log in a String-type Data Item
Questetra Org Membership Delete
Deletes a member from Questetra’s “Organization” and stores the communication log in a String type Data Item
Questetra Role Membership Delete
Deletes a member from Questetra’s “Role” and stores the communication log in a String type Data Item
Questetra Role Membership Add
Adds a member to a Questetra “Role” and stores the communication log in a String-type Data Item
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 Groups: Members, List
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.
Google Groups: Members, Insert
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.
Google Groups: Members, Delete
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.
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.
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.
