The Scenario
Fifteen new starters are joining next Monday. HR sent you the onboarding sheet last week: requester name, email, department, start date, and a notes column for special requests. Each person needs a Freshservice service request created for a laptop setup before they arrive. You found out on Thursday afternoon. Onboarding is in three business days.
The bad version:
- Open the Freshservice service catalog, find the "Laptop Setup" item, click "Create Request," fill in the requester's email, copy the notes from the sheet into the description field, submit.
- Open the catalog again for the next person. Fifteen times.
- On person 9, you forget to check the notes column and submit a request without the "Left-handed trackpad preference" note that the hiring manager explicitly flagged — and now IT is setting up a station that doesn't match what was promised.
Fifteen new hires. One missed detail per form is fifteen potential rework tickets. And you're doing this at 4 PM on a Thursday while also managing the access provisioning spreadsheet and the badge request form.
The sheet exists. The catalog item exists. The gap between them is fifteen repetitive form fills that need to not exist.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your onboarding data and uses its built-in Freshservice connection to create service requests for every row — no form switching, no clipboard shuttling.
Try this yourself — free for 7 days
SheetXAI installs in your Google Sheet in about a minute. Paste the prompt below and watch it run.
Open the SheetXAI sidebar in the onboarding sheet and paste this prompt:
For each row in my sheet, create a Freshservice service request for catalog item 'Laptop Setup' using the RequesterEmail in column B and notes from column E. Write the returned request ID into column F.
What You Get
- A Freshservice service request created for every row using the correct catalog item, requester, and notes.
- The returned service request ID written into column F for each row — giving you a direct reference for each starter.
- Any rows that fail (invalid email, catalog item not found) flagged in column G so you know exactly what to fix before Monday.
- A complete audit trail in the sheet: who has a request, what the request ID is, and what was submitted.
What If the Data Is Not Quite Ready
Some rows are missing a requester email
For each row in the onboarding sheet where column B is not blank, create a Freshservice service request for 'Laptop Setup' using the email in column B and notes from column E. Write the request ID in column F. For rows where column B is blank, write 'SKIPPED - no email' in column F.
Different starters need different catalog items based on their department
For each row in the onboarding sheet, create a Freshservice service request using the RequesterEmail in column B and notes from column E. If column C (Department) is "Engineering," use catalog item 'Developer Laptop Setup'; otherwise use 'Standard Laptop Setup.' Write the request ID into column F.
Start dates are in the future and you want to set the due date accordingly
For each row in the onboarding sheet, create a Freshservice service request for 'Laptop Setup' using RequesterEmail from column B, notes from column E, and set the due date to two days before the start date in column D. Write the request ID into column F.
Full onboarding service request blast: validate + create + confirm in one shot
In the onboarding sheet, skip any row where column B is blank or doesn't contain an "@" character. For all valid rows, create a Freshservice service request for 'Laptop Setup' using RequesterEmail from column B, Department from column C as additional context in the description, and notes from column E. Set the due date to two business days before the start date in column D. Write the request ID into column F and 'FAILED' with the error into column G for any that don't succeed.
One prompt for the whole cohort — validation, catalog routing, due-date logic, and confirmation all handled inline.
Try It
Get the 7-day free trial of SheetXAI and open the next onboarding Google Sheet that lands in your inbox, then ask it to spin up all the Freshservice service requests before the starters arrive. When you're done, check out how to pull the Freshservice service catalog into a sheet or return to the Freshservice hub.