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 Google Sheets, 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 Google Sheets, paste 2,400 rows, fix date formatting
- Add a formula in a new column to calculate next-outreach-date (last_seen + 14 days)
- Send the enriched file to the CRM team
- Two hours later than you planned.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to Amplitude through its built-in integration and writes cohort data directly into your sheet — 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 starting at row 2. Add a header row. Then calculate the next outreach date as last_seen plus 14 days and write it into column C. Format column C as YYYY-MM-DD.
SheetXAI pulls the cohort from Amplitude, writes the user IDs and timestamps, calculates the outreach dates, and formats everything cleanly. The CRM team gets the enriched list without waiting for you to paste anything.
What You Get
An enriched cohort table, ready for CRM upload:
- 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, not estimated. If a user was last seen on April 29, their outreach date is May 13 — not a rounding approximation.
Need to include extra properties? Tell SheetXAI to add country and plan_type as 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. 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 for the CRM upload.
Export my 'Power Users' cohort from Amplitude — include only user_id, country, and plan_type columns. Paste into this sheet starting at row 2. Add 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. You do not want to calculate an outreach date for them.
Download my 'Power Users' cohort from Amplitude into this sheet. 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. Do not calculate a date for those rows.
When the outreach date depends on plan tier
Enterprise users get a 7-day follow-up, growth users get 14 days, starter users get 21 days.
Download my 'Power Users' cohort from Amplitude. Include user_id, plan_type, and last_seen. In column D, calculate next outreach date: 7 days from last_seen for plan_type '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 the rows by next_outreach_date ascending so the most urgent outreaches appear first. Write the result starting at row 2 with a header row.
The pattern: the cohort export and the enrichment happen in the same prompt. You hand the CRM team a sorted, enriched, formatted sheet — not a raw Amplitude CSV.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, 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 back to Amplitude as a new cohort or the Amplitude in Google Sheets overview.