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.

Author
Alex Barlow
Published

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.

  1. Open each website link in column A of my sheet
  2. Save a screenshot of the page to my computer
  3. Write today's date in column B of the same row
Click to launch the Chrome extension. Not installed? You can create an account and try it free.Opens the Chrome extension. Free account to try.

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 Sheet
    • Spreadsheet: your sheet
    • Sheet 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 page
      • URL: column A of [google-sheet-data]
    • 2.2 Save screenshot locally
      • Folder: the folder to save to
      • File type: JPEG or PNG
    • 2.3 Date and time
      • Select date: Current
      • Select format: a date format, such as YYYY-MM-DD
    • 2.4 Find row in a Google Sheet
      • Spreadsheet: your sheet
      • Sheet name: Website links
      • Values (comma separated): column A of [google-sheet-data]
      • Exact match: on
    • 2.5 Write data to a Google Sheet
      • Spreadsheet: your sheet
      • Sheet name: Website links
      • DATA: [date-and-time]
      • Write options: Add to existing data
      • Starting cell: B[find-row-google-sheet], the found row from column B

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