The Scenario
Your DevOps lead left the company three weeks ago. They were the only person who knew which Smartproxy hostname maps to which proxy type and which port range belongs to which configuration. Now a new engineer is onboarding and needs to hard-code specific endpoints into six different scraper microservices — and there's no reference document anywhere. Just a Slack message from the departed engineer saying "it's in the dashboard."
The bad version:
- You log into the Smartproxy dashboard and start navigating through the endpoint sections, clicking into each proxy type category to find hostname and port information
- You copy hostnames and port ranges one at a time into a blank Excel workbook, manually categorizing them by proxy type — residential, datacenter, ISP, mobile — and trying to remember whether the sticky session ports are a separate range or an offset from the rotating ones
- Three hours later, the reference worksheet is half-complete, some port ranges are formatted inconsistently, and you're not confident the dashboard showed you every available endpoint or just the ones active on your current plan
Infrastructure planning stalls because the people doing the planning can't get a complete, trustworthy reference in a reasonable amount of time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook, understands what you need, and through its built-in Smartproxy integration can fetch the full endpoint catalog and write every hostname, port range, and proxy type directly into your workbook in a structured format.
List every available Smartproxy endpoint by type (random and sticky) and write location, hostname, and port range into columns A, B, and C of this Excel file starting at row 2 — organize rows by proxy type
What You Get
- Columns A, B, and C fill with a row per endpoint — location, hostname, and port range — pulled directly from the Smartproxy catalog
- Rows are grouped by proxy type (residential, datacenter, ISP, mobile) so the new engineer can scan the table by infrastructure category
- Both rotating and sticky session port ranges are included where Smartproxy exposes them separately, written into distinct rows so there's no ambiguity about which port to use for which session type
What If the Data Is Not Quite Ready
The workbook needs a fourth column distinguishing rotating vs. sticky session type per endpoint
Fetch all Smartproxy endpoints and write location into column A, hostname into column B, port range into column C, and session type (rotating or sticky) into column D — include one row per endpoint-session type combination
The reference table needs to be filtered to only datacenter endpoints
Fetch all Smartproxy datacenter proxy endpoints and write location, hostname, and port range into columns A, B, and C — exclude residential, ISP, and mobile endpoint types from the results
The team needs the output mapped against a list of target microservices in column E
For each microservice name in column E (rows 2–8), look up the Smartproxy datacenter endpoint that matches the city in column F, and write the matching hostname into column G and the port range into column H — leave columns G and H blank if no match is found
The engineer needs a complete infrastructure doc with all endpoint data plus a column tracking which services each endpoint is assigned to, all in one pull
Fetch all Smartproxy endpoints and write location, hostname, proxy type, and port range into columns A through D — then for each endpoint, check if its hostname appears in column F of the Service Assignments worksheet and write the matching service name into column E, or write "unassigned" if no match is found
One prompt handles the catalog pull, the cross-worksheet lookup, and the assignment annotation at the same time.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook you're using for infrastructure planning, then ask it to pull the full Smartproxy endpoint catalog into a structured reference table. Link back to the hub: How to Connect Smartproxy to Excel. Or see the related spoke: Generate Per-Project Smartproxy Endpoints From an Excel workbook Config Table.