The Scenario
You are an email automation strategist at an e-commerce agency. A client has 12 active Klaviyo flows — welcome series, abandoned cart, post-purchase, browse abandonment, sunset, and a handful of behavioral triggers. You need to show them which flows are performing and which are dead weight. That means a single table: all 12 flows, open rates, click rates, revenue per recipient, side by side.
The bad version:
- Log into Klaviyo and navigate to the Flows analytics view, which shows flows one at a time. Click into flow 1, record the metrics, go back, click into flow 2, record, repeat.
- After 12 flows and 12 separate drill-down screens, you have a list of numbers in a scratch doc with no consistent formatting.
- Manually paste them into a Google Sheet, format the decimals to percentages, and add the revenue-per-recipient calculation by hand.
You have done this for six clients this month. The data is always in the same place. The retrieval is always the same grind.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Klaviyo's flow analytics API and writes the multi-flow comparison table directly into the sheet.
Fetch flow analytics values from Klaviyo for all active flows and write flow name, recipients, open rate, click rate, and revenue into this sheet
What You Get
- One row per active flow, all 12 in a single table.
- Columns include flow name, total recipients, open rate, click rate, and revenue attributed.
- Revenue per recipient can be added with a follow-up prompt or a formula — the raw data is there.
What If the Data Is Not Quite Ready
You need a longer lookback than the default
Query Klaviyo flow performance data for the last 90 days and populate columns A through F with flow name, total sends, unique opens, unique clicks, orders, and revenue attributed
You only want flows above a revenue threshold
Fetch Klaviyo flow analytics for all active flows, filter to only flows where revenue is greater than 0, and write flow name, recipients, open rate, click rate, and revenue into this sheet sorted by revenue descending
The client wants to see which flows have the worst open rates relative to their send volume
Fetch Klaviyo flow analytics for all active flows for the last 90 days, write flow name, sends, and open rate into columns A through C, then add a column D that flags any flow where sends are above 500 but open rate is below 20% with the label "REVIEW"
Full flow audit with recommendations in one pass
Fetch Klaviyo flow analytics for all active flows for the last 90 days, populate columns A through F with flow name, sends, open rate, click rate, orders, and revenue; calculate revenue per recipient and write it into column G; flag underperformers (open rate below 15% or revenue below $500 total) in column H; sort by revenue per recipient descending
The client call is about strategy, not about retrieving numbers from 12 different screens.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet for your next client flow review, then ask it to pull all active flow metrics into one table. Also check out how to export campaign performance metrics to compare flow and campaign performance side by side.