To automate website screenshot reports in Google Sheets, list one page URL per row, use Google Apps Script to request a screenshot from Microlink, write the returned screenshot URL and status into the sheet, and schedule the script with an installable time-driven trigger. You can keep each result as a link or insert the public image into the sheet.
The example below is a documentation-based starting point, not a tested script. Confirm Microlink’s current request options and service limits before using it for a production report.
How the workflow fits together
Google Sheets holds the target URLs and report fields. Apps Script reads those rows, sends each URL to Microlink’s API, parses the response, and writes the screenshot asset URL back to the matching row. A time-driven trigger can run the refresh function on a recurring schedule.
For a simple report, use columns like these:
| Column | Purpose |
|---|---|
| Page URL | The website page to capture; use one URL per row. |
| Captured at | When the script attempted the capture. |
| Screenshot URL | The screenshot asset URL returned by Microlink. |
| Status | Whether the request succeeded or failed. |
| Notes | Optional diagnostic details, such as an HTTP error. |
Microlink documents a screenshot URL in data.screenshot.url. Its screenshot guide covers viewport captures, full-page captures, element targeting, and image types: Microlink’s screenshot guide.
#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
Set up the sheet and Apps Script
-
Create a Google Sheet with the headers shown above in row 1. Put each page URL in column A, starting in row 2.
-
Open Extensions > Apps Script in the spreadsheet.
-
Paste the function below into the editor. Replace the example API endpoint or parameters only if Microlink’s current documentation requires a different request format for your account or chosen capture options.
-
Save the project, select
refreshScreenshots, and run it once from the editor. Google will prompt you to authorize the script. Apps Script’s URL Fetch service can make HTTP and HTTPS requests; the script may require external-request authorization, as well as permission to edit the spreadsheet. -
Check the sheet for a timestamp, screenshot URL, and status on each URL row. Then create a time-driven trigger as described below.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Apps Script example
function refreshScreenshots() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const lastRow = sheet.getLastRow();
if (lastRow < 2) return;
const rows = sheet.getRange(2, 1, lastRow - 1, 5).getValues();
const now = new Date();
rows.forEach((row, index) => {
const pageUrl = String(row[0] || '').trim();
const sheetRow = index + 2;
if (!pageUrl) return;
try {
const endpoint = 'https://api.microlink.io/';
const query = {
url: pageUrl,
screenshot: true
};
const queryString = Object.keys(query)
.map(key => encodeURIComponent(key) + '=' + encodeURIComponent(query[key]))
.join('&');
const response = UrlFetchApp.fetch(endpoint + '?' + queryString, {
muteHttpExceptions: true
});
const statusCode = response.getResponseCode();
const body = response.getContentText();
if (statusCode < 200 || statusCode >= 300) {
sheet.getRange(sheetRow, 2, 1, 4).setValues([[now, '', 'HTTP error ' + statusCode, body.slice(0, 500)]]);
return;
}
const result = JSON.parse(body);
const screenshotUrl = result && result.data && result.data.screenshot
? result.data.screenshot.url
: '';
if (!screenshotUrl) {
sheet.getRange(sheetRow, 2, 1, 4).setValues([[now, '', 'No screenshot URL', body.slice(0, 500)]]);
return;
}
sheet.getRange(sheetRow, 2, 1, 4).setValues([[now, screenshotUrl, 'OK', '']]);
} catch (error) {
sheet.getRange(sheetRow, 2, 1, 4).setValues([[now, '', 'Script error', String(error).slice(0, 500)]]);
}
});
}This example makes one request per non-empty URL on every run. If the API returns a different response shape or requires different screenshot parameter syntax, adjust the request and parsing to match Microlink’s current API documentation. For larger sheets, consider processing a bounded number of rows per run so that requests and spreadsheet writes fit within the service quotas.
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.
- 14" HD Display: 14.0-inch diagonal, HD (1366 x 768), micro-edge, anti-glare. See your digital world in a whole new way. Enjoy movies and photos with the great image quality and high-definition detail of 1 million pixels.
- Memory & Storage: 4 GB LPDDR4x & 64 GB eMMC Storage. Adequate high-bandwidth RAM to smoothly run multiple applications and browser tabs all at once. An embedded multimedia card provides reliable flash-based storage.
- Ports:2 x USB 3.0 Type-A，1 x USB 3.0 Type-C，1 x HDMI，1 x Headphone Jack
- Chrome OS: Chromebook is a computer for the way the modern world works, with thousands of apps. Enjoy the seamless simplicity that comes with Google Chrome and Android apps, all integrated into one laptop. It’s fast, simple, and secure.
Choose what the screenshot captures
Viewport, full page, or a specific element
A default capture is appropriate when the report should show what appears in the browser viewport. Use full-page capture when the whole document matters, or element targeting when the report is focused on a known component. Microlink’s screenshot guide describes these capture choices and image-type options; the exact request parameters should follow its current documentation.
Wait for dynamic content when needed
Pages that render after JavaScript runs may need a readiness condition before capture. Microlink’s dynamic-content screenshot guide describes waiting for a selector and using click or scroll interactions. Prefer a condition tied to the page’s real content over an arbitrary fixed delay, which can be too short on a slow load and unnecessarily long on a fast one. The guide reviewed for this article reports request timeouts of 30 seconds on the free plan and 60 seconds on Pro; verify current limits before depending on long waits.
Microlink also documents browser interactions in its Browser Automation feature information. A capture that depends on login state, consent handling, or page interaction needs deliberate configuration; do not assume a basic screenshot request reproduces every user’s browser session.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallStore the screenshot URL or display the image
The simplest report stores the returned URL in the Screenshot URL column. This keeps the sheet compact and lets readers open the asset separately.
To display the screenshot in a cell, use Google Sheets’ image formula with the URL, for example =IMAGE(C2) if the screenshot URL is in column C. For an Apps Script-managed image, Google’s Spreadsheet class includes insertImage(url, column, row), which requires a publicly accessible image URL. The blob-based insertion method has a 2 MB maximum. Inserting a new image on every refresh can clutter the sheet, so a URL column or a carefully managed image area is often easier to maintain.
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.
Schedule recurring captures
Use an installable time-driven trigger to run refreshScreenshots on a recurring basis. In Apps Script, open Triggers (the clock icon), choose Add Trigger, select the function, choose Time-driven as the event source, then select the interval and schedule. Google’s installable triggers guide says these triggers can run as often as every minute or as infrequently as monthly.
Two scheduling details matter for reports:
-
The trigger runs using the authorization of the account that created it. Keep that account active and authorized, and document who owns the automation so it can be maintained if that person’s access changes.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
A selected hourly schedule does not guarantee an exact minute: Google says trigger time can be randomized within the chosen hour. Design the report around an acceptable window rather than treating the trigger as a precise scheduler.
Plan around Microlink and Apps Script limits
Capacity depends on both the screenshot service plan and Google Apps Script quotas. Microlink’s API page, reviewed on October 3, 2026, lists 25 requests per day on its free tier and a Pro configuration with 46,000 requests per month at $49 per month. The same page reports a 99.9% uptime SLA for paid plans; that figure does not apply to the free tier. Terms can change, so check Microlink’s current API page before committing to a volume or schedule.
Google for Developers’ Apps Script quotas page, reviewed in 2026, lists these daily limits:
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.
| Quota | Consumer account | Google Workspace account |
|---|---|---|
| URL Fetch calls per day | 20,000 | 100,000 |
| Trigger runtime per day | 90 minutes | 6 hours |
Google says quotas vary by account type and may change. These are Google’s listed limits, not a promise that every script can use the full allowance for screenshot work: other scripts or services in the account can consume capacity. Estimate daily calls as the number of non-empty URLs multiplied by runs per day, and leave room for retries and other automation.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesTroubleshoot failed or incomplete reports
-
Authorization prompt or authorization error: Run the function manually from the editor and approve the requested permissions. Confirm the creator account can edit the spreadsheet and make external requests through Apps Script.
-
HTTP error in the status column: Check the returned status and response text. Verify the page URL and Microlink request options, then compare the request with the current API documentation. The example records a short response excerpt to help identify the failure.
-
Missing screenshot URL: The request may have succeeded at the HTTP layer but returned an unexpected JSON shape or no screenshot data. Inspect the response and update the parser to match the current API response.
-
Screenshot is blank or misses content: The target page may render content asynchronously. Add an appropriate selector wait or documented interaction, and allow enough request time for the page’s behavior. A fixed delay is not a guarantee that the page is ready.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.Best Value
Sale
HP 14‘’ Laptop, 2027 Edition, Intel N150 CPU, 4GB RAM, 128GB SSD, Copilot AI, 1TB Cloud Storage, Win 11 with Microsoft 365- Designed for mobility with a slim 0.71-inch profile and lightweight, making it easy to carry between home, office
- 【Versatile Connectivity】Stay connected with multiple ports including USB 3.0 Type-C, USB 3.0 Type-A, HDMI, and a headphone/mic combo jack, with Wi-Fi and Bluetooth for seamless wireless networking.
-
Images fail to display in the sheet: Check that the screenshot asset URL is publicly accessible. The Apps Script URL insertion method requires a public URL; otherwise, retain the link or use another supported display method.
-
Trigger stops updating: Check the trigger’s execution history, the account that owns it, authorization status, and remaining Apps Script quotas. A trigger depends on its creator’s account access.
-
Quota or request-timeout failures: Reduce the number of pages per run or the frequency, process rows in batches, and review both Microlink plan capacity and Google quotas before increasing volume.
Or skip the browser setup
If you would rather make a screenshot request without assembling the Microlink-and-Sheets capture flow, ScreenshotNeo is a website screenshot API and MCP server. One GET request can return a PNG, JPEG, WebP, or PDF. For a report, call the endpoint from your script and write the response or returned asset reference into the sheet; see the ScreenshotNeo API documentation for request options.
Recommended Free Tools
curl -G "https://api.screenshotneo.com/v1/shot" -d access_key=YOUR_API_KEY --data-urlencode url=https://stripe.com -o shot.webpScreenshotNeo can accept cookie or consent banners and remove more than 60 known consent platforms, newsletter popups, and chat widgets before capture; each of those steps can be turned off. Bot checks and CAPTCHAs, blank pages, timeouts, failed loads, and cache hits are not billed, and responses identify the page verdict and billing status in headers. Its MCP server provides take_screenshot, get_page_info, and capture_pdf tools for AI agents. The free plan includes 1,000 screenshots per month with no card; paid plans start at $5 for 3,000 screenshots. Sign up for ScreenshotNeo free.
Frequently asked questions
Can a spreadsheet update only when someone changes a URL?
This example refreshes rows when its function runs. A recurring trigger is one way to run it automatically; choose an event-driven design only if it fits the update behavior you need and the relevant Apps Script trigger limitations.
Does the trigger run at an exact scheduled minute?
No. Google says an hourly time-driven trigger may run at a randomized time within that hour, so treat it as a recurring window rather than a precise appointment.
Quick Recap
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.
Free tools Windows power users keep installed
One-click scans. No signup required.
