The Scenario
The leadership team has decided to redo the careers page. The designer needs a complete list of all live job postings to audit the copy. The finance partner needs the same list, sorted by department, to validate the headcount plan. You have one source of truth — Lever — and two people who need it in a spreadsheet by end of day.
The bad version:
- Log into Lever, switch to the job postings view, filter to published, and start scrolling through 80 postings
- Export whatever Lever gives you, discover the CSV columns don't match what the designer asked for, and start a manual cleanup
- Realize the finance view needs a completely different column set and repeat the whole process from scratch
You have two separate asks, one data source, and no version of this that doesn't involve doing the same export twice with different formatting.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Lever, reads the full postings list, and writes the data into whatever column structure you specify — in one pass.
Open a blank Google Sheet and type:
List all published Lever job postings and write the posting title, team, department, location, and commitment type into columns A through E of this sheet — one row per posting
What You Get
- Column A: posting title
- Column B: team
- Column C: department
- Column D: location (city or remote designation)
- Column E: commitment type (full-time, part-time, contract)
- One row per published posting, no duplicates
- Draft postings excluded unless you ask for them
What If the Data Is Not Quite Ready
You need both published and draft postings, flagged separately
List all Lever job postings regardless of state and write posting title, team, department, and state into columns A through D — write 'Published' or 'Draft' in Column D based on the posting state
The finance partner needs the posting ID included for their VLOOKUP
List all published Lever job postings and write posting ID, title, team, department, and location into columns A through E — the finance team will use Column A as a lookup key
Location data is inconsistent (some say 'Remote' others say 'Remote – US')
List all published Lever job postings into columns A through E. For any location value that contains the word 'Remote', normalize it to 'Remote' before writing to Column D
You want a summary count by department alongside the full list
List all published Lever job postings into columns A through E. Then, starting in column G, write a summary table showing department name and posting count — one row per department, sorted descending by count
A single prompt for the full list and the summary cuts out the pivot table step entirely.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet linked to your Lever account, then ask it to export your current postings with whatever columns your careers team or finance partner needs. See also the spoke on exporting active opportunities or return to the Lever integration overview.