Gets the HTML of each URL listed in a Google Sheets spreadsheet, extracts the article HTML and URLs, and adds them back to the Google Sheets document
Transform scattered URLs into organized, valuable data without lifting a finger—or losing your sanity.
Manually gathering content and URLs from dozens—or hundreds—of web pages is an exhausting and error-prone process. Each URL has to be opened, the article content identified and copied, and every link collected, all to be pasted row by row into Google Sheets. If you skip automation, you’re sacrificing hours of productivity, risking mistakes, and your data pipeline slows to a crawl—impacting time-sensitive research, reporting, and SEO ops.
This formula lets Botize handle the heavy lifting: it checks each new entry in your Google Sheets, fetches the HTML from every listed URL, extracts the main article text and every link on the page, then updates your spreadsheet with all the info—structured and accessible. Set it to run as often as you like (every hour, daily, or triggered on new entries), and you’ll never lose momentum or accuracy. Now your content workflow is consistent, automated, and ready for deep analysis, reporting, or content republishing, no matter the scale.
Ready to automate your content extraction and supercharge your spreadsheet workflow? Just follow the step-by-step below to implement this formula—or save time by activating the prebuilt Botize automation in a few clicks. Your hours are too valuable to spend copying and pasting—let’s get you set up!
Automate this task with 6 simple prompts
Copy and paste the following prompts into Botize's AI task editor
-
1
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
3
Set up the automation to run automatically every hour, so the process happens regularly.
Copy and paste this prompt into the AI editing tool.
Schedule this automation to run once every hour. ⤵
Click the 'Apply this task' button to confirm.
-
4
Pull in the next new row from the Google Sheets spreadsheet, so we can work with fresh data each time.
Copy and paste this prompt into the AI editing tool.
Retrieve the next unpublished row from the Google Sheets document, assuming each row contains a URL in column A. ⤵
Click the 'Apply this task' button to confirm.
-
5
Fetch the HTML content of the web page for the current URL from the spreadsheet.
Copy and paste this prompt into the AI editing tool.
Take the URL from column A in the row we just got, and fetch the HTML content of that web page. ⤵
Click the 'Apply this task' button to confirm.
-
6
Extract all the URLs found in the HTML of the page, so we can collect them for reference.
Copy and paste this prompt into the AI editing tool.
Find and extract all URLs that are present in the HTML we just fetched from the web page. ⤵
Click the 'Apply this task' button to confirm.
-
7
Extract the main article text from the HTML, cleaning it up to get just the readable content.
Copy and paste this prompt into the AI editing tool.
Take the HTML content of the web page and extract only the main article text, removing all unnecessary tags and clutter. ⤵
Click the 'Apply this task' button to confirm.
-
8
Update the Google Sheets row with the extracted article text and the list of URLs found on the page.
Copy and paste this prompt into the AI editing tool.
Write the cleaned article text and the list of found URLs back to columns B and C of the same spreadsheet row, respectively. ⤵
Click the 'Apply this task' button to confirm.
-
9
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Effortless Web Content Grabber for Google Sheets
Paste a bunch of page URLs into column A of Google Sheets. Hit start. This automation fetches and drops the page’s main article AND every link it finds directly into your sheet. No tech headaches, no repetitive grunt work. Yes, it really is that easy.
| Manual | Botize | |
|---|---|---|
| Manually copy article text from each URL | 5 minutes per page | 0 Minutes |
| Find and paste all URLs from each page | 3 minutes per page | 0 Minutes |
| Format everything in Google Sheets | 2 minutes per page | 0 Minutes |
| Total | 10 minutes per URL (multiply by your list!) | 0 Minutes |
Looking to pull article text and all the links from a big list of URLs right back into your Google Sheets? Good news: you’ve found exactly what you need (and probably a little more).
Curate Industry News
Drop dozens of news URLs into your sheet, get their main articles and all related links neatly extracted—perfect for newsletters or content discovery.
Save Hours
No more copy-pasting or jumping between tabs. Just results.
Error-Free Data
Forget about missing links or botching the copy. Every detail lands where it should.
Scale Instantly
Process hundreds or thousands of pages without breaking a sweat—or a formula.
Link Audits for Marketers
Paste a list of competitor pages and instantly see every reference or outbound URL on their articles. No manual checks, no wasted afternoons.
⌾︎ You’ve got lists of URLs and need clean data, not chaos.
⌾︎ You want web research, content curation, or trend hunting in turbo mode.
âś• You never need data from websites.
âś• You actually enjoy endless, repetitive copying and pasting.
✓ Adapt which columns in your sheet store results—total flexibility for your workflow.
âś“ Choose how often the automation runs: one-time blast or regular intervals.
âś“ Fine-tune what article content is extracted, or focus on specific types of links.
This automation scans each URL listed in a Google Sheets file you provide, assuming each row contains a page URL in column A. For every URL, it fetches the page HTML and extracts the main article content from it. It also extracts all URLs found on that page. Finally, it updates the same Google Sheet row with the extracted article text and the URLs it found.
