Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Watches for new rows.
Triggers when a new comment is posted by a user.
Triggers when a new comment is posted in a subreddit.
Triggers when a new link is submitted.
Triggers when a new link is submitted or updated in a given subreddit.
Triggers when a new subreddit is posted by a user.
Triggers when a new link is submitted by a user.
Add a comment to an object based on id for a particular module (tasks, tickets).
Close one or more tickets by specifying the ticket ID(s) in a list.
Create an object based on a selected module (ex: create an account, create a contact, create a ticket ...).
Delete a specified object based on id from a selected module (ex: delete an account, delete a contact, delete a ticket ...).
Set or unset contacts/tickets as spam by specifying their ids into a list.
Returns only one object that has a specified id from a selected module (ex: a task, a ticket, an account ...).
Performs an arbitrary authorized API call.
Updates a specific object based on id from a selected data (ex: update an account, update a ticket, update a contact ...).
Appends a new row to the bottom of the table.
Adds a new sheet.
Cleares a specific cell.
Clears values from a specific row.
Creates a new spreadsheet.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.
Updates a specific cell.
Updates a row.
Submits a new comment or reply to a message. You can submit cca. 1 comment per 9 minutes.
Submit creates a link, a post with an image or a self-post in the subreddit with the given title. If kind is "link" or "image", then url is expected to be a valid URL to link to. Otherwise, text is the body of the self-post. You can submit cca. 1 post per 9 minutes.
Returns a list that contains multiple objects from a selected module (multiple accounts, multiple contacts, multiple tickets ...).
Returns multiple objects based on a search criteria from a selected module(ex: accounts where account name contains 'Joe', tickets where subject contains 'Hello', contacts where email contains domain '@gmail.com' ...).
Gets a range content.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.
Retrieves a list of comments in a subreddit.
Searches subreddits by query.