How to Import Klaviyo Data to Google Sheets

Discover how to import Klaviyo data into Google Sheets and harness the power of both platforms in your data analysis.

Table of Contents
  1. How to generate API key from Klaviyo
  2. Import Klaviyo data using add-ons (API Connector)
  3. Import Klaviyo data using Lido

Table of contents
Chapter 1
Chapter 2
Chapter 3
  1. How to generate API key from Klaviyo
  2. Import Klaviyo data using add-ons (API Connector)
  3. Import Klaviyo data using Lido

6 Minutes

Klaviyo is one of the major platforms for conducting targeted marketing campaigns across email, SMS, ads, and other channels. Through these campaigns, Klaviyo gathers invaluable data for assessing the success of your marketing campaigns  alongside the resulting growth in your other business metrics. Therefore, if you are using Klaviyo for your marketing campaigns, you should be able to import Klaviyo data to your Google Sheets. Are you ready?

How to generate an API key from Klaviyo

Just like other eCommerce and marketing platforms we featured here, you can access Klaviyo through its API. Here are the steps to generate an API key:

Step 1: Click your profile name on the upper-right corner of the dashboard. A drop-down list will appear. Select Account.

Klaviyo dashboard
Klaviyo dashboard

Step 2: In the Account page, click Settings. A list of items will appear below it. Select API Keys.

Account settings, API Keys highlighted
Account settings, API Keys highlighted

Step 3: On the API page, you will find a single public API that you can use for tracking people and events via JavaScript, and a list of private API keys. For this tutorial, we need a private API key. Click Create Private API Key to generate one. 

Create Private API Key button highlighted
Klaviyo dashboard, Account Settings, API Keys, Create Private API Key button highlighted

A new private API will appear on the list. If you want to maintain a set of private keys, you can create several private keys, one for each application. You can label them by clicking the pencil icon besides the No label along the row where the API key is listed:

List of private API keys, label rename icon highlighted
List of private API keys, label rename icon highlighted

You can type the label for the selected API key, and then click Save Label.

Update API Key Label box
Update API Key Label box

Finally, to copy the key, click the eye icon beside it, and the key will appear that you can copy. 

List of private API keys, view API key icon highlighted
List of private API keys, view API key icon highlighted

Import Klaviyo data using add-ons (API Connector)

One convenient way to import Klaviyo data is via Google Sheets add-ons. These add-ons can be used to extend the capability of Google Sheets; one of the capabilities missing from Google Sheets is the ability to import data from different eCommerce and marketing platforms. 

We have already published a rundown of popular Google Sheets add-ons for importing data from different eCommerce and marketing platforms. For this tutorial, we will use API Connector, one of the add-ons featured in the above article:

API Connector
API Connector

After downloading the add-on, the API Connector sidebar appears as follows:

API Connector UI
API Connector UI

You will need the URL and the API Key that we generated in the previous section. The Request URL has the following syntax:

https://a.klaviyo.com/api/v2/lists?api_key=private_api_key

Where private_api_key is the API key generated in the previous section. The request URL is usually enough information.

API Connector with Request URL added
API Connector with Request URL added

After specifying the API key, specify the output settings. If the active sheet is your target destination sheet, simply click the Set current option, and the name of the active sheet will appear. Finally, give the request an appropriate name before clicking Run.

API Connector output settings
API Connector output settings

The data will be loaded to the sheet.

Google Sheets with Klaviyo data imported using API Connector
Google Sheets with Klaviyo data imported using API Connector

Import Klaviyo data using Lido

While you can use Google Sheets add-ons to import your Klaviyo data, we want to present a better option: Lido. Rather than importing all of the data, Lido allows you to choose what data you want to import through its built-in integration with Klaviyo. From there, creating custom dashboards and apps is a breeze for non-technical teams.Here are the steps:

Step 1: In a Lido spreadsheet, click Data on the upper-left corner of Lido. A list of sources will appear. Scroll down to find Klaviyo. You also find an option to either import Campaigns data or the Profiles data.

Lido spreadsheet, Data sidebar with a list of sources
Lido spreadsheet, Data sidebar with a list of sources

Step 2: Once you have made a choice, you will be prompted to add the API key to access your data, which we generated in the first part of this tutorial. Click Connect afterwards.

Data sidebar, Klaviyo API Key textbox
Data sidebar, Klaviyo API Key textbox

Step 3: The Dataset Editor will appear. The list of columns in the dataset appears on the left side. Select which columns you want to include in your import. The preview will update as you select individual columns. Once you are done, click Save dataset & edit view in the top right corner

Dataset Editor with list of columns and preview of selected columns
Dataset Editor with list of columns and preview of selected columns

The data is now loaded to your spreadsheet.

Lido spreadsheet with imported Klaviyo data
Lido spreadsheet with imported Klaviyo data

As you can see, the main advantage of Lido is that you do not need an intimate knowledge of the structure of Klaviyo data that you can access via an API. As long as you have a valid API, you can import all of the Klaviyo data that you need!

Interested? Click here to get started.

References

Getting Started with Klaviyo APIs 

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

July 31, 2022

Chart with arrows pointing up and down

Klaviyo is one of the major platforms for conducting targeted marketing campaigns across email, SMS, ads, and other channels. Through these campaigns, Klaviyo gathers invaluable data for assessing the success of your marketing campaigns  alongside the resulting growth in your other business metrics. Therefore, if you are using Klaviyo for your marketing campaigns, you should be able to import Klaviyo data to your Google Sheets. Are you ready?

How to generate an API key from Klaviyo

Just like other eCommerce and marketing platforms we featured here, you can access Klaviyo through its API. Here are the steps to generate an API key:

Step 1: Click your profile name on the upper-right corner of the dashboard. A drop-down list will appear. Select Account.

Klaviyo dashboard
Klaviyo dashboard

Step 2: In the Account page, click Settings. A list of items will appear below it. Select API Keys.

Account settings, API Keys highlighted
Account settings, API Keys highlighted

Step 3: On the API page, you will find a single public API that you can use for tracking people and events via JavaScript, and a list of private API keys. For this tutorial, we need a private API key. Click Create Private API Key to generate one. 

Create Private API Key button highlighted
Klaviyo dashboard, Account Settings, API Keys, Create Private API Key button highlighted

A new private API will appear on the list. If you want to maintain a set of private keys, you can create several private keys, one for each application. You can label them by clicking the pencil icon besides the No label along the row where the API key is listed:

List of private API keys, label rename icon highlighted
List of private API keys, label rename icon highlighted

You can type the label for the selected API key, and then click Save Label.

Update API Key Label box
Update API Key Label box

Finally, to copy the key, click the eye icon beside it, and the key will appear that you can copy. 

List of private API keys, view API key icon highlighted
List of private API keys, view API key icon highlighted

Import Klaviyo data using add-ons (API Connector)

One convenient way to import Klaviyo data is via Google Sheets add-ons. These add-ons can be used to extend the capability of Google Sheets; one of the capabilities missing from Google Sheets is the ability to import data from different eCommerce and marketing platforms. 

We have already published a rundown of popular Google Sheets add-ons for importing data from different eCommerce and marketing platforms. For this tutorial, we will use API Connector, one of the add-ons featured in the above article:

API Connector
API Connector

After downloading the add-on, the API Connector sidebar appears as follows:

API Connector UI
API Connector UI

You will need the URL and the API Key that we generated in the previous section. The Request URL has the following syntax:

https://a.klaviyo.com/api/v2/lists?api_key=private_api_key

Where private_api_key is the API key generated in the previous section. The request URL is usually enough information.

API Connector with Request URL added
API Connector with Request URL added

After specifying the API key, specify the output settings. If the active sheet is your target destination sheet, simply click the Set current option, and the name of the active sheet will appear. Finally, give the request an appropriate name before clicking Run.

API Connector output settings
API Connector output settings

The data will be loaded to the sheet.

Google Sheets with Klaviyo data imported using API Connector
Google Sheets with Klaviyo data imported using API Connector

Import Klaviyo data using Lido

While you can use Google Sheets add-ons to import your Klaviyo data, we want to present a better option: Lido. Rather than importing all of the data, Lido allows you to choose what data you want to import through its built-in integration with Klaviyo. From there, creating custom dashboards and apps is a breeze for non-technical teams.Here are the steps:

Step 1: In a Lido spreadsheet, click Data on the upper-left corner of Lido. A list of sources will appear. Scroll down to find Klaviyo. You also find an option to either import Campaigns data or the Profiles data.

Lido spreadsheet, Data sidebar with a list of sources
Lido spreadsheet, Data sidebar with a list of sources

Step 2: Once you have made a choice, you will be prompted to add the API key to access your data, which we generated in the first part of this tutorial. Click Connect afterwards.

Data sidebar, Klaviyo API Key textbox
Data sidebar, Klaviyo API Key textbox

Step 3: The Dataset Editor will appear. The list of columns in the dataset appears on the left side. Select which columns you want to include in your import. The preview will update as you select individual columns. Once you are done, click Save dataset & edit view in the top right corner

Dataset Editor with list of columns and preview of selected columns
Dataset Editor with list of columns and preview of selected columns

The data is now loaded to your spreadsheet.

Lido spreadsheet with imported Klaviyo data
Lido spreadsheet with imported Klaviyo data

As you can see, the main advantage of Lido is that you do not need an intimate knowledge of the structure of Klaviyo data that you can access via an API. As long as you have a valid API, you can import all of the Klaviyo data that you need!

Interested? Click here to get started.

References

Getting Started with Klaviyo APIs 

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.