iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
To run PageSpeed Insights on hundreds of URLs and get one spreadsheet back, automate one PageSpeed Insights API request per URL, extract a consistent set of results, and write the rows to a spreadsheet in batches. Google documents a single URL as the input to the API’s runPagespeed method; the batch comes from your script or client, not a native bulk-URL request. A reliable workflow also records failures and distinguishes Lighthouse lab results from Chrome UX Report (CrUX) field data.
How the batch workflow works
The PageSpeed Insights (PSI) API returns structured analysis for the URL in its required url parameter. To process a list, your automation loops through the URLs, makes a request for each one, extracts selected fields, and writes one result row per input URL. See Google’s PageSpeed Insights API overview and runPagespeed method reference.
- Prepare the URL list. Put one complete URL in each row of a source column. Remove blank rows and decide how you want to handle duplicate URLs, redirects, and URLs with query parameters.
- Choose settings once. Set the strategy to mobile or desktop and select the Lighthouse categories you want. The API defaults to desktop; if you omit the category, the method reference says only Performance runs.
- Request results one URL at a time. Have your script call
runPagespeedfor each input and retain the requested URL and the time of the attempt. - Extract a defined set of fields. Select the summary metrics and audit details you need instead of trying to place the entire nested response in a cell.
- Write rows in batches. Accumulate results and send fewer spreadsheet writes rather than issuing a separate write for every cell or result.
- Keep failures in the output. Record the URL, status or error, and attempt time even when the analysis fails. This makes it possible to retry selected rows without losing track of skipped pages.
Google’s getting-started guide documents the API request pattern and response. The loop, row design, and batching are implementation choices you add around that single-URL method.
Choose what the spreadsheet should capture
Keep one row per attempted URL and make the test settings visible. A practical column layout is:
#1 Best Overall
- FULL HD IPS DISPLAY - Enjoy vibrant, crystal-clear images with 178-degree wide-viewing angles
- AMD RYZEN 3 30 PROCESSOR - Everyday performance you can count on; Multitask, stream, game casually, and edit photos smoothly with responsive power and vibrant HDR visuals
- ENJOY UP TO 14 HOURS AND 15 MINUTES OF BATTERY LIFE - HP Fast Charge restores battery from 0 to 50% in approximately 45 minutes
- AMD RADEON 610M GRAPHICS - Experience smooth entertainment; Built for streaming and multitasking, enjoy realistic visuals and efficient performance for work and play
- STORAGE AND MEMORY - 512 GB PCIe NVMe M.2 SSD offers fast speed and efficient storage; and 8 GB LPDDR5 RAM memory boosts performance with higher bandwidth
| Column | What it records |
|---|---|
| Input URL | The URL provided to the request. |
| Final URL | The resolved URL reported in the response, when available. |
| Fetch time | When the script made the request, preferably in a consistent time zone. |
| Strategy | Mobile or desktop. |
| Categories | The requested Lighthouse categories, such as Performance or Accessibility. |
| Performance score | The Lighthouse Performance score, if returned. |
| Lab metrics and audit summaries | The selected Lighthouse metrics or audits relevant to your review. |
| Field data status and granularity | Whether CrUX data was available and whether it represents the page or the origin, when reported. |
| API status and error | Success or failure information, including an error message when returned. |
| Lighthouse version | The version reported in the response, when present. |
These columns make comparisons interpretable: a mobile result is not a desktop result, and a page-level CrUX value should not be mistaken for an origin-level value. Keep the raw response separately if you need later re-parsing, but avoid making an unfiltered JSON dump the only report.
Interpret lab results and field data separately
PSI combines two kinds of information. Lighthouse lab analysis runs under controlled conditions and is useful for diagnosing performance issues. CrUX field data summarizes real-user experiences over a collection window, so it answers a different question and can vary in availability. Google describes the distinction in About PageSpeed Insights.
Rank #2
- Intel Celeron N4120: 4 Cores & Threads, 1.1GHz Base Clock, Up to 2.6GHz Boost Clock, 4MB Cache, Intel UHD Graphics 600. The perfect combination of performance, power consumption, and value helps your device handle multitasking smoothly and reliably with four processing cores to divide up the work.
- Lab data: Use it to investigate page behavior under the test conditions. Do not treat a lab score as a direct measurement of every visitor’s experience.
- Page-level field data: When there are enough eligible real-user samples, CrUX may provide data for the specific page.
- Origin-level field data: If page-level samples are insufficient, PSI may use origin-level data. Label its granularity in the spreadsheet rather than presenting it as a page-specific result.
- No field data: An origin can also lack enough eligible data. Record that field data is unavailable; do not interpret the absence as a zero score or a failed Lighthouse run.
Google’s getting-started guide says CrUX data in the PSI API is planned for discontinuation and recommends the CrUX API or CrUX History API for continued access. The cited guidance does not establish a completion date, so verify Google’s current migration notice before depending on PSI’s field-data response. If you add CrUX separately, keep its results and provenance identifiable rather than silently mixing them with PSI lab results.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Plan for quotas, retries, and long runs
Do not assume the spreadsheet service’s quota is the same as the PSI API’s quota. The current precise PSI API limit is not established here; check the applicable quota for your Google Cloud project and pace requests accordingly. Design the job to pause, retry, and resume instead of relying on an assumed request rate.
Rank #3
- Stunning 15.6" FHD IPS Display: Experience crisp 1920x1080 resolution on this 15.6 inch laptop with an IPS panel that delivers wide viewing angles and vivid colors. The narrow-bezel design maximizes screen real estate for comfortable viewing on this Win 11 laptop, whether you're studying or working.
- Celeron J4105 Processor & 256GB SSD: Powered by a reliable Celeron J4105 processor paired with 12GB DDR4 memory and a fast 256GB M.2 SSD. This laptop computer supports SSD expansion up to 2TB and TF card expansion up to 1TB, so your storage grows with your needs. Delivers smooth multitasking for daily productivity.
- AI-Powered Win 11 Laptop: Built-in AI features enhance your productivity with smart assistance for writing, summarizing, and task management. Pre-installed with Win 11 and includes Office 365 subscription. This student laptop is backed by 1-year warranty and 24/7 customer support.
- All-Day 7000mAh Battery & 180° Hinge: The high-capacity 7000mAh battery keeps this laptop powered through long classes or meetings. The 180-degree lay-flat hinge lets you share your screen effortlessly during presentations. This durable laptop computer adapts to your dynamic workflow.
- Versatile Connectivity Hub: Equipped with USB 3.2, Type-C, Mini HDMI, and 3.5mm audio jack to connect all your peripherals. Stay online anywhere with high-speed 5G WiFi and Bluetooth 4.2. This college laptop keeps you connected at home, in the library, or on the go.
- Sheets API: Google documents 300 read requests per minute per project and 60 per minute per user per project, with equivalent write limits. Its guidance recommends exponential backoff after HTTP 429 responses and suggests a 2 MB maximum payload for performance. These are Sheets API limits, not PSI request limits. See Google Sheets API usage limits.
- Apps Script: URL Fetch, trigger runtime, and other quotas apply separately and vary by account type. Google’s quotas page lists examples of 20,000 URL Fetch calls per day for consumer accounts and 100,000 for Workspace accounts; limits may change, and quota exhaustion can stop a script. Check the current Apps Script quotas for the account you will use before estimating how many URLs a run can complete.
- CrUX API, if used separately: Chrome documents 150 queries per minute per Google Cloud project and about a two-day delay from current time. That figure applies to the CrUX API, not PSI’s
runPagespeedmethod. See the CrUX API documentation.
For any service that returns HTTP 429, back off rather than immediately repeating the same request. Save completed rows as the run proceeds, track which inputs remain unfinished, and retry only failed or unprocessed URLs. This limits lost work if a script reaches a runtime or service quota.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Make results comparable and maintainable
Record the test date, input URL, final URL when returned, strategy, requested categories, response status, and Lighthouse version when present. Lighthouse changes independently of the PSI API version, and response fields can change. Google’s release notes state that PSI and its API were updated to Lighthouse 13.0 on October 20, 2025, and warn that some updates can bring breaking response changes. See PageSpeed Insights release notes.
Rank #4
- Efficient Performance for Everyday Computing: Powered by Intel N150 processor with up to 3.6 GHz Intel Turbo Boost Technology, 6 MB L3 cache, 4 cores, and 4 threads, this HP laptop delivers responsive performance for web browsing, streaming, document editing, and multitasking. Paired with 4GB LPDDR5 RAM and 128GB UFS storage, it handles daily tasks smoothly. Includes 1-year Microsoft 365 Personal subscription for Word, Excel, PowerPoint, and cloud storage to maximize your productivity.
- 14-Inch HD Micro-Edge Display:Enjoy clear visuals on the 14-inch HD (1366 x 768) anti-glare screen with 250-nit brightness and 62.5% sRGB coverage. The micro-edge bezel delivers a 79% screen-to-body ratio in a compact design. An HP True Vision 720p HD camera with noise reduction and dual-array microphones supports clear video calls, remote work, and online learning.
- Modern Connectivity and Wireless Technology: Stay connected with Wi-Fi 6 (2x2) for faster wireless speeds and Bluetooth 5.4 for seamless pairing with accessories. Versatile port selection includes 1 USB Type-C 10Gbps with DisplayPort 1.2 for external displays, 2 USB Type-A 5Gbps ports for peripherals, 1 HDMI 1.4b port, 1 headphone/microphone combo jack, and 1 multi-format SD media card reader. Connect monitors, transfer files quickly, and expand your workspace with ease.
- All-Day Battery Life and Portable Design: Enjoy up to 11 hours of video playback, 7.5 hours of mixed usage, or 7.5 hours of wireless streaming on a single charge, perfect for students and professionals on the go. Weighing just 3.24 lb and measuring 12.76" x 8.86" x 0.71", this lightweight laptop fits easily in backpacks and bags. The stylish willow green top cover with matte finish and natural silver keyboard deck with vertical brushing pattern offer a modern, professional look.
- AI-Enhanced Productivity: Access Microsoft Copilot instantly with the dedicated Copilot key for faster assistance. AI Noise Reduction filters background sounds and improves voice clarity during calls. Dual speakers provide clear audio, while the full-size natural silver keyboard and HP Imagepad support comfortable typing and navigation.
For that reason, parse defensively: treat optional fields as optional, retain an error/status path, and do not make one rigid response shape your only success condition. Scores and field-data coverage are not guaranteed to be identical from run to run, so preserve settings and timestamps before comparing results.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errorsQuick Recap
Best Value
- 【Powerful Performance】Equipped with an Intel N150 CPU, featuring up to 4.4 GHz, ensuring efficient and powerful multitasking capabilities.
- 【Versatile Connectivity】Stay connected with multiple ports including USB 3.0 Type-C, USB 3.0 Type-A, and a headphone/mic combo jack, with Wi-Fi and Bluetooth for seamless wireless networking.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
