Turn any listing page into a spreadsheet
Minda turns the list on any listing page into a spreadsheet with the columns you ask for, and fills nothing from memory. It is a ready-made task for the SI agent in Minda Super Intelligence. It runs when you start it. It works with Google Sheets and Excel. You fill in [page link], [columns], [pages], [file name] and [sheet link].
In Minda: Tasks → New → Browse tasks → Turn any listing page into a spreadsheet. Minda Super Intelligence for Windows is coming soon.
- Data
- The web
- Google Sheets
- Excel
- Read every item
- Open an item's own page only when a column I…
- If the page asks me to sign in or blocks you,…
- Save it as [file name].xlsx, or paste it into…
What you get
Reads the whole list It scrolls to the end and follows next-page links, up to the number of pages you set.
Your columns You choose the columns, and it opens an item's own page only when a column is not on the list.
Copied as shown Values are copied exactly as shown, cells stay blank when the page shows nothing, and exact duplicates are dropped.
Saved where you want it It saves an .xlsx file, or pastes into your sheet without overwriting cells that already hold data.
Why use this?
Minda reads every item, follows next-page links up to the number of pages you allow and puts the rows in a spreadsheet. It finishes with the row count, the pages read and the blanks per column.
What it does
- When
- When you start it
- Works with
- The web, Google Sheets, Excel
- For
- Everyone, Sales, Analysts
- You fill in
- [page link], [columns], [pages], [file name], [sheet link]
How it works
- WhenWhen you start itSave it as a workflow to run it daily at 9am instead
- Each runMinda does the taskOpen [page link] and turn its list into a spreadsheet.
- ThenTasks shows what it didOpen it there to read the result and ask for changes
Read every item: scroll to the end and follow next-page links for up to [pages] pages
Open an item's own page only when a column I asked for isn't on the list
If the page asks me to sign in or blocks you, stop and tell me where
Save it as [file name].xlsx, or paste it into [sheet link] if I gave one, without overwriting cells that already hold data
Finish with the row count, the pages read and the blanks per column
Rules it keeps
The agent follows these on every run.
Copy values exactly as shown
Leave a cell blank when the page doesn't show it
Never fill in from memory
Drop exact duplicates
The full prompt
This is what the SI agent is asked to do. The parts in brackets are what you fill in.
Open [page link] and turn its list into a spreadsheet. Columns: [columns, e.g. name, price, rating, address, phone, website, link]. Read every item: scroll to the end and follow next-page links for up to [pages, e.g. 10] pages. Open an item's own page only when a column I asked for isn't on the list. Rules: copy values exactly as shown; leave a cell blank when the page doesn't show it; never fill in from memory; drop exact duplicates. If the page asks me to sign in or blocks you, stop and tell me where. Save it as [file name].xlsx, or paste it into [sheet link] if I gave one, without overwriting cells that already hold data. Finish with the row count, the pages read and the blanks per column.
Who is it for?
Sales teams building lists You want names, prices or contact details from a directory page in a spreadsheet.
Analysts collecting data You need a page's list as rows and columns, copied exactly as shown.
People copying long lists You have a page of items and want them in a sheet without copying each one.
Frequently asked questions
What do I fill in?
The page link, the columns you want, how many pages to follow, and a file name or a sheet link.
What if the page asks me to sign in?
It stops and tells you where. It does the same if the page blocks it.
Will it overwrite my sheet?
No. If you give a sheet link, it pastes the rows without overwriting cells that already hold data.
Does it fill gaps from memory?
Never. A cell stays blank when the page does not show the value.
What do I get at the end?
The row count, the pages it read and the number of blanks per column.
Run this task in the Minda app
In Minda: Tasks → New → Browse tasks → Turn any listing page into a spreadsheet. Minda Super Intelligence for Windows is coming soon.
Last updated