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.
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.
Step 2: In the Account page, click Settings. A list of items will appear below it. Select API Keys.
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.
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:
You can type the label for the selected API key, and then click Save Label.
Finally, to copy the key, click the eye icon beside it, and the key will appear that you can copy.
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:
After downloading the add-on, the API Connector sidebar appears as follows:
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.
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.
The data will be loaded to the sheet.
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.
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.
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.
The data is now loaded to your spreadsheet.
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.
Related Articles
-Google Sheets Add-Ons for Importing Data
-Import Shopify to Google Sheets
-Import Mailchimp to Google Sheets
-Import Salesforce to Google Sheets
-Google Sheets Import Functions
