By the numbers
- 20 millioncells is the most a single Google Sheets spreadsheet can hold, or 100 MBGoogle Drive Help, files you can store
- 100tasks a month on Zapier's Free plan; each new row a Zap writes uses oneZapier pricing
- 2requests a minute, and 225 a day, on Klaviyo's campaign and flow reporting endpointsKlaviyo API, Query Campaign Values
- 700columns is the most one Klaviyo list or segment export can includeKlaviyo Help Center, exporting a list or segment
Prices and limits are as published on each vendor's page on the date below. Check them again before you choose a plan.
There is no built-in Klaviyo to Sheets sync
Klaviyo's Help Center has no Google Sheets integration to turn on, and nothing in Klaviyo writes to a spreadsheet by itself. Every working setup uses one of five routes: export a CSV and import it, use an automation tool such as Zapier or Make, pay for a reporting connector, or write an Apps Script that calls Klaviyo's API. Pick by the job. For a one-off list, export a CSV. For new subscribers appearing as rows, use Zapier or Make. For a dashboard of campaign and flow results, use a reporting connector. If someone on the team writes code and you would rather not pay a subscription, use a script.
Export a list or segment to CSV
For a one-off copy of a list, this is the quickest route and it costs nothing. In Klaviyo, go to Audience, then Lists & segments, open the list or segment, choose Manage list (or Manage segment) and select Export to CSV. Choose all properties or pick the ones you need, then select Start Export. The file downloads when it is ready if you keep the page open. Otherwise find it under Settings, Other, Downloads, where it stays for 30 days. An export can hold up to 700 columns: email, phone, profile properties, created and last-active dates, and email and SMS consent status with timestamps. It does not include full event history or list membership. Owners, Admins and Analysts can export, and so can custom roles with the export permission.
Open it in Google Sheets
In Google Sheets, choose File, then Import, upload the CSV and pick whether to create a new spreadsheet or replace a sheet. A spreadsheet holds up to 20 million cells, so a 30-column export fits about 660,000 profiles. Export only the properties you need, not all of them. Two cautions. First, an all-profiles export includes everyone regardless of subscription status, so filter on the consent columns before anyone treats the sheet as a mailing list. Second, the sheet is a copy taken at that moment. It does not update, and it carries personal data outside Klaviyo, so share it with as few people as possible and delete it when the job is done.
Campaign and flow reports to CSV
For results rather than people, Klaviyo exports reports as files too. On the Campaigns tab, open the menu next to View library and choose Export analytics, not the legacy option. The CSV has 29 columns, from Campaign ID to bounce rate. For flows, open the Flows tab, then Options, then Export analytics, with filters for time range and tags, totals by day, week or month and an option to include A/B test variations. Both files can be downloaded again from Settings, Other, Downloads for 30 days. That suits a monthly review. For a report that refreshes itself, use one of the connectors below.
Zapier: each new subscriber as a row
Zapier connects the two apps both ways. For Klaviyo to Sheets, the useful Klaviyo triggers are Profile added to Segment or List, New Profile and New Event. Pair one with the Google Sheets action Create Spreadsheet Row, and map the email, name, consent and any custom properties to columns. A list trigger suits the classic request: every new subscriber to the newsletter list shows up in a sheet the wholesale or customer service team can read. Zapier bills each successful action as a task. The Free plan includes 100 tasks a month and two-step Zaps, so a list that gains more than about three subscribers a day needs Professional, from $19.99 a month billed annually or $29.99 month to month for 750 tasks.
Make: the same flow, priced in credits
Make has Klaviyo modules that watch for new profiles on a list or a segment, new events and new campaigns, and Google Sheets modules that add a row or bulk add rows. A scenario of Watch Profiles on a List, then Add a Row, does the same job as the Zap above. Make's Free plan includes 1,000 credits a month. Paid plans change often, so check Make's pricing page before you pick one. Make is the better fit if your team already runs other scenarios there, or if you want to filter or reshape the data before it reaches the sheet. For one list feeding one sheet, Zapier is usually quicker to set up.
Reporting connectors for dashboards
If the goal is a weekly report, not a list of people, a reporting connector pulls Klaviyo's metrics into Sheets on a schedule. Coupler.io pulls campaigns, flows, segments, forms and profiles, with campaign, flow and form performance reports. Its Free plan refreshes manually only, with 100 rows per run. Starter is $24 a month billed annually, or $32 month to month, with daily refresh and 5,000 rows per run. Windsor.ai lists 114 Klaviyo metrics and 105 dimensions. It has a free plan for one data source, and Basic is $19 a month billed annually, or $23 monthly, with daily syncs. Supermetrics includes Klaviyo among its connectors, with Starter at $44 a month billed yearly for two data sources. Try each one on your own account before you pay, and check which plan includes Klaviyo.
Apps Script: pull it with Klaviyo's API
A script costs nothing beyond time to write it. From a spreadsheet, open Extensions, then Apps Script, and call Klaviyo's API with UrlFetchApp. To list a list's members, use Get List Profiles, GET /api/lists/{id}/profiles, with a private API key in an Authorization: Klaviyo-API-Key header and a revision header. The key needs only the lists:read and profiles:read scopes. Results come back 100 at most per page, so follow the next link until it runs out. That endpoint allows 75 requests a second and 750 a minute. Reports are much slower: Query Campaign Values and Query Flow Values allow 2 requests a minute and 225 a day, so pull one report per run. Add a time-driven trigger to run it every night.
The limits of the script route
Apps Script quotas apply per Google account. A consumer Gmail account gets 20,000 URL Fetch calls a day and 90 minutes of trigger runtime a day. A Google Workspace account gets 100,000 calls and 6 hours. Each run stops after 6 minutes, so a large list has to be read in batches over several runs, saving the cursor in Script Properties. Keep the API key in Script Properties too, never in a cell. Klaviyo's advice on private keys is to treat them like a password: anyone holding the key can use its permissions. A read-only key scoped to lists and profiles limits the damage if it leaks. Finally, log every response status. A script that fails without telling anyone leaves a sheet that looks current but has stopped updating.
Going the other way: Sheets into Klaviyo
Sending a sheet's rows into Klaviyo is a different job, with one rule to get right. Zapier's Google Sheets trigger New Spreadsheet Row pairs with Klaviyo's Subscribe Profile action, and Make has Add or Subscribe Profiles to a List. Choose the subscribe action, not Add Profile to List. Klaviyo's API reference recommends Subscribe Profiles if you are trying to give a profile consent, so treat a profile that was only added as not subscribed. Subscribing also removes earlier unsubscribe, spam-report and user-suppressed flags from the profiles it receives. Send only rows for people who opted in to your marketing, never a whole sheet of contacts. For a one-off file, import a CSV into a list instead, and apply bulk consent only if everyone in it explicitly agreed to it.
Which route to use
If you need one copy of a list today, export a CSV. If a team needs new subscribers in a sheet as they arrive, use a Zap or a Make scenario on the list, and expect to pay once volume passes the free tier. A campaign and flow dashboard calls for a reporting connector, the cheapest one that includes Klaviyo at the refresh rate you need. If you have someone who will maintain code, an Apps Script with a read-only key costs nothing. Whichever you choose, the sheet holds subscriber personal data, so restrict sharing to the people who need it and check the consent columns before anyone emails from it.
Where Veya fits
Veya builds custom signup popups for Shopify stores and sends each consented signup to the Klaviyo list you choose for that form, connected by OAuth. Signups then show up in any sheet you sync from that list. Veya also has two routes of its own that skip Klaviyo. In Settings, Download signups (CSV) exports up to 100,000 signups, with each one's form, consent wording, consent page, UTM source and quiz answers. Cells a spreadsheet would run as a formula are neutralized, since shoppers type these fields. Webhooks post each signup as it happens to an HTTPS endpoint such as a Zapier or Make webhook, signed so the receiver can check it came from Veya, and that can add the row. Webhooks are set up through Veya's API or its agent. They have no dashboard screen yet.
Questions
Does Klaviyo integrate with Google Sheets?
Not directly. Klaviyo has no built-in Google Sheets integration. You can export a list, segment or report as a CSV and import it, connect the two with Zapier or Make, use a reporting connector such as Coupler.io, Windsor.ai or Supermetrics, or write an Apps Script that calls Klaviyo's API.
How do I export a Klaviyo list to Google Sheets?
In Klaviyo, open Audience, Lists & segments, open the list, choose Manage list, then Export to CSV, pick the properties and select Start Export. Then in Google Sheets use File, Import to upload the CSV. Exports can include up to 700 columns, and the file stays under Settings, Other, Downloads for 30 days.
How do I automatically add new Klaviyo subscribers to a Google Sheet?
Use a Zap with the Klaviyo trigger Profile added to Segment or List and the Google Sheets action Create Spreadsheet Row, or a Make scenario with Watch Profiles on a List and Add a Row. Each new subscriber becomes one row. Zapier's Free plan covers 100 tasks a month.
Can I get Klaviyo campaign reports in Google Sheets?
Yes. Export campaign or flow analytics as a CSV from the Campaigns or Flows tab for a one-off report. For a report that refreshes itself, use a connector such as Coupler.io or Windsor.ai, or call Klaviyo's Query Campaign Values and Query Flow Values endpoints from Apps Script. Those endpoints allow 2 requests a minute and 225 a day.
How do I import a Google Sheet into Klaviyo?
For a one-off, download the sheet as a CSV and import it into a Klaviyo list, mapping each column to a property. For new rows as they are added, use Zapier's New Spreadsheet Row trigger with Klaviyo's Subscribe Profile action. Send only people who opted in to your marketing, since subscribing gives the profile email consent.
What API key scopes do I need to read Klaviyo lists from Apps Script?
For Get List Profiles, a private key with lists:read and profiles:read is enough. Reporting endpoints need campaigns:read or flows:read. Use a read-only custom key, store it in Script Properties rather than a cell, and treat it like a password.
Sources
- Klaviyo Help Center, how to export a list or segment to CSV (menu path, 700 columns, Downloads for 30 days)
- Klaviyo Help Center, how to export campaign analytics (29 columns)
- Klaviyo Help Center, how to export flow analytics
- Google Drive Help, files you can store in Google Drive (20 million cells)
- Zapier, Google Sheets and Klaviyo integrations (triggers and actions)
- Zapier pricing (Free 100 tasks; Professional $19.99 annual, $29.99 monthly)
- Make, Klaviyo and Google Sheets integration (modules)
- Make pricing (Free plan 1,000 credits)
- Coupler.io, Klaviyo to Google Sheets (data entities)
- Coupler.io pricing
- Windsor.ai, Klaviyo to Google Sheets (114 metrics, 105 dimensions)
- Windsor.ai pricing
- Supermetrics pricing
- Klaviyo API reference, Get List Profiles (scopes, page size, rate limits)
- Klaviyo API reference, Query Campaign Values (2 a minute, 225 a day)
- Klaviyo API reference, Query Flow Values
- Klaviyo API reference, Add Profiles to List
- Klaviyo API reference, Bulk Subscribe Profiles
- Klaviyo Help Center, how to manage private API keys
- Google Apps Script, quotas for Google services
Figures checked November 16, 2026.