The Scenario
You are a CRM manager. You have been sitting on a problem for three weeks: 800 at-risk users in a Google Sheet, identified by support ticket count and inactivity. Your team wants to run a targeted campaign in Amplitude — but the cohort does not exist yet in Amplitude. Someone has to upload the user IDs.
That someone is you. Eight hundred rows. Manual upload form in Amplitude. One row at a time or a CSV that may or may not import cleanly, depending on the column format.
The slow version:
- Format the Google Sheet into the exact column structure Amplitude's CSV import expects
- Export the sheet as a CSV
- Log into Amplitude, navigate to Cohorts, find the Create Cohort option
- Upload the CSV, wait for validation, fix any format errors, re-upload
- Name the cohort 'High-Churn-Risk Q2 2025'
- Thirty minutes later, one cohort exists.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects directly to Amplitude and can create or update cohorts from data already in your sheet — no CSV export, no upload form.
Open the SheetXAI sidebar and type:
Take the user IDs in column A (rows 2–801) and upload them as a new cohort named 'High-Churn-Risk Q2 2025' in Amplitude.
SheetXAI reads the column, calls the Amplitude Cohort API, and creates the cohort. You do not leave the sheet.
What You Get
A new Amplitude cohort named 'High-Churn-Risk Q2 2025' containing all 800 user IDs from column A, ready for targeting in any Amplitude downstream workflow: campaigns, experiments, chart segmentation.
The cohort is live immediately, not pending review. If Amplitude returns a cohort ID, SheetXAI can write it into a cell so you have a record without going back into Amplitude to look it up.
Need to add users to an existing cohort instead of creating a new one? Same prompt, different instruction:
Read my list of 200 Amplitude user IDs from column B and add them to my existing 'Re-engagement May' cohort.
What If the Data Is Not Quite Ready
User ID lists in spreadsheets are rarely clean. SheetXAI handles the cleanup and the upload in the same prompt.
When the column has duplicate user IDs
The list was assembled from two sources and some IDs appear twice.
Deduplicate the user IDs in column A, keeping only unique values. Then upload the deduplicated list as a new cohort named 'High-Churn-Risk Q2 2025' in Amplitude. Write the final unique count into cell C1.
When some rows have blank or invalid user IDs
A few rows in column A are empty or contain placeholder text like "N/A" from an export.
Filter column A to include only rows where the user ID is a non-empty numeric value. Upload the valid user IDs as a new Amplitude cohort named 'High-Churn-Risk Q2 2025'. Write the number of skipped rows into cell B1.
When the list needs to be split across multiple cohorts by risk tier
The sheet has a Risk Tier column: High, Medium, Low. Each tier should become its own cohort.
Read columns A and B where column A is user_id and column B is risk_tier. Create three separate Amplitude cohorts: 'High-Churn-Risk Q2', 'Medium-Churn-Risk Q2', and 'Low-Churn-Risk Q2', each containing only the user IDs for that tier. Write the cohort IDs returned by Amplitude into column C next to each tier group.
When you need to filter, deduplicate, upload, and log all in one pass
You want a full audit trail without any manual steps.
Take the user IDs in column A and support ticket counts in column B. Filter to rows where ticket count is 3 or more. Deduplicate by user ID. Upload the filtered list as a new Amplitude cohort named 'High-Churn-Risk Q2 2025'. Write the returned Amplitude cohort ID into cell D1 and the final row count into cell D2.
The pattern: the list preparation and the cohort creation happen in one prompt. You do not export, you do not upload manually, you do not come back to verify the count.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of user IDs, then ask it to create or update an Amplitude cohort from the data. The Amplitude integration is included in every plan. For related workflows, see how to export an Amplitude cohort back into Sheets for enrichment or the Amplitude in Google Sheets overview.