Creates a new spreadsheet row at the top of a spreadsheet (after the header row).

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

Creates a new worksheet in a Google Sheet.

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.

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 a spreadsheet by name, or creates one if none is found.

Finds or creates a specific lookup row.

Triggers when a new subscription is created/updated in CloudBlue Commerce or its status is changed to Activated, Administrative Hold, Credit Hold, Full Hold, or In Grace.

This action will create and schedule RDE job in CBC platform.

Updates the existing subscription in CloudBlue Commerce. A new Change Order is placed in CloudBlue Commerce for the subscription linked with the provided Order Number. The subscription update includes a change in its resources and their quantities.

This action creates a new Customer account and a user under it with administrator privileges in CloudBlue Commerce.

Deletes the Customer user in CloudBlue Commerce, unless it's the last admin user.

Creates a new sales order in CloudBlue Commerce. The external system can pass an order reference to map the corresponding order object to the order object in CloudBlue Commerce.

Updates the Customer user information in CloudBlue Commerce.

Finds Customer user records in CloudBlue Commerce. Allows filtering the records with the Customer ID and User Type.

Finds and returns the service-specific information of a subscription from the CloudBlue Commerce OSS. For Connect-based services, this information includes the activation parameter URL, activation tile data, and so on.

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 spreadsheet by name.

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 find worksheet.

Triggers when a service plan is created or updated in CloudBlue Commerce.

Triggers when an order (Sales Order/Change Order/Billing Order/Cancel Order/Renew Order) is created in CloudBlue Commerce. It also includes filter options to select order type and status.

Cancels an existing subscription in CloudBlue Commerce.A new Cancel Order is placed in CloudBlue Commerce for the subscription linked with the provided Order Number.

Changes subscription status to Administrative Hold or Active.

Creates a new Customer user in CloudBlue Commerce.

Renews the existing subscription in CloudBlue Commerce. A new Renew Order is placed in CloudBlue Commerce for the subscription linked with the provided Order Number.

This action updates a Customer account in CloudBlue Commerce.

Finds Customer records in CloudBlue Commerce. Allows filtering the records with the Account ID and/or the external system ID. If no filter is passed, the last created Customer record is returned.

Finds orders in CloudBlue Commerce. Allows filtering the records with the CloudBlue Commerce Order Number and/or the external system Order ID. If no filter is passed, the last created order record is returned.

Finds subscriptions in CloudBlue Commerce. Allows filtering the records with the CloudBlue Commerce Order Number and/or the external system Order ID. If no filter is passed, the last created subscription record is returned.