The Scenario
You are a payroll administrator. The last Friday of the month is payout day. You have 150 contract workers in a Google Sheet — name in column A, email in column B, contact type in column C (vendor, contractor, employee). Before the finance team can run the RazorpayX payouts, every one of these workers needs to exist as a RazorpayX contact.
Setting up contacts in the RazorpayX dashboard, one by one, takes the better part of a morning. Last month it took three hours and you were still missing 12 contacts at payout time because you lost track of which rows you had done.
The slow version:
- Log into the RazorpayX dashboard
- Navigate to Payouts → Contacts → Add New Contact
- Type name, email, contact type, and reference for each worker
- Copy the contact ID back to the sheet
- Repeat 150 times
- At payout time, discover 12 contacts are missing because you mixed up two tabs.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that can create RazorpayX contacts per row and write each contact ID back, without you touching the dashboard.
Open the SheetXAI sidebar and type:
For each row in this sheet, create a RazorpayX contact using the name in column A, email in column B, and contact type in column C. Write the resulting contact ID to column D. If a contact already exists with that email, write the existing contact ID instead. Log any error in column E.
SheetXAI iterates through all 150 rows, creates each contact in RazorpayX, handles duplicate detection by email, and writes the results back row by row.
What You Get
A fully populated sheet ready for the payout team:
- Column D — the RazorpayX contact ID for every worker
- Column E — any error for rows that failed, blank if it succeeded
- Deduplication handled — existing contacts get their existing ID, no duplicates
The payout team uses column D immediately. Contact IDs are what they need to create fund accounts and run payouts. No second pass, no handoff document.
If a contact type in column C is not one of RazorpayX's accepted values, SheetXAI flags the row in column E rather than failing silently.
What If the Data Is Not Quite Ready
Contractor lists from HR systems are rarely clean. SheetXAI handles the fixes and the creation in the same prompt.
When contact types are inconsistent across rows
Some rows say "Vendor," some say "vendor," some say "VENDOR," some say "Supplier." RazorpayX expects canonical values.
Normalize the contact type in column C: map any variation of "vendor" or "supplier" to "vendor," any variation of "contractor" to "self_employed," and any variation of "employee" to "employee." Then create the RazorpayX contacts and write the contact ID to column D.
When some rows are missing email addresses but have a phone number instead
RazorpayX allows contacts with just a phone number.
For rows where column B has a valid email, create the RazorpayX contact using name, email, and contact type. For rows where column B is empty but column F has a phone number, create the contact using name, phone, and contact type instead. Write the contact ID to column D and log any failures in column E.
When the sheet has 150 rows but 40 already have contact IDs from last month
Some workers are repeat contractors whose contacts are already in RazorpayX.
For each row in this sheet, check if column D already has a contact ID. If it does, skip that row. If column D is empty, create a new RazorpayX contact using name, email, and contact type, and write the new contact ID to column D.
When you want the full setup — normalize types, create contacts, log IDs, and flag missing fund accounts
Normalize the contact types in column C to RazorpayX values (vendor, self_employed, employee). For each row where column D is empty, create a RazorpayX contact and write the contact ID to column D. Log errors in column E. Then, for each contact ID in column D, check if a fund account exists for that contact. If no fund account is found, write "No fund account — add before payout" in column F.
The pattern: the data normalization, the contact creation, and the fund account check all happen in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your contractor sheet, then ask it to create the RazorpayX contacts and write the IDs back before the payout run. The Razorpay integration is included in every SheetXAI plan. For related workflows, see how to audit RazorpayX fund accounts or the Razorpay in Google Sheets overview.