How to Bulk Check PageSpeed Using Google Sheets and PageSpeed API

If you're managing multiple websites or web pages, checking their performance individually can be time-consuming. You can automate the process using Google Sheets and the PageSpeed API. Here's a quick guide to help you get started.

Step 1: Get a PageSpeed API Key

First, you must generate an API key from Google to access the PageSpeed Insights API. Visit the Google Developer Console, click “Get A Key,” and create a project. After creating the project, you'll receive your unique API key. Make sure to copy and save this key for later use.


Step 2: Set Up the Bulk PageSpeed Google Sheet

Next, go to the Bulk PageSpeed Google Sheet and make a copy by selecting 'Make a Copy' from the 'File' menu. Replace the URLs in column A with the list of pages you want to analyze. 

To enable the automation, open the Google Apps Script editor by going to the "Extensions" menu and selecting "App Script". When prompted, approve access to the script by clicking "Go to Bulk_PageSpeed_Automation (unsafe)."

In the script, replace the placeholder 'Your API Key' with the API key you obtained earlier. Ensure the API key is enclosed in quotes. The API URL can also be found in the CURL section of the script.

Step 3: Run the Script

Now you're ready to execute the script. Click "Run" to start the analysis. The time it takes will depend on how many URLs you're checking. 


Once completed, two new sheets will appear:  Mobile and Desktop. These will display the PageSpeed scores for mobile and desktop versions of each URL. Additionally, any URLs that return errors (like 404 or 500 status codes) will be highlighted in red on the original sheet.

By following these steps, you can easily track the performance of multiple web pages and identify areas for improvement.

Location: India

Popular posts from this blog

How to Check for an ETag on Your Website (If It Exists)

Image
Google has updated its crawler documentation to include detailed information about caching, providing valuable insights for optimizing Google’s crawler. SEOs and publishers can enhance crawling efficiency and better use server resources by adhering to the updated guidelines for implementing effective HTTP caching headers. Read the complete article by SEJ here: Googles Updated Crawler Guidance Recommends Etag How to Determine If Your Website Uses ETags Open DevTools by pressing Control+Shift+I (Windows) or Command+Option+I (Mac). Navigate to the Network tab. Initially, the Network panel will be empty. Reload the page to log network activity. Each row in the panel represents a resource, typically the top resource being the main HTML document. Click on a resource, then select the Headers tab to view the HTTP headers. Look for the ETag under the "Response Headers" section.
Read more

Free Backlink Checker - Inbound Links Analysis Made Easy and Free

Image
FREE Backlink Checker Tool - A Gem for Backlink Analysis  To succeed in the competitive world of online marketing, you need to stay ahead of your competitors. Ahrefs' Backlink Checker is an effective tool at your service. This tool allows you to analyze your backlink strategy and gain insight into your competitors' link-building tactics. Even better, you can use it for free . In this blog post, we'll explore the Ahrefs Backlink Checker and how it can help you decode your rivals' strategies. Understanding the Significance of Backlinks Let's first understand why backlinks are important for SEO and online visibility. Backlinks are like votes of confidence from other websites. When high-authority websites link to your content, search engines like Google consider your content trustworthy and authoritative. This leads to higher search engine rankings, resulting in increased visibility and traffic for your website. Introducing Ahrefs' Backlink Checker Ahrefs is a r...
Read more