Overview

Manually tracking and archiving sublinks related to keywords across webpages is tedious and error-prone. This automation scrapes the parent page, identifies relevant sublinks using AI, fetches their content, saves all text files to Google Drive, and logs every step in Google Sheets for structured, searchable records.

The Impact

  • Automate sublink discovery. AI-driven extraction finds and follows relevant links without manual input.
  • Archive content systematically. Save both parent and subpage text files directly to Google Drive.
  • Maintain searchable logs. Record parameters and results in Google Sheets for easy review and auditing.
  • Iterate with precision. Loop through sublinks up to a defined depth, enabling deep chain scraping.

Who This Is For

  • Media Archivists Automate batch scraping and archiving of article-linked content.
  • Competitive Intelligence Analysts Track and save related industry pages for change analysis.
  • QA and Operations Teams Bulk verify website sublink validity and status codes.
  • Data Researchers Extract structured web data across linked pages efficiently.

How It Works

1
  1. Scrape Parent Page
  2. Fetch HTML content from the initial URL for analysis.
2
  1. Identify Relevant Sublinks
  2. Use an LLM to extract the first keyword-related sublink from the HTML.
3
  1. Scrape Sublink Content
  2. Fetch and save content from the identified subpage if valid.
4
  1. Store Files and Logs
  2. Save text files to Google Drive and append records to Google Sheets.
5
  1. Iterate and Update
  2. Repeat sublink search and scraping up to the specified depth, updating the current URL each cycle.

What You'll Need

Before using this template, make sure you have:

  • Google Sheets OAuth credentials for creating and updating sheets.
    Google Drive OAuth credentials for creating and saving text files.
    A Google Spreadsheet with an accessible Spreadsheet ID and a designated sheet/tab name.
    Target URL of the parent webpage to start scraping from.
    (Optional) Keywords to filter relevant sublinks.
    A positive integer defining the depth of sublink search iterations.

How to Use

  1. Step 1. Prepare Your Spreadsheet
  2. Create a Google Sheet with a header row for parameters and rows for sublink records.

  3. Step 2. Set Credentials
  4. Configure Google Sheets and Drive OAuth credentials in the workflow nodes.

  5. Step 3. Configure Parameters
  6. Input the parent URL, optional keywords, search depth, Spreadsheet ID, and sheet/tab name.

  7. Step 4. Run the Workflow
  8. Start the automation to scrape, analyze, save files, and log results iteratively.

  9. Step 5. Verify Results
  10. Check Google Drive for saved files and Google Sheets for structured scraping records.

FAQs

How does the workflow decide which sublink to scrape?
It uses an LLM to analyze the parent page HTML and extract the first sublink matching the associated keywords. If no keywords are provided, it returns unrelated sublinks.
What happens if no valid sublink is found?
The workflow skips subpage scraping for that iteration and continues until the specified search depth is reached or no further sublinks are found.
How are scraping results recorded?
Initial parameters and each sublink’s URL and HTTP status code are appended as rows in the specified Google Sheet for easy tracking and auditing.
Can this workflow handle multiple levels of sublinks?
Yes, it iterates sublink discovery and scraping up to the SearchDepth parameter, updating the URL each cycle to chain through sublinks.
Where are the scraped contents saved?
Text content from both the parent page and subpages is saved as files in Google Drive using OAuth credentials configured in the workflow.
Was This Page Helpful?

More Workflows for Inspiration

🔧
Scheduled Deletion of Database Records by Product Code
Automate deletion of product-specific database records to reduce manual cleanup and maintain data integrity.
Learn more >
🔍
Briefing Automator
Automatically scrape, summarize, and archive web articles while notifying your team instantly.
Learn more >
📊
Daily Portfolio Snapshot Reporter
Automate daily portfolio data fetch, valuation, and generate timestamped HTML reports instantly.
Learn more >