tr Skip to content
Black Friday FlowMattic for life, 12 payments of $33.25 Or $399 once. Nothing added for splitting Ends in --Days --Hrs --Min --Sec See the deal

Connect UpGuard and Google Sheets

UpGuard watches your security rating, your vendors and leaked data. FlowMattic records its alerts in Google Sheets from your WordPress site: new data leaks, identity breaches, newly monitored vendors and score changes. Security and compliance teams keep a risk register with dates, owners and status columns for audits and board reports.

16 triggers 19 actions 7 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in UpGuard10 triggers

Do this in Google Sheets19 actions

1. TriggerNew Data Leak
2. ActionAdd New Row

When UpGuard fires New Data Leak, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

UpGuard and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

UpGuard app icon Google Sheets app icon Ready-made template

Add each new UpGuard data leak to a risk register

Every data leak UpGuard publishes becomes a row with its details and date, ready for an owner, a status and the remediation steps your team adds.

New Data LeakAdd New Row

View the template
UpGuard app icon Google Sheets app icon

Log identity breaches for account resets

Breached staff identities go to a restricted tab with the date found, so IT can track which accounts have had their passwords changed.

New Identity BreachAdd New Row

UpGuard app icon Google Sheets app icon

Keep a vendor inventory as vendors are monitored

Each newly monitored vendor is added to a vendor tab, which procurement can extend with contract owner, data shared and review date.

New Vendor MonitoredAdd New Row

UpGuard app icon Google Sheets app icon

Write the latest score into the vendor's row

When a vendor's score drops, find the vendor in the inventory and update the score and date, so reviews start from the current rating.

Vendor Score DropLookup Row DataUpdate Row

UpGuard app icon Google Sheets app icon

Chart your organisation's score over time

Score drops are logged with a formatted date in a history tab, which turns into a simple trend chart for monthly security reports.

Organization Score DropDate/Time FormatterAdd New Row

UpGuard app icon Google Sheets app icon

Escalate when your score falls below a threshold

Falling below the level your policy sets is logged as an incident and emailed from your own server to the security lead.

Organization Score Below ThresholdAdd New RowEmail (SMTP)

UpGuard app icon Google Sheets app icon

Flag vendors that fall below your minimum

Vendors under your minimum score are added to a review tab, giving the vendor-risk owner a short list to raise with each supplier.

Vendor Score Below thresholdAdd New Row

Set up: data leaks in a risk register

At the end, every new data leak UpGuard publishes for your organisation is added to your risk register as one row.

  1. Prepare the register

    Add a header row such as Found, Type, Summary, Severity, Owner and Status, with Owner and Status filled by your team.

  2. Connect UpGuard and Google Sheets

    In FlowMattic, open Connects and add your UpGuard account and a Google Sheets account that can edit the register.

  3. Start with New Data Leak

    Create a workflow with the UpGuard New Data Leak trigger and capture a sample event so you can see the fields UpGuard sends.

  4. Map and switch on

    Add Google Sheets Add New Row, map the leak fields to your columns, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up
Add each new UpGuard data leak to a risk register Template
  1. UpGuard app icon 1. Trigger in UpGuard New Data Leak
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From UpGuardTo Google Sheets
    Date publishedFound
    Leak typeType
    DescriptionSummary
    SeveritySeverity
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

  • Score triggers such as Organization Score Drop and Vendor Score Below threshold take the amount or period you set in the trigger. Set them to match your policy before you switch the workflow on.
  • Breach and leak details are sensitive. Keep the register in a spreadsheet shared only with the security team, and leave out fields you do not need.
  • The register is filled from UpGuard. Marking an item resolved in the sheet does not change it in UpGuard.

Triggers (10)

  • New Identity BreachTriggers when a new identity breach is detected.
  • New Vendor MonitoredTriggers when a vendor is newly monitored.
  • New Data LeakTriggers when a new data leak is published.
  • Organization Score Below ThresholdTriggers when the organization score drops below the given amount.
  • Organization Score DropTriggers when the organization score drops by a given amount in the specified period.
  • Organization Score IncreasesTriggers when the organization score increases by a given amount in the specified period.
  • Vendor Score Above ThresholdTriggers when the vendor score rises above the given amount.
  • Vendor Score Below thresholdTriggers when the vendor score drops above the given amount.
  • Vendor Score DropTriggers when the vendor score drops by a given amount in the specified period.
  • Vendor Score InreasesTriggers when the vendor score drops by a given amount in the specified period.
Google Sheets app icon

Google Sheets

Integration page

Triggers (6)

  • New Spreadsheet RowTrigger when a new row is added to the spreadsheet
  • New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
  • Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
  • Update Cell DataTrigger when any cell is updated in the spreadsheet
  • Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
  • Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

  • Add New RowAdd a new row with mapped data
  • Update RowUpdate existing row in specific spreadsheet with mapped data
  • Delete RowDelete row by ID in specific spreadsheet
  • Clear Row DataClear data or row by ID in specific spreadsheet
  • Lookup Row DataSearch for data in specific spreadsheet
  • Get Cell DataGet data for particular cell in specific spreadsheet
  • Update Cell DataUpdate data for particular cell in specific spreadsheet
  • Get Row CountGet total number of rows in specific spreadsheet
  • Get Row DataGet rows data from the sheet based on specified range
  • Create Spreadsheet ColumnCreate a new column in specific spreadsheet
  • Create New SheetCreate a new sheet in specific spreadsheet
  • Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
  • Copy SheetCopy a sheet to another or within the same spreadsheet
  • Get RowsRetrieve rows in JSON format for use with Iterator
  • Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
  • Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
  • Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
  • Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
  • Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

UpGuard and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

An audit trail with dates

Each alert is a dated row your team adds owners and actions to, which is what auditors ask to see.

Alerts stay on your infrastructure

FlowMattic runs on your own WordPress site, so risk details go from UpGuard to your sheet through your server.

Log everything, pay the same

Runs are unlimited, so tracking every vendor change as well as your own score adds no cost.

Common questions

How do I send UpGuard alerts to Google Sheets?

Create a FlowMattic workflow with an UpGuard trigger such as New Data Leak or New Identity Breach, then add Google Sheets Add New Row and map the alert fields to your register columns.

Can I track vendor scores in the sheet?

Yes. Log New Vendor Monitored to build the vendor list, then use Vendor Score Drop with Lookup Row Data and Update Row to keep each vendor's score current.

Can I get an email when our score drops below our target?

Yes. Use the Organization Score Below Threshold trigger with your target, log it with Add New Row, then add an Email (SMTP) step addressed to the security lead.

Can the sheet show our score trend?

Yes. Log Organization Score Drop and Organization Score Increases to a history tab with the date and score, then chart the column in Google Sheets.

Who should be able to see the sheet?

Only the people who handle security incidents. Breach details can name staff accounts, so treat the spreadsheet like any other confidential security record.

Did not find your answer? You can browse the help center or ask us directly.

Start automating UpGuard and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. UpGuard integration 1.0.0, Google Sheets integration 2.2.4.