The Scenario
You are an accounts payable specialist. Your company just switched to Brex for vendor payments. The procurement team handed you a Google Sheet with twenty-five new vendors: company name, email address, ACH routing number, and account number.
Every vendor needs to exist in Brex before a payment can be made. The first payment run is Thursday.
The slow version:
- Open Brex, navigate to Vendors, click Add Vendor
- Type the company name, enter the email
- Navigate to the Payment Accounts section, select ACH, enter routing number, enter account number
- Verify the entry, save
- Repeat twenty-five times
- Realize on vendor eighteen that you confused the routing number and account number for vendor twelve
- Go back to vendor twelve, fix it, flag it for review, and restart the verification.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads every row in the supplier sheet and creates each vendor in Brex with the payment account details attached.
Open the SheetXAI sidebar and type:
Create a Brex vendor for every row in this sheet. Use the company name from column A as the vendor name, the email from column B as the contact email, and create an ACH payment account using the routing number from column C and the account number from column D. Write "Created" or the error message into column E for each row.
SheetXAI reads all twenty-five rows, creates each vendor in Brex with the ACH account attached, and writes the status into column E.
What You Get
Column E with a clear status for every vendor:
- "Created" — vendor and payment account created successfully
- Error reason — if a row failed (duplicate name, invalid routing number, etc.)
The routing and account numbers come from the sheet, not from your clipboard. No transposition errors.
If Brex flags a routing number as invalid, the error message tells you which row and why. You fix the sheet, re-run those rows only.
What If the Data Is Not Quite Ready
Supplier lists from procurement always have edge cases. SheetXAI handles them in the same prompt.
When some vendors use wire transfer instead of ACH
Column E in the sheet says "ACH" for most vendors but "Wire" for three international suppliers.
For each vendor row in this sheet, check column E for the payment type. If it says "ACH," create the vendor in Brex with an ACH account using columns C and D. If it says "Wire," create the vendor with a wire transfer account using the SWIFT code in column F and IBAN in column G. Write the result into column H.
When vendor names might already exist in Brex
You have some overlap with vendors your predecessor added manually. You do not want duplicates.
Before creating each vendor in this sheet, check whether a vendor with that company name already exists in Brex. If it exists, write "Already exists — skip" into column E. If it does not exist, create the vendor with the payment account details from the sheet and write "Created" into column E.
When the sheet has missing ACH details for some rows
Three vendors have company name and email but no payment account information yet. You still need to create the vendor record so the payment team can add ACH details later.
For each row in this sheet, create a Brex vendor using the company name from column A and email from column B. If columns C and D have ACH details, attach the payment account. If they are blank, create the vendor without a payment account and write "Vendor created — payment details pending" in column E.
When you need to create vendors and immediately set a payment approval threshold
Your company policy requires a payment approval for any vendor payment over $10,000. This threshold needs to be set at the vendor level in Brex.
Create a Brex vendor for every row in this sheet with the company name, email, and ACH details from columns A through D. After creating each vendor, set the payment approval threshold to $10,000. Write the full status of both operations into column E.
The pattern: describe the complete vendor record you need, including edge cases, and SheetXAI handles the branching row by row.
Try It
Get the 7-day free trial of SheetXAI and open the supplier sheet your procurement team sends for the next payment run, then ask it to create all the Brex vendors at once. The Brex integration is included in every SheetXAI plan. See also how to bulk-update Brex expense memos from a correction sheet or the Brex in Google Sheets overview.