Search API Connector Documentation

Print

Import Visual Website Optimizer (VWO) Data to Google Sheets

In this guide, we’ll walk through how to pull data from the Visual Website Optimizer (VWO) API directly into Google Sheets, using the 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.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your VWO 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 VWO API Request

We’ll first get the details of a specific VWO campaign.

  • VWO base URL: https://app.vwo.com/api/v2/
  • Endpoint: /accounts/YOUR_ACCOUNT_ID/campaigns/YOUR_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

Just substitute in your own values for YOUR_ACCOUNT_ID and YOUR_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: Pull VWO API Data into Sheets

Now let’s copy our URL into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Open.
  2. In the Create screen, 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:
    tokenYOUR_API_TOKEN
    vwo-api-img7
  3. Name your request and click Run. A moment later you’ll see VWO data populate the the VWO tab:vwo-api-img8

     

Part 4: API Documentation

Official API documentation: https://developers.vwo.com/v3/reference

Previous Import Vimeo Data to Google Sheets
Next Import WazirX Data to Google Sheets

Leave a Comment

Table of Contents