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 project has been updated in ProcessKit.

Mark a task as complete.

Create a new, empty task list in a project. Later, you can add tasks to it manually or via another Zapier action.

Apply a tag to a project in ProcessKit. If the tag doesn't exist yet, this action can create the tag and then apply it.

Assign an existing task to a person in your ProcessKit account

Mark a task as not completed yet.

Make updates to an existing project in ProcessKit, including updating project dates and other fields, moving a project to a different board, and associating a client with a project.

Update an existing task field

Find a Client in your ProcessKit account, which has a value in the selected custom client attribute field that contains this text. If there are multiple matches, the Client that was most recently created will be returned.

Find a project in ProcessKit by its project ID

Find a task within a project in ProcessKit

Find a Client in ProcessKit that has a name that contains this text. If there are multiple matches, the most recently created Client will be returned.

Find a project in ProcessKit by its title

Find a task within a project in ProcessKit

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 new project is created in ProcessKit.

Triggers when a task in a project has been marked completed.

Creates a client in ProcessKit

Creates a project in ProcessKit

Create a task in an existing task list in an existing project in ProcessKit.

Create a task list in a project. The task list and tasks will be built from a process template in your ProcessKit account.

Updates a client in ProcessKit

Update an existing task's title, content fields, start date, or due date.

Find a Client in ProcessKit that has a name that contains this text. If there are multiple matches, the most recently created Client will be returned.

Find a project in ProcessKit by its title

Find a project in ProcessKit by custom field values

Find a task field in a task by its label. Enter the exact label text (case sensitive) for the field you want to find.

Find a Client in your ProcessKit account, which has a value in the selected custom client attribute field that contains this text. If there are multiple matches, the Client that was most recently created will be returned.

Find a project in ProcessKit by custom field values