The Scenario
An NFT marketplace just processed 35 new buyers and every one of them needs a unique ETH deposit address before fulfillment can proceed. The buyer list is in the 'New Buyers' worksheet — customer ID in column A, name in column B, column C empty and waiting for the deposit address. The team responsible for fulfillment won't touch a row without a confirmed address in column C, and right now the whole queue is blocked.
The bad version:
- Log into Poof, navigate to deposit address generation, enter the first customer ID as the reference, select Ethereum, generate the address, copy it, flip to the workbook, paste into C2.
- Repeat for all 35 buyers.
- Discover on row 20 that you should have been using a customer-scoped label parameter in Poof so each address is traceable — which means starting over from row 1 with the correct settings.
Thirty-five addresses at two minutes each is over an hour of dashboard work before a single item ships.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the 'New Buyers' worksheet, understands the customer IDs, and through the Poof integration it generates a unique ETH deposit address for each row and writes it into column C — no dashboard visits required.
Read 35 customer IDs from my Excel sheet and generate a unique Poof crypto deposit address for each one, writing the addresses into column B so I can paste them into the fulfillment system.
What You Get
- Column C populated with a unique Poof ETH deposit address for every buyer row.
- Addresses tied to the customer ID in column A so they're traceable without a separate lookup.
- Any row where address generation fails gets a note in column C rather than a blank cell.
- Columns A and B are untouched.
What If the Data Is Not Quite Ready
Some customer IDs have special characters that could break the Poof reference label
A handful of IDs in column A include slashes or spaces that might cause the Poof API to reject the label parameter.
For every row in my 'New Buyers' worksheet, sanitize the customer ID in column A by replacing any spaces with underscores and removing special characters, then create a Poof ETH deposit address using the sanitized ID as the reference label and write the address into column C.
Buyers need addresses on different networks depending on their country
Column D contains the buyer's country code. US buyers get an ETH address, international buyers get a Polygon address.
For every row in my 'New Buyers' worksheet, check column D for the country code. If column D is 'US', create a Poof deposit address on Ethereum. Otherwise create it on Polygon. Write the address into column C and the network used into column E.
Buyers are split across two worksheets — retail and wholesale
Your workbook has a 'Retail Buyers' worksheet and a 'Wholesale Buyers' worksheet with the same column layout.
For every customer row in both my 'Retail Buyers' and 'Wholesale Buyers' worksheets, create a unique Poof ETH deposit address and write it into column C of each respective sheet.
The full validate-plus-assign kill chain
Customer IDs need sanitizing, some buyers already have addresses from a previous run (column C not empty), and you want a log of the generated addresses written to a separate 'Address Log' worksheet.
For every row in my 'New Buyers' worksheet where column C is blank, sanitize the customer ID in column A by removing special characters, create a Poof ETH deposit address using the sanitized ID as the reference, write the address into column C, and also append a new row to the 'Address Log' worksheet with the customer ID, name, generated address, and today's date.
Running the validation, generation, and logging in one prompt means your address log is always current without a separate export step.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of new customers waiting for crypto deposit addresses — even if the IDs need sanitizing or buyers need different networks — and ask it to generate and assign addresses in one pass. You can also see how SheetXAI handles importing the full list of supported token contracts from Poof into Excel or return to the full Poof integration overview for Excel.