Connect Google Sheets and RO App to power AI-driven automation

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 a new get_booking_by_id is created.

Triggers when a new get_invoice_by_id is created.

Get the list of orders

Triggers when a new get_payments is created.

Lists the invoices.

Lists of the products.

Creates a new booking item, probably with input from previous steps.

Creates a new lead comment, probably with input from previous steps.

Creates a new order item, probably with input from previous steps.

Creates a new booking.

Create new client

Create new order

Create a new Payment

Change order status

Creates a new product.

Creates a new update_booking, probably with input from previous steps.

Update_client, probably with input from previous steps.

Updates an existing order item, probably with input from previous steps.

Finds bookings based on the given criteria.

Finds an order based on id.

get the Task By it's Id

The list of assets you can use in the product

Search For Task by params

The list of clients you can use in the product

The list of assets you can use in the product

Finds a service give.

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.

Lists the bookings.

Get the list of Assets.

Triggers when a new get_booking_items is created.

Triggers when a new get_location_resources is created.

Triggers when a new get_order_items is created.

Get sales from account

get tasks list filtered by employees or creation date

The list of clients you can use in the product

Lists the services.

Creates a new comment in the invoice, probably with input from previous steps.

Creates a new order comment, with given order_id

Creates a new task comment, probably with input from previous steps.

Use this method to create new Assets

Create new lead

Create new order or estimate

Create Task for given Employees

Move asset to different warehouse, probably with input from previous steps.

Creates a new service.

Updates an existing booking item, probably with input from previous steps.

Update existing order or estimate

Update a product, probably with input from previous steps.

Get a Client by ID.

Finds a product based on id.

Finds a invoice give.

Finds a product give.

Finds a service give.