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 company vendor is added.

Triggers when a new drawing is added.

Triggers when a new Form is created.

Triggers when a new Incident is created.

Triggers when a new Inspection Log is added.

Triggers when a new Manpower Log is added.

Triggers when a new Observation is added.

Triggers when a new project file is added.

Triggers when a project is updated.

Triggers when a new requisition is added.

Triggers when a new submittal is added.

Triggers when a new Task is created.

Triggers when a Timesheet is approved.

Triggers when an RFI is updated.

Triggers when a new Work Order Contract is created.

Creates a new worker for a specific project.

Creates a new change event.

Deletes a specific file by ID for a given company.

Creates a new project cost code.

Creates a new budget line item in the specified project.

Creates a new Direct Cost Item.

Creates a new Form associated with the specified Project.

Creates a new Line Item for the Prime Contract.

Creates a new Subcontract Invoice.

Creates a new document.

Creates a new document folder.

Deletes a company folder by ID and moves it to the recycle bin.

Creates an Incident in a given project.

Updates the specified Incident.

Deletes a form by ID.

Creates a new inspection checklist.

Creates a Prime Contract Invoice.

Creates a new punch item.

Creates a new RFI with the specified details.

Creates a new Sub Job.

Creates a new timesheet.

Updates an existing Purchase Order Contract.

Updates a project Submittal.

Creates or updates a Work Breakdown Structure (WBS) code for a project.

Search for company vendor by id.

Search for an incident by id.

Search for a project task by id.

Search for a submittal by id.

Search for a Work Breakdown Structure (WBS) code by ID.

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.