Screenshot URLs from Google Sheets
Batch capture websites from your spreadsheet and store results automatically
Turn any Google Sheets spreadsheet into a screenshot automation engine. List your URLs, run the script, and get screenshot links populated back into your sheet. Ideal for SEO audits, competitor tracking, and bulk website monitoring.
List URLs in column A
Add the URLs you want to capture to column A of your Google Sheet.
Open Apps Script
Go to Extensions > Apps Script and paste the capture script.
Run the script
Execute the script to batch-capture screenshots for all URLs.
View results
Screenshot URLs appear in column B. Set a time-based trigger for recurring captures.
1function captureScreenshots() {
2 const API_KEY = PropertiesService.getScriptProperties()
3 .getProperty('SCREENSHOT_API_KEY');
4 const sheet = SpreadsheetApp.getActiveSpreadsheet()
5 .getActiveSheet();
6 const urls = sheet.getRange('A2:A')
7 .getValues()
8 .flat()
9 .filter(Boolean);
10
11 urls.forEach((url, index) => {
12 const response = UrlFetchApp.fetch(
13 'https://api.allscreenshots.com/v1/screenshot',
14 {
15 method: 'post',
16 headers: {
17 'Authorization': 'Bearer ' + API_KEY,
18 'Content-Type': 'application/json',
19 },
20 payload: JSON.stringify({
21 url: url,
22 fullPage: true,
23 viewport: { width: 1280, height: 800 },
24 }),
25 }
26 );
27
28 const result = JSON.parse(response.getContentText());
29 sheet.getRange(index + 2, 2).setValue(result.screenshotUrl);
30 });
31}Familiar interface
Use Google Sheets as your screenshot dashboard. No new tools to learn.
Batch processing
Capture screenshots for hundreds of URLs in one script run.
Scheduled captures
Set time-based triggers in Apps Script to recapture screenshots hourly, daily, or weekly.