Search API Connector Documentation

Print

Import EventTemple Data to Google Sheets

In this guide, we’ll walk through how to pull data from the EventTemple API directly into Google Sheets, using the API Connector add-on for Sheets.

We’ll first get an API key from EventTemple, and then set up a request to pull in data to your spreadsheet.

Contents

Before You Begin

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

Part 1: Get Your EventTemple API Key

  1. Sign in to EventTemple and navigate to Settings > Integrations > API (or click here: https://app.eventtemple.com/settings/integrations/api)
  2. Click New API Token
  3. A new token will be generated for you, copy it to your clipboard.
  4. We also need your Organization ID. Get this from your current organization settings, at the top of the page, or from your organization list.
  5. Once you have your API token and Organization ID, you’re all set! You can now connect to EventTemple’s API.

Part 2: Create Your API Request URL

We’ll first pull a list of your events.

  • Base URL: https://api.eventtemple.com
  • Endpoint: /v2/events

Putting it all together, we get the full API Request URL:

https://api.eventtemple.com/v2/events

Part 3: Pull EventTemple API Data into Sheets

We can now enter that URL into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Open.
  2. In the Create Request tab, enter the Request URL we just created
    eventtemple-url
  3. We don’t need extra authentication so just leave OAuth as None.
  4. Under Headers, enter 2 sets of key-value pairs:
    X-Api-Org: YOUR_ORG_ID
    X-Api-Key: YOUR_API_KEY
    eventtemple-headers
  5. Create a new tab and click Set current to use that tab as your data destination.
  6. Name your request and click Run. A moment later you’ll see EventTemple data populate your sheet.
    eventtemple-results

Part 4: More Example API URLs

  • https://api.eventtemple.com/v2/activities
  • https://api.eventtemple.com/v2/bookings
  • https://api.eventtemple.com/v2/revenue_categories

Part 5: Handle Pagination

  1. EventTemple limits the number of records returned on a response. By default, not all records will be returned unless you page through data as shown in their documentation.
  2. With API Connector you can loop through these URLs automatically with pagination handling (paid feature), like this:
    • API URL: enter your request URL as usual, including page[size]=100
    • Pagination type: page parameter
    • Page parameter: page[number]
    • Run until: choose when the request should stop running.
      eventtemple-pagination-page

Part 5: API Documentation

Official API documentation: https://eventtemple.github.io/api-docs/#introduction

Previous Import Etsy Data to Google Sheets
Next Import Facebook Ad Data to Google Sheets

Leave a Comment

Table of Contents