Connect Google Sheets and Security Reporter to unlock the power of 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 one Assessment is completed.

Triggers when one Assessment is updated.

Triggers when one Finding is published.

Triggers when one Activity is created or updated.

Triggers when one Assessment is created or updated.

Triggers when one Client is created or updated.

Triggers when one Finding Event is created or updated.

Triggers when one Finding is created or updated.

Triggers when one Global Role is created or updated.

Triggers when one Output File is created or updated.

Triggers when one Task is created or updated.

Triggers when one Theme is created or updated.

Triggers when one Tool Target is created or updated.

Triggers when one User is created or updated.

Create a new client.

Create a new finding comment.

Perform a retest.

Request a retest.

Create a new assessment.

Create a new assessment section comment.

Adds a reaction to the provided model, if that reaction does not exist for the current user.

Create a new task.

Create a new user group.

Remove a task set's tasks from an assessment.This does

Retrieve the stored file contents of the given document.

Retrieve all details of the given finding.

Retrieve all details of the given assessment section.

Retrieve all details of the given target.

Retrieve all details of the given task set.

Retrieve all details of the given tool finding.

Retrieve all details of the given user group.

This route supports both GET and POST requests. The POST request supports passing a password that will be used to encrypt the resulting PDF report.If an admin has enabled the 'Password-protect PDF reports' setting in the application settings, a password is

Update an existing client.

Update an existing finding comment.

Update an existing finding template.

Update an existing assessment comment.

Update an existing assessment section.

Update assessment-specific values for a user assigned to the assessment.

Update an existing finding retest inquiry.

Update an existing task.

Update an existing tool finding.

Update an existing user.

Upload a new (draft) document.

Search for one Activity.

Search for one Assessment.

Search for one Client.

Search for one Finding Event.

Search for one Finding.

Search for one Global Role.

Search for one Output File.

Search for one Task.

Search for one Theme.

Search for one Tool Target.

Search for one User.

x

x

x

x

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 one Assessment is created.

Triggers when one Finding is created.

Triggers when one Finding is updated.

Triggers when one Assessment Role is created or updated.

Triggers when one Assessment Template is created or updated.

Triggers when one Custom Field is created or updated.

Triggers when one Finding Layout is created or updated.

Triggers when one Finding Template is created or updated.

Triggers when one Language is created or updated.

Triggers when one Target is created or updated.

Triggers when one Task Set is created or updated.

Triggers when one Tool Finding is created or updated.

Triggers when one User Group is created or updated.

Assign an existing task set's tasks to an assessment.

Create a new finding.

Create a new finding from a

Cancel a retest request.

Create a new finding template.