Import Visual Website Optimizer (VWO) Data to Google Sheets

Import Visual Website Optimizer (VWO) Data to Google Sheets

Last Updated On August 16, 2019
You are here:
< Back

Visual Website Optimiser (VWO) is a platform for A/B testing and site optimization. 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 for Google Sheets. 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 URL


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}
  • Endpoint 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:

  • Account ID: check the top of the page while logged in to your VWO account:
    vwo-api-img5
  • Campaign ID: click into the test you’re interested in and check its ID in the URL:
    vwo-api-img6
  • PART 3: ENTER VALUES INTO API CONNECTOR


    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.