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!
Start using this automation
It's ready to go. Choose how to set it up in your account.
Open it in the Botize editor
Load it into your account and customize it in the visual panel, with everything in view.
Open it in Claude or ChatGPT
Copy this and paste it into ChatGPT or Claude (with the free Botize connector): it'll load the automation, tailor it with you and save it to your account.
Not connected yet? Claude guide · ChatGPT guide
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.
Related automations
Other ready-to-use automations you may find useful.
Apps in this automation
These are the apps this automation connects. Open any of them to discover everything you can automate with it.
Actions used
These are the exact steps this automation runs. Each action can be reused in other automations.