Update Google Sheets properties like frozen rows/columns, sheet position, and visibility settings.

Copy data from one range to another within a Google Sheets spreadsheet, with options for what to paste (values, formatting, etc.).

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Format a row in a specific spreadsheet.

Set data validation rules on a range of cells in Google Sheets to control what data can be entered.

Update a row in a specific spreadsheet with optional formatting.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a worksheet by title.

Return up to 1,500 rows as a single JSON value or as line items.

Get a specific Google Spreadsheet by its ID. Returns the raw spreadsheet data from the Google Sheets API.

Finds or creates a specific find worksheet.

Delete a bundle. This action is irreversible. The bundle will be permanently removed.

Create check-in or check-out.

Creates a discount code that can be used on checkout.

Returns a single discount; all currency values are in cents (or equivalent), with no decimals.

Updates an existing discount.

Returns a list of events.

Delete event occurrence.

Returns a list of event occurrences.

Change status for a given event series.

Deletes event series.

Returns a list of event series.

Updates an existing event series.

Delete a hold. This action is irreversible. The hold will be permanently removed.

Returns a list of holds.

Creates a redemption for an issued membership at a specific event. This records that the issued membership was used for entry to the event.

Returns a temporary signed URL for the issued membership photo.

Updates an existing issued membership.

Creates a new issued ticket for an event occurrence from the available inventory. This action incurs a fee per issued ticket, even if the ticket is free. Send the event_id and ticket_type_id to create the issued ticket from an event occurrence's ticket type allocation. Alternatively, send the hold_id to create the issued ticket from a pre-existing hold. The issued ticket is not associated to an order. The request will fail if no tickets are available to fulfil the request, or the ticket type is a 'seated' type (uses a seating chart).

Returns a list of issued tickets.

Creates a new membership type.

Returns a single membership type.

Updates an existing membership type.

Returns an order belonging to the box office; all currency values are in cents (or equivalent), with no decimals.

Updates an existing order

Update existing override.

Delete a product. This action is irreversible. The product will be permanently removed.

Returns a list of products.

Returns store configuration.

Updates store configuration.

Delete a ticket group. This action is irreversible. The ticket group will be permanently removed and any ticket types or bundles in the group will be removed from the group.

Create a ticket type for the given event series id.

Update existing ticket type.

Mark a voucher code as voided. This action is irreversible. This will only mark one voucher code as voided, and will not impact the other related codes.

Delete voucher and its associated voucher codes. This action is irreversible. The voucher and its voucher codes will be permanently removed.

Returns a list of vouchers.

Deletes a waitlist signup. This action is irreversible.

Apply conditional formatting to cells in a Google Sheets spreadsheet based on their values.

Creates a new worksheet by copying an existing worksheet.

Permanently delete a worksheet from a Google Sheets spreadsheet. Warning: This action cannot be undone.

Apply date, number, or style formatting (colors, bold, italic, strikethrough) to a range of cells in a Google Sheets spreadsheet.

Rename a worksheet in a Google Sheets spreadsheet.

Sort data within a specified range in Google Sheets by a chosen column in ascending or descending order.

Update one or more rows in a specific spreadsheet (with line item support).

Find up to 500 rows based on a column and value as line items.

Get data from a specific range in a Google Spreadsheet using A1 notation (e.g., "A1:D10", "B2:E5").

Get a specific spreadsheet row by its row number (ID). Row 1 is typically the header row.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row.

Finds or creates a specific lookup row.

Triggers when a new waitlist signup is created.

Create a bundle for the given event series ID.

Update existing bundle.

Returns a list of check-ins.

Delete a discount. This action is irreversible. The discount will be permanently removed.

Returns a list of discounts.

Returns a single event; all currency values are in cents (or equivalent), with no decimals.

Create event for event series.

Returns a single event occurrence; all currency values are in cents (or equivalent), with no decimals.

Updates an existing event occurrence.

Creates a new event series.

Returns a single event series; all currency values are in cents (or equivalent), with no decimals.

Returns a list of event series overrides.

Creates a new hold in the system.

Returns a single hold.

Creates a new issued membership.

Returns a single issued membership.

Returns a list of issued memberships.

Voids an existing issued membership.

Returns a single issued ticket.

Mark an issued ticket as voided. This action is irreversible. This will only mark the ticket as voided (no longer valid) and will not cancel an entire order or issue a refund. You can also void an issued ticket to a hold, which will create a hold from the issued ticket and not put the allocation back on sale.

Delete membership type.

Returns a list of membership types.

Confirm that an offline payment has been paid.

Returns a list of orders belonging to box office.