Klaviyo campaign and flow data in Google Sheets, refreshed on a schedule
Opens, clicks and conversions for your campaigns and flows, current before you open the file.
30 days of Plus, free from sign-up. No card needed.
What you can pull from Klaviyo
Yesterday's sends, already in the tab
Klaviyo, written to Campaign performance
- Each report owns a tab, and everything in it is replaced on every refresh. Nothing else in the spreadsheet is touched.
Setting up the Klaviyo Google Sheets integration
- In Klaviyo, create a private API key with read access, then paste it on the Sources page.
- Pick campaign or flow performance, the fields you want, and the event that counts as a conversion.
- Choose the tab, worksheet or table it writes to, and how often it refreshes.
Try it with your own Klaviyo data.
Other ways to do it
Klaviyo can export campaign and flow analytics as a CSV file.
Source: Klaviyo Help: Export campaign analytics; Klaviyo Help: Export flow analytics
Fresh Sheets writes the figures straight into your tab instead.
What it can see, and what it cannot
Fresh Sheets needs read access to accounts, campaigns, flows and metrics, and checks the key before saving it.
Our code only ever reads from Klaviyo, even if your key allows more, and refuses any request to Klaviyo that is not a read before the request is sent.
The key is stored encrypted. Remove it any time on the Sources page; delete it in Klaviyo yourself.
Fresh Sheets never changes anything you did not ask it to.
Your data is never sold and never used to train anything.
How we handle your dataStart on Plus, and decide later
Then one report keeps refreshing weekly.
How often depends on your plan: every day on Plus, every 6 hours on Pro and every hour on Max.
Questions
Can you export Klaviyo data to Google Sheets?
Yes, on a schedule, without the file being open.
What counts as a conversion?
The event you choose, report by report, from the events your Klaviyo account records. If nothing in your account looks like a purchase, Fresh Sheets asks you to choose rather than picking one for you.
Which dates does a report cover?
Campaigns and flows sent in the date range you choose, counted in UTC days.
How often can it refresh?
Daily on Plus, every 6 hours on Pro and every hour on Max. On Free, one report refreshes weekly.
How many rows can a report have?
Up to 1,000 rows a run. A report that would return more stops at 1,000 and tells you how to bring it under, and nothing is written for that run.
Set up your first Klaviyo report
30 days of Plus, free from sign-up. No card needed.