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: Pull EventTemple API Data into Sheets

For this example, we'll get a list of events.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URLhttps://api.eventtemple.com/v2/events
    • Headers:
      • X-Api-Org: your_org_id
      • X-Api-Key: your_api_key
        eventtemple-headers
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see EventTemple data populate your sheet.
    eventtemple-results

Part 3: More Example API URLs

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

Part 4: 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, 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

Leave a Comment

Jump To