How To Export PageSpeed Insights Data To Google Sheets
- Use PageSpeedPlus which automatically stores PageSpeed Insights data in a google sheet
- Start by adding your website homepage
Getting PageSpeed Insights data into a Google Sheet or other products for analysis is often required for bespoke reports and monitoring. Without the right tools, this is time-consuming and involves scripts, API keys, handling errors, rate limiting and parsing data.
PageSpeed Plus is the solution to this problem and automatically Exports PageSpeed Insights data to Google Sheets which can then be consumed in Data Studio, Tableau, Power BI and more. This allows you to create whatever reporting experience your business needs and configure alerts beyond those offered by our platform.
Contents
- What Is PageSpeedPlus?
How Can I Export My Data To Google Sheets?- Exporting to Data Studio
- PDFs
- CSVs
- Benefits
- Conclusion
What is PageSpeedPlus?
PageSpeedPlus is the best tool on the market for monitoring PageSpeed Insights scores with automated daily scans that check your important URLs. Each scan consists of multiple tests on desktop and mobile to gather an average score, which is then stored in our database.
All of this information is presented for users with nice charts and tables in our dashboard to help you see at a glance what your grades are and also drill deeper for URL level analysis if needed. There's a lot of data to show so we make a big effort to ensure the information is clear and easy to understand as too much only generates noise.
On top of this, we automatically export monitored URL scan results to the extremely powerful Google sheets platform. This feature was built based on feedback from users who needed a custom view of their data that we didn't offer and wanted to export it for consumption elsewhere.
How can I export my data to Google Sheets?
There's literally nothing for you to do. From the moment your first monitored URL scan runs, the data is automatically exported to a Google Sheet. (Full site scan and global load times data is not exported to Gsheets at this time)
The sheet can be accessed by clicking the GSheets button on your site.
When that's done for the first time you'll need to enter a google email address that has access to Google Docs because the sheets are private. Apart from that, there's little else to do. No need to download files or merge CSVs. In short, it all just works.
Each website added to our platform gets a custom Google Sheet spun up so if you have 10 sites, you'll have 10 corresponding sheets. Every time a Monitored URL is scanned, a new row is appended to the file with all the information available for mobile and desktop: URL, PageSpeed Insights score, Web Vitals scores, scan time and more.
Our scans will continue to silently run in the background and the sheet will grow over time so when you need it, rich PageSpeed Insights Data is already exported to a sheet you own and is ready to be used.
Exporting to Data Studio
With the pagespeed insights data automatically exported to google sheets, getting it into data studio(looker) is simple because Data Studio supports Google sheets as a data source.
To get your pagespeed insights data into data studio follow these steps
- Open https://datastudio.google.com/
- In the top left Create > Data Source
- Select Google Sheets
- Click SHARED WITH ME
- Choose the sheet and click Connect
This will create your first data studio report and from here it can be customised as needed.
Exporting to Google Sheets is for users who need to do further data manipulation. Some users have simpler use cases and just want a PDF of the latest scan. That's possible also by clicking the PDF button in the dashboard to get monitored URL data or by clicking into a Full Site scan and clicking the PDF button there.
This exports a static PDF in a ready to present format, which can even be branded with your business logo.
CSV
The latest scan data can also be exported in CSV format. Just follow the steps above and click on the CSV button instead of the PDF.
Benefits of exporting PageSpeed Insights Data
Despite how wonderful our charts are, getting the data into your tools gives you more options. Here are a few examples:
Custom Reporting Our reports focus on PageSpeed because that's what we do. However, we're aware that it's only one part of the story and often needs to be presented alongside other data points to give a full picture of website health. Our dashboards cannot do that so exporting the data to Google Sheets allows bespoke reports to be generated which include page speed and multiple other data points about a URL. This facilitates more rounded reporting that meets all of the stakeholder needs without having to jump around multiple graphics and charts.
Custom Alerts We offer Email, Slack and Microsoft Teams alerts when PageSpeed scores fall. If you want an alert via another platform, exporting the data out to another tool gives you the flexibility to integrate with whatever tool you need. This means you can send alerts via PagerDuty (which we're building an integration with), Hipchat and anything else.
Backup We hope you stay a customer forever but if we ever part ways, it's only right that you should still be able to access your data. By exporting it to Google Sheets, you'll have access forever (although no further data will be appended) and can look back if needed.
Wrapping Up How To Export PageSpeed Insights Data To Google Sheets
| ⌨️ Start Now | Add your homepage URL |
| 🖱️ Trigger A Scan | Data is automatically copied to Google Sheets |
| 🔍 View | Open the sheet to see the pagespeed data |
Now you know how to set up PageSpeed Insights monitoring for your website and have the data automatically exported to Google Sheets so it can be analysed in other tools.
There's no need to mess around with scripts, write google functions and deal with failures because PageSpeedPlus has solved these problems already. With a few clicks, you can have your first scans running syncing data to Google in minutes. It really couldn't be any easier.
We can only Export PageSpeed Insights data from the moment you sign up so get started now by clicking the button below.