+
Website Screenshots in Google Sheets
Capture website screenshots directly in your spreadsheets. Use simple formulas to turn URLs into images - perfect for SEO tracking, competitor monitoring, and portfolio management.
Works with any Google Sheets plan. Start with 100 free screenshots/month.
How to Use Screenshots in Google Sheets
Two simple approaches - use what works best for you
Method 1: Direct IMAGE Formula
The simplest approach - use Google Sheets' built-in IMAGE() function with the GetScreenshot API URL. The screenshot loads directly in your cell.
Formula:
=IMAGE("https://api.getscreenshotapi.com/capture?apikey=YOUR_KEY&url="&ENCODEURL(A1))
Example with Options:
=IMAGE("https://api.getscreenshotapi.com/capture?apikey=YOUR_KEY&url="&ENCODEURL(A1)&"&width=1280&height=800&full_page=true")
Available Parameters:
width- Viewport width (default: 1280)height- Viewport height (default: 800)full_page- Capture entire page (true/false)format- Image format (png, jpg, webp)delay- Wait time in ms before capture
Method 2: Google Apps Script (Advanced)
For more control, create a custom function using Google Apps Script. This allows batch processing, error handling, and storing screenshot URLs.
function SCREENSHOT(url, width, height) {
var apiKey = 'YOUR_API_KEY';
width = width || 1280;
height = height || 800;
var apiUrl = 'https://api.getscreenshotapi.com/capture'
+ '?apikey=' + apiKey
+ '&url=' + encodeURIComponent(url)
+ '&width=' + width
+ '&height=' + height;
return apiUrl;
}Then use in your sheet:
=IMAGE(SCREENSHOT(A1, 1280, 800))
Popular Google Sheets Use Cases
How teams use screenshots in their spreadsheets
SERP Result Tracking
Screenshot search results for target keywords. Track SERP changes over time with visual evidence in your SEO tracking sheets.
Competitor Website Monitoring
Keep a visual log of competitor websites. List URLs in column A, get screenshots automatically. Compare changes side by side.
Client Website Portfolio
Agencies: maintain a visual database of client websites. Track projects with live thumbnails that update automatically.
Website QA Checklist
Create QA spreadsheets with visual verification. Screenshot each page after deployment to confirm changes look correct.
Property Listing Database
Screenshot property listings from real estate portals. Build a visual database of listings with thumbnails for quick reference.
Backlink Verification
Track backlinks with visual proof. Screenshot pages linking to you to verify link placement and context.
Tips for Best Results
Get the most out of screenshots in your spreadsheets
Resize Cells for Better Display
Adjust your row height and column width to display screenshots clearly. Right-click the row/column header and set specific dimensions (e.g., 200px height, 300px width).
Use ENCODEURL() for Special Characters
Always wrap your URLs with ENCODEURL() to handle special characters, query strings, and unicode properly. This prevents formula errors.
Cache Screenshots with Static URLs
For large sheets, consider using our webhook feature to capture screenshots once and store permanent URLs, rather than regenerating on each sheet load.
Use Full Page for Long Content
For articles, landing pages, or content-heavy sites, add full_page=true to capture the entire page, not just the viewport.
All Features Work in Google Sheets
Access the full GetScreenshot API from your formulas
More Integration Options
Connect GetScreenshot with your favorite tools
Start Taking Screenshots in Google Sheets
Get 100 free screenshots per month. No credit card required to start.