The Scenario
You are a growth analyst. Quarterly business review is in three days. Your job is to present the onboarding funnel: five steps, three user segments (by signup source), 90 days of data.
The funnel is in Amplitude. The QBR deck needs a pivot table in Google Sheets with per-step conversion rates and drop-off percentages, formatted so your VP can drill by segment.
The slow version:
- Open Amplitude, navigate to Funnels, configure the five-step onboarding funnel
- Set the date range to 90 days, add the signup-source grouping
- Export the CSV — one file per segment because Amplitude's export does not flatten it cleanly
- Open Google Sheets, create a new tab, paste the first segment, paste the second, paste the third
- Manually calculate drop-off: (step N − step N+1) / step N
- Build the pivot table by hand
- It is now the night before the QBR.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your sheet and queries Amplitude through its built-in integration so you do not have to configure, export, or reconcile a single CSV.
Open the SheetXAI sidebar and type:
Pull the last 90 days of funnel data for my 'Onboarding' funnel in Amplitude grouped by signup source. Paste conversion rates per step into columns B–F with step names in row 1. Put signup source in column A. Then add a calculated drop-off percentage column after each step column showing what percentage of users fell off at that step.
SheetXAI calls the Amplitude Funnel Analysis API, pulls the grouped data for all three segments, writes the pivot structure, and calculates the drop-off columns. You have a presentation-ready table in under a minute.
What You Get
A structured pivot table ready for the QBR:
- Column A — signup source (three rows: the three segments)
- Columns B–F — per-step conversion counts or rates from Amplitude
- Drop-off columns — calculated inline after each step column
- Row 1 — step names pulled from the funnel definition in Amplitude
The drop-off percentages are calculated from the actual Amplitude numbers, not estimated. If step 3 has a 38% drop-off for organic signups and 12% for paid, that is what the table says.
What If the Data Is Not Quite Ready
Funnel data from Amplitude is rarely in the exact shape you need for a business review. SheetXAI handles the restructuring in the same prompt.
When Amplitude returns step names in snake_case
Amplitude event names like onboarding_step_3_completed show up in the export headers verbatim. Your stakeholders want readable names.
Pull the 90-day 'Onboarding' funnel data and write it into the sheet. After writing, rename each step column header from snake_case to Title Case with spaces. For example, 'onboarding_step_1_completed' becomes 'Step 1: Profile Created'.
When leadership wants the funnel split by plan tier instead of signup source
Same data, different grouping.
Fetch funnel data for my 'Checkout' funnel for Q1 2025 from Amplitude, grouped by plan_tier instead of signup source. Paste conversion rates per step in columns B–E. Add a drop-off percentage column after each step. Sort the rows from highest overall conversion to lowest.
When you only want users who entered the funnel after a specific feature shipped
The product team changed the onboarding flow on March 15th. The pre- and post-change data should not be mixed.
Pull funnel data for my 'Onboarding' funnel from Amplitude for March 15 through June 30. Write per-step conversion rates by signup source into the pivot structure. Add a note in cell A1 that the data excludes the pre-March-15 cohort.
When you need drop-off rates, absolute counts, and a written interpretation all in one pass
The QBR deck needs the table plus a paragraph summary the VP can read in the meeting.
Pull 90 days of 'Onboarding' funnel data grouped by signup source. Write the step-by-step conversion counts in columns B–F and conversion rates in columns G–K. Calculate drop-off percentages in the columns after each rate column. Then write a three-sentence interpretation in cell A15 identifying the single highest-drop-off step and which segment struggles most at that step, citing the actual percentage values.
The pattern: instead of pulling the data and drafting the analysis separately, you do both in one prompt. The interpretation references the actual numbers SheetXAI just wrote.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull your Amplitude funnel data with whatever grouping and date range the review requires. The Amplitude integration is included in every plan. For related workflows, see how to compare retention curves for two cohorts or the Amplitude in Google Sheets overview.