The Scenario
Compliance review is in three weeks. Your recruiting ops manager got an email from legal: every active job posting needs a salary range visible before the review date. She needs a full list of all open jobs — title, department, location, listing status, and comp range — in an Excel workbook so she can identify the gaps and route them to the right people.
Ashby has all of this. Getting it out is the question.
The bad version:
- Navigate to the Jobs list in Ashby. Click job 1. Note the title, department, location, listing status. Click to the compensation section. Note the min and max. Go to Excel. Enter the row.
- Click job 2 in Ashby.
- At job 15 you realize Ashby's job list view does not show comp ranges inline — you have to click into each job's detail. What you thought would be a quick export is actually 60 individual clicks.
Sixty jobs at two minutes each is two hours of clicking for data that is structured and queryable.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It queries Ashby through a built-in integration and pulls the full job list — including comp ranges — in one call.
Pull all Ashby job postings and write title, listing status, job board names, and compensation range into the Excel 'PostingAudit' sheet.
SheetXAI calls the Ashby jobs endpoint, handles pagination, and writes one row per job — comp ranges included — into the PostingAudit worksheet.
What You Get
- One row per open job with title, listing status, job board names, comp min, and comp max.
- Jobs with no comp range show blank in those columns — making gaps immediately visible.
- The PostingAudit worksheet is shareable with legal the same day.
- No reformatting needed.
What If the Data Is Not Quite Ready
You want to flag jobs missing salary ranges immediately
Fetch all open Ashby jobs. Write job title, department, location, listing status, and comp min/max into the PostingAudit worksheet. In the next column, flag any job where comp min or comp max is blank as "Missing salary range."
You only want jobs in specific departments
Fetch all open Ashby jobs in the Engineering department. Write job title, location, listing status, employment type, and compensation range into the PostingAudit worksheet.
You want to include both open and draft jobs
Fetch all Ashby jobs with status "Open" or "Draft". Write job title, department, location, listing status, and comp min/max into the PostingAudit worksheet. Include a column showing the status.
Pull all jobs, flag missing comp, group by department, and sort by listing status
Fetch all open Ashby jobs. Write job title, department, location, listing status, employment type, comp min, and comp max into the PostingAudit worksheet. Flag any job with a blank comp field as "Needs compensation" in the next column. Sort rows by department, then by listing status within each department.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull your full Ashby job inventory with compensation details so you can identify gaps before a compliance or pay-equity review. See also the spoke on exporting pipeline data for department heads, or return to the Ashby overview.