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 a Google Sheet 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 the sheet. Enter the row.
- Click job 2 in Ashby.
- At job 15 you realize Ashby's job list view doesn't actually show comp ranges inline — you have to click into each job's detail to find it. What you thought would be a quick export is actually clicking into 60 individual job records.
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 Google Sheet. It queries Ashby through a built-in integration and pulls the full job list — including comp ranges — in one call.
Fetch all open Ashby jobs and write job title, department, location, listing status, employment type, and compensation min/max into this sheet.
SheetXAI calls the Ashby jobs endpoint, handles pagination, and writes one row per job — comp ranges included — without you clicking into a single record.
What You Get
- One row per open job with title, department, location, listing status, employment type, comp min, and comp max.
- Jobs with no comp range show blank in those columns — making it easy to see exactly which ones are missing.
- The sheet is shareable immediately; no reformatting needed.
- Legal gets the audit-ready list before the end of the day.
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 this sheet. In column G, flag any job where comp min or comp max is blank as "Missing salary range."
You only want jobs in a specific department or location
Fetch all open Ashby jobs in the Engineering department. Write job title, location, listing status, employment type, and compensation range into this sheet.
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 this sheet. Include a column showing the status.
Pull all jobs, flag missing comp, group by department, and flag by listing status in one pass
Fetch all open Ashby jobs. Write job title, department, location, listing status, employment type, comp min, and comp max into this sheet. In column H, flag any job with a blank comp field as "Needs compensation." Sort rows by department, then by listing status within each department.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, 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.