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.

schedule icon
Schedule (Trigger)
Klaviyo Get List of Metrics
Klaviyo Query Metric Aggregates
Loop
google sheets logo icon
Google Sheets Add Row

How it works

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

schedule icon

Schedule (Trigger)

App connector: Schedule • Time to complete: 1 minute

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

Klaviyo Get List of Metrics

App connector: Klaviyo • Time to complete: 1 minute

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

Klaviyo Query Metric Aggregates

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.

Loop

App connector: Loop • Time to complete: 1 minute

Go through the returned flows one at a time.

google sheets logo icon

Google Sheets Add Row

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
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

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.

You're in good company

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

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

5 min setup • Fully supported if you need help