The Scenario
You're a market research analyst at a SaaS company. Your team runs 20+ ParseHub scrapers — competitor pricing pages, review sites, job boards — and your quarterly infrastructure review is tomorrow. Your manager wants a single workbook listing every active project with its name, token, and last-run date so you can audit which scrapers are stale and which are still producing data.
The bad version:
- You open ParseHub, click into each project one by one, copy the name and token, and paste them into the workbook manually
- By project 12 you've mixed up two tokens and have to go back and re-check
- You still don't have last-run timestamps because ParseHub doesn't surface them easily in the UI without clicking into individual runs
You don't have time for that.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the data and talks to ParseHub for you. No mapping, no automation, no copy-paste.
Open the SheetXAI sidebar and type:
Fetch all my ParseHub projects and list them in this workbook with project name in column A, project token in column B, and last run time in column C
What You Get
- Every project in your ParseHub account written to the workbook in a single operation — names, tokens, and timestamps all aligned
- Last run times formatted as readable dates so you can sort or filter immediately
- A complete portfolio snapshot ready for the quarterly review without a single manual copy
What If the Data Is Not Quite Ready
When some projects have never been run
Fetch all my ParseHub projects and list them in columns A, B, and C — for any project with no last run time, put "Never run" in column C instead of leaving it blank
When you need to flag stale scrapers inline
Pull all ParseHub projects into columns A, B, and C — project name, token, last run time — then add a column D that says "Stale" if the last run was more than 30 days ago and "Active" otherwise
When you only want projects that have run in the last 90 days
Fetch all ParseHub projects where the last run time is within the past 90 days and write project name, token, and last run time into columns A, B, and C
When you want it all in one shot
Fetch all ParseHub projects, write project name to column A, token to column B, and last run time to column C, mark column D as "Stale" if last run was over 30 days ago, sort by last run time descending, and bold the header row
The pattern: instead of pulling the data first and then cleaning and annotating it, you ask for both in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you track your ParseHub projects. Ask it to list all your projects with names, tokens, and last-run dates. The ParseHub integration is included in every SheetXAI plan. For the ParseHub in Excel overview, see the hub article.