Import Visual Website Optimizer (VWO) Data to Google Sheets – Step by Step Guide

Import Visual Website Optimizer (VWO) Data to Google Sheets – Step by Step Guide

Last Updated On June 02, 2019
You are here:
< Back

In this guide, we’ll walk through how to pull data from the Visual Website Optimizer (VWO) API directly into Google Sheets, using the free API Connector add-on. We’ll first get an API token from VWO, and then set up a request to pull in AB test details from your VWO account to your spreadsheet.

PART 1: GET YOUR VWO DATA API TOKEN


VWO requires that all API requests contain an API token. This is the step-by-step process to get your VWO API token.

  1. Log in to your VWO account and click the ‘Developers’ tab in the footer
    vwo-api-img1
  2. From the VWO Developer Dashboard section, click on the Tokens tab
    vwo-api-img2
  3. Click on Add another API token
    vwo-api-img3
  4. Enter the token name, select the permission type and click “GENERATE”. This will produce your API token. Congrats, you can now make API requests! Copy it to your clipboard as we’ll need it shortly:
    vwo-api-img4

PART 2: CREATE YOUR API REQUEST


We’re going to follow the VWO API documentation to get the details of a specific VWO campaign.

VWO base URL: https://app.vwo.com/api/v2/

Endpoint: /accounts/{account_id}/campaigns/{campaign_id}
Example: /accounts/12345/campaigns/13

Putting it all together, we get the full API Request URL:
https://app.vwo.com/api/v2/accounts/12345/campaigns/13

Of course, you’ll need to substitute in your own values for {account_id} and {campaign_id}, which you can find as follows:
* Find your account ID by checking the top of the page while logged in to your VWO account:
vwo-api-img5
* Find your campaign ID by clicking into the test you’re interested in and checking its ID in the URL:
vwo-api-img6

We’re now ready to enter all our values into API Connector to start importing VWO data into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
  2. In the Create Request interface, enter the Request URL we just created. Add the API token from part 1 into the Headers section, using a key-value pair like this:
    token{your API token}

    vwo-api-img7

  3. Name your request. Again we’ll call it ‘VWO’
  4. Click Run and a moment later you’ll see VWO data populate the the VWO tab:
    vwo-api-img8

Following the above steps, you will now be able to import data from the VWO API directly into Google Sheets.

Comments:0

Leave a Reply

Your email address will not be published.