Send Weekly Klaviyo Flow Revenue to Google Sheets

5 min setup

No coding required

Runs automatically

Klaviyo's dashboards show flow revenue, but copying it into your own reporting every week is tedious and easy to forget. This workflow runs every Monday, asks Klaviyo for last week's Placed Order revenue grouped by the flow it was attributed to, and adds one row per flow to a Google Sheet, so you build a week-by-week history of email revenue without logging in to export anything.

Use this template → Related article

Schedule (Trigger)

Klaviyo Get List of Metrics

Klaviyo Query Metric Aggregates

Loop

Google Sheets Add Row

How it works

5 steps to get last week's Klaviyo flow revenue in a sheet every Monday

App connector: Schedule • Time to complete: 1 minute

Run once a week, for example Mondays at 7am, covering the previous Monday through Sunday.

App connector: Klaviyo • Time to complete: 1 minute

Look up the metric ID for Placed Order, the order metric Klaviyo's Shopify integration records.

App connector: Klaviyo • Time to complete: 1 minute

Query the Placed Order metric for the previous 7 days, measuring sum_value and count, grouped by $attributed_flow, so each result is one flow's attributed revenue and order count.

App connector: Loop • Time to complete: 1 minute

Go through the returned flows one at a time.

App connector: Google Sheets • Time to complete: 1 minute

Add a row with the week start date, the flow ID, attributed revenue, and attributed order count. Add a flow name column by hand once, or look it up with a lookup tab keyed on flow ID.

Trusted by 1,000+ merchants

Ready to get last week's Klaviyo flow revenue in a sheet every Monday

Get setup in 5 minutes.

Use this template →

FAQs

Does this change how Klaviyo attributes revenue?

No. It reads whatever attribution window and model your Klaviyo account is set to use and copies the result. If you change those settings, rows from before and after the change aren't directly comparable, so note the date in the sheet.

Can I get campaign revenue as well as flow revenue?

Yes. Add a second Query Metric Aggregates step grouped by $attributed_message instead of $attributed_flow and write those results to a second tab.

Why group by flow and not by email?

Flows run continuously, so a weekly total per flow is a stable number you can trend. Campaigns are one-off sends, which is why the campaign version works better as its own tab.

Personalize this template

Customize this workflow even further:

Compare against Shopify revenue

Add a Shopify Get List of Orders step for the same week and log total store revenue in the same row, so you can see email's share at a glance.

Email the summary

Add an email step after the loop that sends the week's totals to your team, so nobody has to open the sheet.

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

Rothy's

get last week's Klaviyo flow revenue in a sheet every Monday

5 min setup • Fully supported if you need help