Add to Sheets

Add to Sheets

Find All Email Addresses, Links, and Images on Websites in Seconds

With Add to Sheets Pro, you can easily find email addresses, links, and image URLs on websites in seconds and save them directly to Google Sheets with one click. There is not a limit on the number of times that you can use the extension to extract data or the number of rows that you can save.

If you save to Google Sheets, you can continue to manage the data there, or export it to other formats like CSV, TSV, Microsoft Excel (.xlsx), PDF, etc. Also, you can add, edit, or remove data before saving it to GSheets or copying it to your clipboard. This is meant to make you more productive and save you time.

Watch the video to see how it works:

You can use this feature to create a database of the data you find on websites and create automation workflows with VLOOKUPs and other integrations for cleaning, analyzing, and visualizing the data. It’s also possible save to multiple Google Drive spreadsheets at once using groups. This makes it fast to save content to multiple sheets or columns at the same time.

Currently, the extension supports finding email address ids, links, and image URLs. We’ll take a look at each of these in more detail below.

👋 After installing the extension, you’ll need to refresh any already open tabs to use the extension on those pages. This is because the extension needs to load on the page to be able to extract data from it.

Find and copy email addresses

You can use the extension to find email addresses on a webpage in the format of:

alias@domain

The extension does its best to find all email addresses (with domain variations) without extracting other text that looks like an email address. If you find that the extension is extracting text that isn’t an email address, you can remove it from the textarea before saving it to Google Sheets.

Also, the extension will check any links on the page that start with mailto: and extract the email address from those links as well. This is helpful if the email address is hidden behind a link on the page.

This is helpful in scenarios like:

If you’re looking to find all links on a webpage, you can use the extension to extract all links on the page and save them to Google Sheets.

extract all website links

Example from www.addtosheets.com

The extension will find all hyperlinked links on the page. If a URL link is relative, the extension will resolve it to be an absolute URL. For example, if the link is /about, the extension will resolve it to be https://example.com/about if the current page is https://example.com when it can determine the base URL of the page.

This is helpful in scenarios like:

Find and copy all images

Add to Sheets can find all images on a webpage and extract the URLs of those images. This is helpful in scenarios like:

The extension will extract the URLs of all images on the page, including images that are loaded dynamically or lazy-loaded. This means you can find all images on a page, even if they aren’t visible when the page first loads as long as they are in the HTML of the page.

Since these are URLs, they will be saved as plain text in Google Sheets. You can add another column to the sheet and use the IMAGE function in Google Sheets to display the images in the sheet.

Save all matches to Google Spreadsheets

If you have a column or group configured, you can save all of data in the textarea to those locations. If you haven’t configured a column or group, you’ll need to create one first before using the form to save. Data isn’t always perfect, so this gives you the flexibility to make changes before saving it to your spreadsheets 😄.

In the automation matching, all of the duplicate values are removed based on case sensitivity. For example, upper case and lowercase values are not considered the same.

Exporting from Google Sheets to any format

Once you have the data in Google Sheets, you can export it to any format that Google Sheets supports. This includes downloading the data as a CSV, TSV, Excel (xlsx), PDF, etc. You can also use Google Sheets to create charts, graphs, and other visualizations of the data. If you want to sync the data to another service, you can use Google Sheets’ built-in integrations or use a service like Zapier to automate the process.

Reloading pages when needed

If you have tabs open before installing the extension, you’ll need to refresh those tabs to use the extension on those pages. This is because the extension needs to load on the page to be able to extract data from it. 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.

refresh page notification

Pages not accessible by extensions

Certain pages are automatically not accessible by extensions. The following types of URLs are known to be protected:

URLs that start with the following prefixes are also protected:

What’s next?

This is meant to be a flexible tool to efficiently extract and save (or copy) data fast from websites to Google Sheets. If you have any questions or feedback, feel free to contact us or reach out on Twitter/X.

To get started, you’ll need to install the extension from the Chrome Web Store. You can find the extension by visiting the Add to Sheets Chrome Web Store page.

#featured #pro #how-to #productivity #image-finder #email-finder #link-finder #extract-emails #extract-links #extract-images


Subscribe to our newsletter for updates

We don't spam.