Screenshot a list of websites from a Google Sheet
How to screenshot a list of websites from a Google Sheet: install the Chrome extension, click Build from description, tell the agent what you want, and follow its prompts. A working bot is built and tested in minutes.
Here is how the automation works. To screenshot a list of websites, read the links from a Google Sheet with Read data from a Google Sheet, open each one inside Loop through data, and save the page with Save screenshot locally. A Date and time step gives today's date, and Find row in a Google Sheet with Write data to a Google Sheet writes it into column B of the link's own row, so the sheet shows when each site was last captured. Because the screenshots go to your computer, the automation runs in the desktop app. To save them to Google Drive and run in the cloud, see screenshot a list of websites to Google Drive.
Build the website screenshots from a description
Describe it and click the button: the agent builds and tests the screenshot automation in your Chrome extension. The screenshots go to a folder on your computer.
- Open each website link in column A of my sheet
- Save a screenshot of the page to my computer
- Write today's date in column B of the same row
You need a Google Sheet with one website link per row in column A and column B empty, and a folder on your computer for the screenshots. Leave the sheet alone while the run writes the dates into column B.
The video shows the agent building the website screenshot automation from the lines above, in a few minutes.
Build the website screenshots step by step
The steps the agent builds, as the Builder shows them: each step by its name, with the fields to set under it. Add them yourself in this order in the step-by-step builder, or open the agent's result there to adjust it.
- 1.0
Read data from a Google SheetSpreadsheet: your sheetSheet name: Website links, the tab with one link per row in column A
- 2.0
Loop through data- repeats for every row in
[google-sheet-data]
- 2.1
Go to pageURL: column A of[google-sheet-data]
- 2.2
Save screenshot locallyFolder: the folder to save toFile type: JPEG or PNG
- 2.3
Date and timeSelect date: CurrentSelect format: a date format, such as YYYY-MM-DD
- 2.4
Find row in a Google SheetSpreadsheet: your sheetSheet name: Website linksValues (comma separated): column A of[google-sheet-data]Exact match: on
- 2.5
Write data to a Google SheetSpreadsheet: your sheetSheet name: Website linksDATA:[date-and-time]Write options: Add to existing dataStarting cell:B[find-row-google-sheet], the found row from column B
- repeats for every row in
Common questions about screenshotting a list of websites
How do I screenshot only a set number of websites?
Set Last cell on Read data from a Google Sheet. For example, A100 reads the first 100 rows, so the run takes 100 screenshots.
Why are the screenshots not saving?
Check the folder permissions on your computer for the folder set in Save screenshot locally. When a run fails, hand it to the agent and it repairs the step.
Can I save the screenshots to Google Drive?
Yes, and that version runs in the cloud, so it can be scheduled. See screenshot a list of websites to Google Drive.
Can I screenshot one part of each website rather than the whole page?
Yes. Use Selected element on Save screenshot locally to pick an element, and the screenshot covers that area of the page.
Why does the date land in the wrong row?
Two links are too alike for a partial match. In Find row in a Google Sheet, turn on Exact match.
Can I restart the run where it stopped?
Yes. Column B shows which links have a date, so the ones still empty are left to do. Move the finished rows out of the way, or set First cell on Read data from a Google Sheet to the first row without a date, and run again.
Can I scrape the websites as well as screenshot them?
Yes. Add Get data from bot's current page inside the loop, after the screenshot, and write it beside the date by changing the letter in Starting cell. See scrape data from a list of pages.
Can I screenshot a list of websites without code?
Yes. Every step is a no-code step the agent builds from the lines above; you supply the sheet of links and the folder.
Can I screenshot the same websites every day?
Yes. A run that saves to your computer needs the desktop app open, so for a daily run save the screenshots to Google Drive instead and set a schedule: see screenshot a list of websites to Google Drive.
Where do I get help?
Get in touch with support, or ask in the axiom.ai community.
Related guides
Screenshot a list of websites to Google Drive
- Open each website link in column A of my sheet
- Save a screenshot of the page to my Drive folder
- Write today's date in column B of the same row
Scrape data from a list of URLs in a Google Sheet
- Open each link in column A of my Google Sheet
- Ask me which data to scrape from each page
- Put the details in that URL's row from column B
Count eBay search results for every keyword in a Google Sheet
- Open each eBay search URL in column A of my sheet
- Scrape the total number of search results
- Write the total in column B of the same row
Export a web page as a PDF automatically
- Go to the page I give you
- Save the whole page as an A4 PDF
- Wait for the download to finish