How to Find All URLs on a Website and Save to Google Sheets

Whether you’re conducting SEO analysis, building site maps, or performing competitive research, extracting all URLs from a website is a common task that can be time-consuming when done manually. With Add to Sheets, you have two options for doing this efficiently: pattern matching for quick URL extraction and automations for more flexible workflows with additional data and extraction functionality.

Method 1: Quick URL Extraction with Pattern Match

The Pattern match functionality in Add to Sheets provides the fastest way to extract all URLs from a webpage. This method is perfect when you need to quickly gather links without additional processing. Using this approach, you can find all the URLs on a website page and then copy the results to clipboard or save directly to a Google Sheets column. You can edit the matches too, if needed, before you save. Also, there is no limit on how many URLs that you can find and save. Since you are using Google Sheets for storage there is no limit on number of rows, etc. that the extension imposes. This feature is available in the upgraded Pro version of the extension.

How to Use Quick URL Extraction

1. First, install and configure the extension by allowing access to your spreadsheet and configuring a column to save to.
2. Next, navigate to any webpage containing links you want to extract.
3. Open the extension and access the Find matches modal, then select Find a pattern > Links.
4. Click to extract all hyperlinked URLs from the page, and finally save directly to Google Sheets by selecting the column you configured earlier or copy to clipboard.

Watch the video to see how to find all URLs:

This will automatically find and extract all hyperlinked URLs on the page, relative URLs (converted to absolute URLs), links from mailto: attributes, image source URLs, and any other linked content.

This is helpful for:

• Quick link audits - Get all links from a page in seconds
• SEO analysis - Extract internal and external links for analysis
• Content research - Find all linked resources on competitor sites
• Site mapping - Build comprehensive link inventories

If you have tabs open before installing the extension, you’ll need to refresh those tabs to use the extension on those pages. Add to Sheets will show a notification if you need to refresh the page to use the extension. Click on the Refresh button in the notification to reload the page.

Method 2: Automations Template - Find URLs and Complete Rows of Data

For more flexible workflows that include metadata like source page URLs and extraction dates, the automations template provides a visual workflow builder for custom data collection.

The URL Extraction Automation Template

This template creates a complete workflow that extracts URLs along with metadata:

Output Columns:

Column	Description
URL	The extracted link
Page URL	The source webpage where the link was found
Extraction Date	When the data was collected

How the Automation Works

The template uses a visual workflow with connected blocks:

1. Page Content Block - Extracts HTML content from the current webpage
2. Find URLs Block - Identifies and extracts all URLs and links from the page content
3. Page URL Block - Adds the current page URL to each extracted link row using a custom variable {{page_url}}.
4. Date Block - Adds the current date to each URL row using the =TODAY() Google sheets function
5. Save to Sheets Block - Saves all data to your Google Sheets with proper column mapping

Setting Up the Automation Template

1. Import the template into your workflow editor
2. Select an existing Google Sheet or create a new one
3. Update the ‘Save to Sheets’ node to map the columns to your desired spreadsheet columns
4. Save your configured automation
5. Navigate to any webpage containing links
6. Run the automation from the browser extension
7. Each URL will be saved as a new row with the source page URL and current date.

Running Your Automation

Once configured, you can run your automation in multiple ways:

• Keyboard Shortcut - Set up a custom shortcut for instant execution (learn more about keyboard shortcuts)
• Side Panel - Access from the extension’s side panel

• Right-Click Menu - Available when selecting text on webpages

Example Output

When you run the automation on a webpage like https://example.com/blog, you’ll get results like:

URL	Page URL	Extraction Date
https://example.com/about	https://example.com/blog	2024-12-19
https://example.com/contact	https://example.com/blog	2024-12-19
https://external-site.com/resource	https://example.com/blog	2024-12-19

When to Use Each Method

Use Quick Extraction When:

• You need quick, one-time extraction
• You’re doing simple link audits
• You don’t need source tracking or timestamps
• You want the fastest possible extraction

Use Automations Template When:

• You need source page tracking for analysis
• You want extraction timestamps for historical data
• You’re building comprehensive site maps
• You need repeatable, consistent workflows
• You’re doing bulk data collection across multiple pages

Advanced Use Cases

SEO Analysis

Use the automation template to track which pages contain specific links, helping you understand your site’s internal linking structure and identify pages that need more internal links.

Competitive Research

Extract all links from competitor websites while tracking the source pages. This helps you understand their content strategy and identify opportunities.

Site Migration Planning

When moving websites, use the automation to create comprehensive inventories of all links that need to be updated or redirected.

Link Building Campaigns

Track which pages you’ve analyzed and when, making it easier to manage large-scale link building efforts across multiple websites.

Tips for Better Results

For Quick Extraction:

• Refresh pages after installing the extension to ensure proper functionality
• Review extracted data before saving to remove any unwanted URLs
• Use filters in Google Sheets to organize different types of links (learn about sorting and filtering data)

For Automations:

• Test on different page types to ensure your automation works across various website structures
• Set up keyboard shortcuts for frequently used automations (see our keyboard shortcuts guide)
• Use descriptive names for your automations to easily identify them later
• Regularly review results to ensure accuracy and make adjustments as needed

Exporting and Further Processing

Once you have your URL data in Google Sheets, you can:

• Export to CSV, Excel, or PDF for sharing or further analysis
• Create charts and visualizations to understand link patterns (explore data management techniques)
• Use Google Sheets functions like COUNTIF to analyze link types (learn more about Google Sheets functions)
• Integrate with other tools using Google Sheets’ built-in connectors
• Set up automated reports using Google Sheets’ scheduling features

What’s Next?

To get started, install Add to Sheets from the Chrome Web Store and try both methods to see which works best for your use case.

Have questions about URL extraction or need help setting up automations? Reach out to us at [email protected] or connect with us on Twitter/X.