Connect PageVitals and Google Sheets

PageVitals tests your pages on a schedule and reports Core Web Vitals for each run. FlowMattic writes every completed series to Google Sheets, so you can chart performance over months, compare client sites in one file, and hear about a slow page before a client does.

Try FlowMattic free See example workflows

8 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in PageVitals2 triggers

Do this in Google Sheets19 actions

1. TriggerSeries Completed

2. ActionAdd New Row

When PageVitals fires Series Completed, 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

PageVitals 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.

Ready-made template

Log each completed PageVitals test series

Every finished series adds a row with the page, device and scores, building a performance history you can chart in the sheet.

Series CompletedAdd New Row

View the template

Record multistep checkout and login tests separately

Multistep Completed results go to their own tab, so a slow checkout flow is not hidden among single-page tests.

Multistep CompletedAdd New Row

Email the developer when a page goes over budget

The result is logged first. A Filter then checks the score against your budget and Email (SMTP) tells the developer which page slipped.

Series CompletedAdd New RowFilterEmail (SMTP)

Keep a latest-result tab with one row per page

Next to the full history, look the page up in a summary tab and overwrite its scores, so anyone can see where each page stands now.

Series CompletedAdd New RowLookup Row DataUpdate Row

Round timings before they reach the sheet

Number Formatter turns long millisecond values into seconds with two decimals, so the columns read cleanly in a client report.

Series CompletedNumber FormatterAdd New Row

Give each client website its own tab

Agencies testing many sites route each result by website to a matching tab, ready to share with that client.

Series CompletedRouterAdd New Row

Set up: a row per test series

At the end, each completed PageVitals test series adds a row of results to your sheet.

Create the results tab
Add headers such as Page, Device, LCP, CLS, TBT and Tested at.
Connect Google Sheets
Under Connects, add a Google account that can edit the spreadsheet.
Choose Series Completed
Create a workflow with the PageVitals Series Completed trigger and follow the setup shown in the trigger step.
Run a test
Start a test in PageVitals so FlowMattic captures a completed series.
Map the scores
Add Google Sheets Add New Row, map each metric to its column, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From PageVitals	To Google Sheets
Page URL	Page
Device	Device
Largest Contentful Paint	LCP
Cumulative Layout Shift	CLS
Completed at	Tested at

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

The metrics in each result depend on the tests you set up in PageVitals, so the mapping is an example. Check a captured series before mapping.
Series Completed and Multistep Completed are separate triggers. Build one workflow for each if you run both kinds of test.
Set number formats on the metric columns so the sheet's charts treat them as numbers, not text.

PageVitals

Integration page

Triggers (2)

Series CompletedTriggers when a test series gets completed.
Multistep CompletedTriggers when a multipal test series gets completed.

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

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

History you keep

Scores pass through your WordPress server into your own sheet, so the history stays with you if you change tools.

Frequent tests cost the same

Runs are unlimited, so testing many pages several times a day needs no bigger plan.

Reports clients understand

A tab per site with readable numbers is easier to share than a dashboard login.

Common questions

How do I export PageVitals results to Google Sheets?

Create a workflow with the PageVitals Series Completed trigger, run a test, then add Google Sheets Add New Row and map the page and metric fields to columns.

Can I get an alert when a page gets slower?

Yes. After logging the row, add a Filter that compares a metric with your limit and an Email (SMTP) step that names the page and score.

Can I see only the latest score for each page?

Yes. Keep a summary tab with one row per page. Find the page with Lookup Row Data and overwrite its scores with Update Row each time a series completes.

Are multistep tests included?

Yes, through the Multistep Completed trigger. Give those results their own tab, since a multistep flow reports on several steps rather than one page.

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

Start automating PageVitals and Google Sheets

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

Try FlowMattic free See pricing

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. PageVitals integration 1.0.0, Google Sheets integration 2.2.4.