Monitor Core Web Vitals at scale with PageSpeed API and Google Sheets
Fetch the XML sitemap
Convert to JSON
xml
Extract URL tags
splitOut
Loop Over Items
noOp
Upload CSV
When clicking ‘Execute workflow’
Pick default spreadsheet to save the report
googleSheets
Add column headers to new sheet
Config
Process CSV file if uploaded, otherwise fetch the XML sitemap
Run PageSpeed audit
www.googleapis.com
Extract URLs from file
splitOut
Extract data from file
noOp
Create audit metadata
Increment error count meta
Insert API audit data into sheet
googleSheets
Wait between each batch
noOp
Increment urls_processed meta
Update audit_finish_time meta
Insert error data into sheet
googleSheets
Extract URLs
splitOut
Schedule Audit
Send audit summary email
gmail
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.