The Scenario
You are a product manager. Your growth team built a behavioral cohort in Amplitude called 'Power Users' — 2,400 users who triggered a specific combination of events in the last 30 days. You need to export this cohort into an Excel workbook, add a column calculating the next outreach date based on each user's last-seen timestamp, and hand the enriched list to the CRM team.
The slow version:
- Open Amplitude, navigate to Cohorts, find 'Power Users'
- Export to CSV — Amplitude queues the export and emails you a download link
- Wait for the email, download the file
- Open the Excel workbook, paste 2,400 rows into the Cohorts tab, fix date formatting (Excel interprets Amplitude timestamps as text)
- Add a formula in a new column to calculate next-outreach-date
- Two hours later than you planned.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to Amplitude and writes cohort data directly into your workbook tab — no export queue, no email, no CSV.
Open the SheetXAI sidebar and type:
Download my 'Power Users' cohort from Amplitude. Paste user IDs into column A and last_seen dates into column B of the Cohorts tab starting at row 2. Add a header row. Calculate next outreach date as last_seen plus 14 days and write it into column C formatted as YYYY-MM-DD.
SheetXAI pulls the cohort from Amplitude, writes the data into the Cohorts tab, and calculates the outreach dates. The CRM team gets the enriched workbook without you pasting anything.
What You Get
An enriched cohort table in the Cohorts tab:
- Column A — Amplitude user IDs, 2,400 rows
- Column B — last_seen timestamps from the cohort definition
- Column C — calculated next-outreach date (last_seen + 14 days), formatted as YYYY-MM-DD
- Row 1 — headers: user_id, last_seen, next_outreach_date
The outreach date is calculated from the actual Amplitude timestamp. If a user was last seen on April 29, their outreach date is May 13 — not estimated.
Need extra properties? Tell SheetXAI to include country and plan_type in additional columns. The same prompt shape handles it.
What If the Data Is Not Quite Ready
Cohort exports from Amplitude often need shaping before they are useful for CRM work. SheetXAI handles the transformation in the same prompt.
When the cohort includes properties you do not need
Amplitude exports every property available. You only want user_id, country, and plan_type.
Export my 'Power Users' cohort from Amplitude — include only user_id, country, and plan_type. Paste into the Cohorts tab starting at row 2 with a header row. Drop all other properties.
When users with a missing last_seen date should be skipped
Some users in the cohort have a null last_seen value.
Download my 'Power Users' cohort from Amplitude into the Cohorts tab. In column C, calculate next outreach date as last_seen plus 14 days. If last_seen is null or missing, write "SKIP — no last seen date" in column C instead.
When the outreach date depends on plan tier
Enterprise users get 7 days, growth users get 14 days, starter users get 21 days.
Download my 'Power Users' cohort from Amplitude into the Cohorts tab. Include user_id, plan_type, and last_seen. In column D, calculate next outreach date: 7 days for Enterprise, 14 days for Growth, 21 days for Starter. Format as YYYY-MM-DD.
When you need the cohort, enrichment, and a prioritized send-order all in one pass
The CRM team wants the list sorted by outreach urgency, not by user ID.
Download my 'Power Users' cohort from Amplitude. Include user_id, plan_type, country, and last_seen. Calculate next_outreach_date in column E using the plan-tier logic: 7 days for Enterprise, 14 days for Growth, 21 days for Starter. Sort by next_outreach_date ascending so the most urgent outreaches appear first. Write the result into the Cohorts tab starting at row 2 with a header row.
The pattern: the cohort export and the enrichment happen in one prompt. You hand the CRM team a sorted, enriched, formatted workbook — not a raw Amplitude CSV.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull any named Amplitude cohort with whatever properties and calculated columns your workflow needs. The Amplitude integration is included in every plan. For related workflows, see how to upload a list to Amplitude as a new cohort or the Amplitude in Excel overview.