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
The integration steps this workflow runs, in the order it first runs them.
- 1Jina AIRead url
- 2OpenAIQuery model
- 3Google SheetsAppend row
How it works
Everything the template sets up, and what to fill in before the first run.
Give it the pages you want captured and the details you want off each one, and it reads every page and adds one row per page to your Google Sheet.
Each page is fetched once, exactly as you listed it - nothing crawls, follows links, or wanders onto other pages. The page is read as clean text, an AI step pulls out the details you asked for, and those values are written across the row.
Columns follow the order you list them in the 'fieldsToExtract' step, after a first column holding the page address. The workflow cannot name your columns for you, so put your own header row in the sheet first - 'Page' followed by your fields, in the same order - and every run will line up underneath it. Values are written exactly as extracted, so nothing off a page can turn into a spreadsheet formula.
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. Rows are only ever added, so running it again with a new list never disturbs what is already in the sheet.
Fill in 'pageUrls', 'fieldsToExtract' and 'spreadsheetUrl' to set it up.
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