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.
Read the full tutorial
Step-by-step guide to integrating Allscreenshots with Google Sheets, including advanced options and best practices.
Read the blog postPricing that scales with you
No hidden fees. No surprises. Just screenshots.
100 free screenshots on sign-up · 50 bonus for each friend you invite
Pro
- 7,500 screenshots/mo
- 100/min rate limit
- $0.009 overage
- All features included
Business
- 30,000 screenshots/mo
- 200/min rate limit
- $0.0075 overage
- All features included
Enterprise
- 100,000 screenshots/mo
- 400/min rate limit
- $0.005 overage
- All features included