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.

Triggers when new messages appears on multiple Connect objects like asset or listing requests. This trigger uses polling to CloudBlue Connect.

Triggers when a new helpdesk case appears on the case queue using polling to CloudBlue Connect.

Triggers when a new conversation appears on the conversations queue using polling to CloudBlue Connect.

Triggers when a new recurring asset appears on the subscriptions queue using polling to CloudBlue Connect.

Triggers when a new tier account request appears on the fulfillment queue using polling to CloudBlue Connect.

Triggers when a billing request is created or gets updated on the billing queue using polling to CloudBlue Connect.

Triggers when a fulfillment request is created or gets updated on the fulfillment queue using polling to CloudBlue Connect.

Triggers when a Tier Configuration Request is created or gets updated on the fulfillment queue using polling to CloudBlue Connect.

Vendors can use this action to approve a concrete request that is in status pending.

Vendors and Distributors can use this action to change status Listing Requests.

Vendors can use this action to confirm a concrete request that is in status revoking.

Distributors can create cancel requests using this action, in order to cancel an asset.

Allows the creation of a single request of type "change" on a existing asset in CloudBlue Connect. The asset identifier can be passed from previous steps of the Zap.

Distributors can create purchase requests using this action, action has line items support to add multiple items or set multiple parameters of ordering type together with the request.

Allows the creation of a single request of type "resume" on a existing asset in CloudBlue Connect. The asset identifier can be passed from previous steps of the Zap.

Distributors and Vendors can create a new Billing Request.

Can create a helpdesk cases using this action,

Vendors and Distributors can use this actions to add messages to conversations on multiple objects like asset requests, this messages can be seen by vendors and distributors and can provide valuable information like reason why a request has not been approved.

Distributors can create Update Tier Config Requests for existing Tier Configs, the Tier Config ID is required and can be obtained using the search, the list of parameters to update must be known and could be all of type order.

Vendors can use this action to Reject Tier Configuration Requests.

Vendors can use this action to populate values for Fulfillment parameters on Asset requests that are in pending status, with the help of line items support is possible to populate them dynamically and populate the ones resulting from previous steps of the Zap.

Vendors can use this action to populate values for Fulfillment parameters on Tier Config Requests, with the help of line items support is possible to populate them dynamically and populate the ones resulting from previous steps of the Zap.

Allows the settings on the "Inquire" status on a existing helpdesk case in CloudBlue Connect. The asset identifier can be passed from previous steps of the Zap.

Vendors can use this action to inquire a request setting multiple parameters that needs changes, this action is useful when external systems can define the list of parameters to inquire for.

Vendors can use this action to inquire a pending Tier Config Request for parameters obtained on previous steps of the zap, like for example when interacting with Vendor API and API can define multiple fields that requires refinement.

Distributors and Vendors can use this action to reject a concrete request.

Distributors can use this action to revoke a concrete request that is in status scheduled.

Can update helpdesk cases using this action,

Search for Billing Requests.

Search for Comments by Case.

Search for Listing Requests.

Search for Asset Requests.

Search for Tier Configurations.

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 billing request appears on the billing queue using polling to CloudBlue Connect.

Triggers when a new comment of helpdesk case appears on the case queue using polling to CloudBlue Connect.

Triggers when a request is created or updated for a particular product using a CloudBlue Connect Webhook.

Triggers when a new fulfillment request appears on the fulfillment queue using polling to CloudBlue Connect.

Triggers when a new Tier Configuration Request appears on the fulfillment queue using polling to CloudBlue Connect.

Triggers when a recurring asset is created or gets updated on the subscriptions queue using polling to CloudBlue Connect.

Triggers when a tier account request is created or gets updated on the fulfillment queue using polling to CloudBlue Connect.

Vendors can use this action to accept a concrete request that is in status pending.

Vendors can use this action to approve pending Tier Configuration Requests.

Allows the settings on the "Closed" status on a existing helpdesk case in CloudBlue Connect. The case identifier can be passed from previous steps of the Zap.

Distributors can create adjustment requests using this action, action has line items support to add multiple items or set multiple parameters of ordering type together with the request.

Allows the creation of a single request of type "change" on a existing asset in CloudBlue Connect. The asset identifier can be passed from previous steps of the Zap.

Distributors can create purchase requests using this action, action has line items support to add multiple items or set multiple parameters of ordering type together with the request.

Enables distributors to create or modify one or multiple assets with a single order payload from an external system. Automatically detects products set in the payload. No limits for the maximum number, but at one item of one product needs to be present.For a given product, automatically detects if a new asset needs to be created or existing needs to be adjusted by searching via external asset id.

Allows the creation of a single request of type "suspend" on a existing asset in CloudBlue Connect. The asset identifier can be passed from previous steps of the Zap.

Distributors and Vendors can create a new Billing Request.

Can create helpdesk case comments using this action,

Distributors can create a new Tier Account Request to communicate data changes to vendors.

Distributors can create Update Tier Config Requests for existing Tier Configs, the Tier Config ID is required and can be obtained using the search, the list of parameters to update may come from previous step of the Zap due line item support, please note that only ordering type parameters can be updated.

Vendors can use this action to populate values for Fulfillment parameters on Asset requests that are in pending status, the values can come from previous steps.

Vendors can use this action to populate values for Fulfillment parameters on Tier Config Requests knowing the list of parameters they want to populate, the values can come from previous steps.

Vendors can use this action to ignore a concrete request that is in status pending.

Vendors can use this action to inquire a pending request knowing the concrete request parameters they want to inquire for.

Vendors can use this action to inquire a pending Tier Config Request for parameters obtained on previous steps of the zap, like for example when interacting with Vendor API and API can define multiple fields that requires refinement.

Allows the settings on the "Pending" status on a existing helpdesk case in CloudBlue Connect. The case identifier can be passed from previous steps of the Zap.

Allows the settings on the "Resolved" status on a existing helpdesk case in CloudBlue Connect. The case identifier can be passed from previous steps of the Zap.

Vendors can use this action to schedule a concrete request that is in status pending.

Search for Assets.

Search for Cases.

Search for Conversations.

Search for Recurring Assets.

Search for Tier Account Requests.

Search for Tier Configuration Requests.