Automatic Screenshot in Google Sheets

Automate Website Screenshots in Google Sheets with ScreenshotOne API + Save to Google Drive The script shows how to automate taking website screenshots from Google Sheets using the ScreenshotOne API and Google Apps Script. It builds a getScreenshot(targetUrl) function that URL-encodes the target URL, constructs the ScreenshotOne /take API request with an access key, JPEG format, caching options (including a ~30-day cache TTL), and JSON response, then parses the returned cache_url for the image. It demonstrates common issues like needing a full https:// URL and why some Google Search URLs fail due to human verification, while other pages (including Google Sheets URLs) work. Next, it creates a saveScreenshotToDrive function that fetches the image blob from cache_url, names the file with an ISO timestamp, finds or creates a Drive folder by name, saves the file, and appends the saved file URL and timestamp to a “Saved” sheet. Finally, it sets up time-driven triggers to run weekly/monthly and shows scaling to multiple URLs with separate functions or a parameterized saveUrlToDrive(url, folderName) approach. 00:00 Why Auto Screenshots 01:45 Setup Apps Script Basics 03:22 Build Screenshot API URL 07:25 Parse JSON Cache URL 09:21 Test and Fix URLs 11:16 Save Screenshot to Drive 14:04 Create Folder and Log URLs 18:25 Automate with Triggers 19:53 Scale to Multiple URLs 20:59 Cleaner Reusable Function 24:22 Wrap Up and Next Steps