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' sheet — 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 sheet, 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 Google Sheet. It reads the 'New Buyers' tab, 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.
For every customer row in my 'New Buyers' sheet, create a Poof deposit address on the Ethereum network and write the returned address into column C alongside the customer ID in column A.
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' sheet, 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' sheet, 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 tabs — retail and wholesale
Your workbook has a 'Retail Buyers' tab and a 'Wholesale Buyers' tab with the same column layout.
For every customer row in both my 'Retail Buyers' and 'Wholesale Buyers' sheets, create a unique Poof ETH deposit address and write it into column C of each respective tab.
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' tab.
For every row in my 'New Buyers' sheet 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' tab 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 Google Sheet 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 or return to the full Poof integration overview.