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.

Triggered when a lead is advanced to a new stage in the intake pipeline. Helps automate lead nurturing steps, internal alerts, and CRM status updates for better conversion tracking.

Triggered when a matter transitions between stages within the same workflow. Use this to coordinate task delegation, update internal systems, or notify stakeholders as the matter progresses.

Generates a new communication entry, such as an email, phone call, or internal message.

Adds a new note to an existing contact profile, enhancing client relationship documentation.

Records a new expense item in the system. Useful for logging reimbursable costs, hard/soft disbursements, or firm-related expenditures.

Creates a new lead associated with an individual. Use this to initiate the intake process for prospective clients who are individuals.

Creates a new lead associated with a company or organization. Ideal for managing potential corporate clients from initial inquiry to engagement.

Creates a new task associated with an existing matter. Ideal for assigning follow-ups, setting reminders, or initiating procedural steps within the matter workflow.

Creates a new individual contact in the system. Supports contact management, client onboarding, or record keeping for individuals.

Modifies the details of an existing company contact. Maintain up-to-date corporate records and ensure consistency across linked matters.

Applies updates to an existing legal matter, reflecting changes in status, assignments, or related details.

Updates the properties or status of a task, enabling dynamic task management and progress tracking.

Retrieves a specific invoice by using identifiers such as Client ID, Matter ID, or Invoice Number.

Identifies the most recently created matter based on a specified custom field criterion.

Locates a specific stage within a given pipeline by name. Ideal for assigning leads or matters to the correct phase of your process.

Searches for a pipeline in your team’s workspace by name. Useful for dynamic task or lead routing based on specific workflows.

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.

Initiates the activation of a user activated workflow as part of an automated workflow process.

Creates a new company or organizational contact. Useful for client intake, corporate record management, and linking to matters or leads.

Schedules a new event in the calendar. Facilitates appointment setting, court dates, or task deadlines within your legal workflow.

Creates a flat fee billing entry associated with a specific legal matter.

Adds a new note to a lead record, supporting enhanced lead tracking and context.

Adds a comment or internal note to an existing matter. Use this to log updates, capture insights, or maintain audit trails within the matter record.

Initiates a new legal matter with associated metadata. Perfect for starting new casework, assigning responsible parties, and launching related workflows.

Logs a new time entry for billing or internal tracking purposes. Enables timekeeping consistency across client matters and billing workflows.

Updates information for an existing lead record. Supports lead management workflows by reflecting the most recent status or engagement details.

Modifies the details of an existing individual contact, ensuring up-to-date contact information.

Searches for and returns the most recently created contact that matches a specified custom field value.

Retrieves an existing lead based on search criteria. Use this to reference, update, or act upon known prospective clients.

Locates the latest matter associated with a given client email address.

Retrieves details of a team member based on user identification criteria.