Download full-page PDF screenshots of websites from links in a Google Sheet

Steps:

Bardeen connects Google Sheets to your browser to automate the process of generating full-page PDF screenshots of websites. The automation extracts a list of website links from a Google Sheets spreadsheet, visits each website, and downloads a full-page PDF screenshot. This could be particularly useful for market research, competitor analysis, or archiving websites.

Here is how this workflow works:

1. Get table from Google Sheet - Bardeen retrieves the content of a specified Google Sheets spreadsheet and transforms it into a table. You will need to specify the Google Sheet to use.
2. Extract column data - From the table obtained from the Google Sheet, Bardeen extracts a specified column that contains the website links. You will need to specify the column name.
3. Find all links - This step processes the extracted column data and identifies all the website links.
4. Get page as PDF - Bardeen then visits each website link and captures a full-page PDF screenshot.
5. Download object as file - Finally, the PDF screenshot is downloaded for your use.

The new Bardeen – Find leads no one else does:

With our new Bardeen version, you can easily extract data from any website and discover new leads across the web. After extracting data from a website, use Bardeen’s powerful automation tools to validate and enrich your data, run additional scrapers on linked pages, or leverage AI to qualify leads and generate content automatically. Once your data is ready, you can easily export it to CSV, Google Sheets, Airtable, or Notion for further analysis and reporting.