Turn a list of web pages into spreadsheet rows
Reads every page you list, pulls out the details you asked for with AI, and adds one row per page to your sheet.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
For each
listedPage- 1Jina AIRead urlFetches each listed page once and turns it into clean readable text, following no links to other pages.
If
pageTextis not empty- 2OpenAIQuery modelAsks the AI to pull your listed details out of the page text as one line, writing 'n/a' for anything unstated.
- 3Google SheetsAppend rowAppends one row per page holding the page address followed by each extracted value in the order you listed.
- 2
- 1
How it works
What happens on each run, in plain English.
Give it a list of web pages and the details you want off each one, and run it. Every page is fetched once, exactly as you listed it, and read as clean text, then an AI step pulls out the details you asked for and they are written across one row per page in your Google Sheet.
You end up with one appended row per page: the page address first, then your details in the order you listed them, with 'n/a' wherever the page does not say. Nothing crawls, follows links or wanders onto other pages. Values are written exactly as extracted, so nothing off a page can turn into a spreadsheet formula, and rows are only ever added, so running it again with a new list never disturbs what is already there. A page that will not load, or that comes back with no readable text, is named in the run log and the remaining pages carry on.
Before the first run you need a sheet whose header row reads 'Page' followed by your fields in the same order, since the workflow cannot name the columns for you.
You May Also Be Interested In
Read a whole site into spreadsheet rowsFinds the pages on a site from its sitemap or front page, reads each one, and adds a row per page to your sheet.
Ask a question about your sheet, get a chart backWrite a question about a tab of your spreadsheet and get back a chart of the numbers already in it, recorded on your answers tab.
Tell me when a page I watch changesChecks the pages you list each day and emails you when the wording actually changes, with a note on what changed.Turn order emails into spreadsheet rowsReads order emails hourly, has AI pull out each line item, and appends it to your order sheet.
Start from a workflow that already works.
Add "Turn a list of web pages into spreadsheet rows" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required