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.
Generates bundles with their own structure.
Responds to events (contact added, updated, unsubscribed, added to list, removed from list, entered segment and left segment). Will return related contact ID, contact and possibly related list ID or segment ID.
Composes a string for easier mapping of scenarios.
Converts a text from one codepage to another.
Switches the output based on the input.
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.
Get the value of a previously stored variable.
Returns a value of 1 after first run. Every subsequent run will increment the returned value by 1.
Sets the value of the variable.
Delays execution for a specified period of time.
Add contacts to journeys.
Adds a contact to a list.
Add a new list.
Allows you to create or update a contact.
Removes the contact from your database.
Deletes the activity feed of a contact.
Retrieves the given contact record given the contact ID or email.
Retrieves an email campaign's data based on an ID received in the Autopilot Activity Stream.
Checks if a contact belongs to a particular list.
Performs an arbitrary authorized API call.
Removes a contact from a list.
Unsubscribes the contact from receiving emails from your Autopilot Journeys.
Updates the details of a contact. This method will return the contact's ID number.
Applies the aggregate function to selected rows.
Aggregates selected values into a table.
Aggregates multiple strings into one text.
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.
Returns a list of your contacts.
Returns a list of all available lists.
Returns a list of all of the contacts which are on this list.
Returns a list of all of the contacts which are on this smart segment.
Returns a list of API Triggers along with the journey name to help you identify the correct one.
Returns a list of all available smart segments.