The Scenario
The compensation analyst has been asked to run a pay equity review. She needs all offers extended in the last six months — offer status, base salary, equity package, and start date — for 200 opportunity IDs that HR pulled from Lever. The offer data is not in any spreadsheet. It is in Lever, attached to individual opportunity records.
The bad version:
- Click into the first Lever opportunity, scroll to the offers section, write down the offer status, base salary, equity, and start date
- Repeat for 199 more opportunities
- Finish the manual entry and realize the equity field format is inconsistent across offers — some say '0.05%', others say '5000 options', others are blank
She was asked to do analysis. She has spent the afternoon doing data collection.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the opportunity IDs in Column A and pulls the offer data for each one from Lever — status, salary, equity, start date — into adjacent columns in one pass.
Open your pay equity analysis sheet with opportunity IDs in Column A and type:
For each opportunity ID in Column A, list all Lever offers and write the offer status, base salary, equity, and start date into columns B through E — one row per offer
What You Get
- Column B: offer status (extended, accepted, declined, etc.)
- Column C: base salary as returned by Lever
- Column D: equity value or grant as returned by Lever
- Column E: offer start date
- Multiple offers per opportunity each get their own row, with the opportunity ID repeated in Column A
- Opportunities with no offers produce no rows
What If the Data Is Not Quite Ready
You need to flag declined offers for the equity review
Pull all offers from the Lever opportunities in Column A and write offer status and total comp into this sheet — flag rows in Column F where the offer was declined
Salary values come back as strings and need to be numeric
For each opportunity ID in Column A, pull all Lever offers and write status, base salary, equity, and start date into columns B through E — convert any salary values that are formatted as strings with currency symbols into plain numbers before writing to Column C
Some opportunity IDs have no offers and should be logged
For each opportunity ID in Column A, pull Lever offers and write status, salary, equity, and start date into columns B through E. For opportunity IDs with no offers at all, write 'No offer found' in Column B and leave the rest blank
Pull offers, flag declined, calculate average salary, and summarize in one pass
For each opportunity ID in Column A, pull Lever offers into columns B through E. Flag rows where Column B is 'Declined' with 'Declined' in Column F. Then in cell H1, calculate the average base salary across all non-declined offers and label it 'Average Accepted Base Salary'
One prompt delivers the detail and the summary statistic the analyst needs to start the review.
Try It
Get the 7-day free trial of SheetXAI and open your pay equity analysis sheet with Lever opportunity IDs, then ask it to pull offer records with whatever fields and flags your compensation team needs. See also the spoke on exporting referral data or return to the Lever integration overview.