The Scenario
You are a product analyst. The new quarter starts Monday and you have been asked to present a platform and geographic breakdown of the user base at the kickoff meeting. The head of product wants to know: how is the user base distributed across iOS, Android, and Web, and which countries are the top five in each platform?
The data is in Amplitude's User Composition view. The kickoff deck needs a Google Sheet with a stacked bar chart and a supporting breakdown table.
The slow version:
- Open Amplitude, navigate to User Composition, select platform as the dimension
- Export the CSV
- Go back, switch to country as the dimension, export a second CSV
- Open Google Sheets, paste both exports, reconcile the column structures
- Manually build the cross-tab you actually need
- Build the stacked bar chart
- It is Sunday night and the kickoff is at 9 AM Monday.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to Amplitude's User Composition API and writes both breakdowns into your sheet in the structure you actually need for the chart.
Open the SheetXAI sidebar and type:
Fetch the user composition breakdown by platform from Amplitude for the last 30 days. Write platform name into column A and user percentage into column B. Then fetch the user composition breakdown by country and write the top 10 countries into columns D and E with country name and user percentage. Add header rows for both tables.
SheetXAI calls the Amplitude API twice, lands both tables in the right columns, and adds headers. Your stacked bar chart and supporting table are ready without you touching a CSV.
What You Get
Two clean breakdown tables in one sheet:
- Columns A–B — platform breakdown: iOS, Android, Web with user percentages for the last 30 days
- Columns D–E — top 10 countries by user percentage for the same period
- Headers on both tables
The percentages are from the actual Amplitude user composition data, not estimated from event counts. If 52% of your users are on iOS, that is what column B says.
The stacked bar chart builds from the platform table. The geographic table is the supporting data the product team will drill during the meeting.
What If the Data Is Not Quite Ready
User composition breakdowns often need more shaping than a simple pull. SheetXAI handles the complexity in the same prompt.
When you want the composition split by both platform and country in a cross-tab
The head of product wants to see platform distribution within each country, not just overall.
Fetch user composition from Amplitude for the last 30 days, broken down by both platform and country. Write the result as a pivot-style cross-tab with countries in column A and one column per platform (iOS, Android, Web) showing the user percentage for that country-platform combination.
When you want to compare Q1 and Q2 composition side by side
The kickoff meeting asks whether the platform mix shifted versus last quarter.
Fetch user composition by platform from Amplitude for Q1 2025 and Q2 2025 separately. Write platform names in column A, Q1 percentages in column B, and Q2 percentages in column C. Add a fourth column D showing the change (Q2 minus Q1) for each platform.
When you only want users who are paying subscribers
The product team cares about the paying user base, not all users.
Fetch user composition by platform from Amplitude for the last 30 days, filtered to users with plan_type equal to 'paid'. Write platform name in column A and paying-user percentage in column B. Add a note in cell D1 that this reflects paying subscribers only.
When you need the platform breakdown, geographic breakdown, a quarter-over-quarter delta, and a written summary all in one pass
The kickoff deck needs the tables, the chart, and a paragraph the head of product can read from.
Fetch user composition by platform from Amplitude for Q1 2025 and Q2 2025. Write the Q1 and Q2 percentages and Q2-minus-Q1 delta for each platform in columns A–D. Fetch the top 10 countries by user percentage for Q2 2025 and write them in columns F–G. Then write a two-sentence summary in cell I1 identifying which platform grew the most quarter over quarter and which country moved up the most in the top 10.
The pattern: both breakdowns, the delta columns, and the written summary all happen in one prompt. The kickoff deck is ready before Sunday night.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull Amplitude user composition breakdowns with whatever dimensions and time ranges the meeting requires. The Amplitude integration is included in every plan. For related workflows, see how to pull event segmentation trends or the Amplitude in Google Sheets overview.