Turn a list on a website into a sheet
Each item from each page, one row for each, with no duplicates.
- You start it: When you start it
What it does
The task
Open url. Collect each item in the list, on all pages. For each item, copy these fields: fields. Put the data in a new Google Sheet, with a header row and one row for each item. Remove duplicates. Tell me the number of rows, and each item that you could not read.
- It works in any website and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- It runs once, when you start it.
What you give it
| Blank | What to give | Example |
|---|---|---|
| url | The page with the list | https://www.retailtechexpo.com/exhibitors |
| fields | The fields to copy for each item, separated by commas | Company, booth, category, website |
What you get back
An example run with the example values above. Your run uses your own data.
Rows: 412, from 21 pages
Columns: Company, Booth, Category, Website
| Brightcart | A14 | Self-checkout | brightcart.com |
|---|---|---|---|
| Ludo Labels | C02 | Shelf labels | ludolabels.com |
| Parcelnest | F31 | Lockers | parcelnest.eu |
Duplicates removed: 6
Could not read: 2 items with no booth number
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 2 blanks
Type url and fields. Tab moves to the next blank.
- 03
Run it
Run sends it to the agent. Follow each step in the panel, and stop it at any time.
From the terminal
cuiar exec "Open https://www.retailtechexpo.com/exhibitors. Collect each item in the list, on all pages. For each item, copy these fields: Company, booth, category, website. Put the data in a new Google Sheet, with a header row and one row for each item. Remove duplicates. Tell me the number of rows, and each item that you could not read."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool run_task to run my "Turn a list on a website into a sheet" template with url = https://www.retailtechexpo.com/exhibitors; fields = Company, booth, category, website.Setup for other agents: AI agents.
The tool call
{
"name": "run_task",
"arguments": {
"task": "Open https://www.retailtechexpo.com/exhibitors. Collect each item in the list, on all pages. For each item, copy these fields: Company, booth, category, website. Put the data in a new Google Sheet, with a header row and one row for each item. Remove duplicates. Tell me the number of rows, and each item that you could not read."
}
}Related templates
All data templatesData
List local businesses with their contacts
Name, address, phone, website, rating and e-mail for each business.
You start it: When you start it- Google Maps
- Google Sheets
Data
Export your order history
For stores with no export: each order in a sheet, with totals for each year.
You start it: When you start it- Any online store
- Google Sheets
Data
Pull tables from PDFs into a spreadsheet
Each matching table from your PDFs and scans in one sheet, with numbers as numbers and the page noted.
You start it: When you start it- Google Drive
- Google Sheets
Data
Clean up a messy spreadsheet
Consistent names, dates, phone numbers and amounts in a new tab, with a count of each type of change.
You start it: When you start it- Google Sheets
Data
Find and merge duplicate rows in a sheet
Exact and near-duplicate rows grouped and merged into one row each, with a list of every merge.
You start it: When you start it- Google Sheets
Data
Build one table from several public statistics
Numbers from official sources in one sheet, with the same units, years and country codes.
You start it: When you start it- OOur World in Data
- Any government site
- Google Sheets