The Scenario
The growth team ran a SQL query, exported 150 PostHog user UUIDs to an Excel workbook, and now needs every one of them added to the static cohort "High LTV Users Q2" before the experiment goes live Friday. It's the third time this week someone has sent over a UUID list expecting it to be loaded into PostHog. The first two times involved clicking through the PostHog cohort UI and adding people one at a time. There were 30 then. This list has 150.
The bad version:
- Open PostHog, navigate to the cohort, click "Add person," paste a UUID, confirm, repeat 150 times across two browser tabs
- Lose your place at row 87 when a notification pulls your attention away, restart from your best guess
- Finish the adds, find out three UUIDs had trailing newline characters from the SQL export and PostHog rejected them silently — those users are missing from the cohort
There are 150 rows and a Friday deadline. This is not a clicking job.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your UUID list, calls the PostHog bulk-add cohort endpoint, and writes back a status for each record — without a single click in PostHog's UI.
Read all user UUIDs from column A of this workbook and bulk-add them to the PostHog static cohort named 'High LTV Users Q2'. Write the result status for each UUID into column B.
What You Get
- All 150 UUIDs are submitted to PostHog's bulk-add endpoint in a single call
- Column B receives a status for each row: "Added" or the specific rejection reason
- Any UUID that fails (whitespace, invalid format, not found) is identified so you can fix and re-run only those rows
What If the Data Is Not Quite Ready
UUIDs have trailing whitespace from the SQL export
Trim all whitespace from column A before sending, then bulk-add the cleaned UUIDs to PostHog static cohort ID cohort_123. Write "Added" or the error into column B.
You only want to add users meeting a filter condition
Add only the UUIDs from column A where column C says "Enterprise" to the PostHog static cohort named 'High LTV Users Q2'. Skip rows where column C is blank. Write status into column D.
UUIDs are split across two worksheets
Combine all UUIDs from the "Q1 Export" worksheet column A and the "Q2 Export" worksheet column A, deduplicate them, then bulk-add the unique list to PostHog static cohort ID cohort_456. Write a summary count of added vs. skipped.
Clean, dedup, filter, and add in one pass
In the "Cohort Candidates" worksheet: trim column A, remove rows where column B plan type is "Free", deduplicate column A UUIDs, and bulk-add the remaining UUIDs to PostHog static cohort named 'High LTV Users Q2'. Write status into column C and a final count at the bottom.
One prompt — data cleanup and the API call together.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of PostHog user IDs — from a SQL export or a CRM filter — and ask it to bulk-add them to a cohort. Also see: Export All PostHog Feature Flags Into an Excel workbook for Audit and the PostHog hub.