The Scenario
A client sent you an Excel workbook with 15 Sidetracker list IDs and a note that says "need full details for the deliverable by Thursday." No names, no member counts, no configuration data — just raw IDs in column A. You've never worked with this client's Sidetracker account before, and you have no idea what half these lists contain.
The bad version:
- Take the first ID, log into the client's Sidetracker, navigate to the Lists section, search for the ID, open it, copy the name and member count, paste them into the workbook.
- Realize the workbook has columns for "Created Date" and "List Status" that you haven't captured yet — go back into Sidetracker, find the list again, look for those fields.
- Repeat for the remaining 14 IDs, taking care not to lose your place or mix up which row corresponds to which ID.
The deliverable has to look polished. Walking into a client review with a half-filled table because the enrichment took longer than expected isn't where you want to be.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the list IDs already in your workbook, calls the Sidetracker API for each one, and fills in the detail columns for you.
Look up every Sidetracker list ID in my Excel 'Lists' table and enrich the rows with the full list details returned from the API — write the name into column B, member count into column C, created date into column D, and errors into the Status column.
What You Get
- Columns B through D filled in for every row that has a list ID in column A.
- Where the API returns a valid response, all columns populate with the correct values.
- Where an ID doesn't exist or the API returns an error, the Status column gets a note — "Not found" or the specific error — so you can flag it for the client rather than leaving a blank.
- The workbook stays sorted exactly as the client sent it; no rows are reordered.
What If the Data Is Not Quite Ready
Some list IDs in column A have extra whitespace or formatting issues
For each list ID in column A of my Excel 'Lists' table, trim any leading or trailing whitespace before fetching the Sidetracker details. Fill columns B, C, and D with name, member count, and created date. Log any IDs that still fail after trimming in the Status column.
I need to enrich IDs from two different worksheets and combine them
Fetch Sidetracker list details for all IDs in column A of worksheet 'Wave 1' and all IDs in column A of worksheet 'Wave 2'. Combine the results into a new worksheet called 'Full Enriched List' with columns for list ID, name, member count, and created date — no duplicates.
The client gave me list names instead of IDs, and I need to look up the IDs first
Look up each list name in column A of my Excel 'Lists' table against my full Sidetracker list catalog. Write the matching list ID into column B, then fetch the member count and created date into columns C and D for each match.
I need to enrich, flag stale lists, and format the output for a client PDF in one shot
For each list ID in column A of my Excel 'Lists' table, fetch the Sidetracker details. Fill columns B, C, and D with name, member count, and created date. In the Status column, write "Stale" for any list with a created date older than 180 days and a member count under 10, and "Active" for everything else. Format the member count column as a number with comma separators.
One pass: enrichment, conditional classification, and formatting — no manual steps in between.
Try It
Open the Excel workbook your client sent you — list IDs in column A, empty columns waiting — and get the 7-day free trial of SheetXAI. Ask it to enrich the rows from Sidetracker and every detail column fills in before you'd have finished looking up the third ID yourself. See also: auditing all your Sidetracker lists and the Sidetracker hub overview.