Import Loyverse Data to Google Sheets

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

We'll first get an API token from Loyverse, and then set up a request to pull in metrics to your spreadsheet.


Before You Begin

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

Part 1: Get Your Loyverse API Token

  1. Log in to Loyverse and navigate to the Integrations page
  2. Click +Add Access Token
  3. Name your token, optionally choose an expiration date, and click Save
  4. Your token will be provided on the next page. Copy it and keep it safe; we'll use it shortly.

Part 2: Pull Loyverse API Data into Sheets

You can access any of the endpoints and parameters listed in the API documentation.  Here's an example request setup showing how to fetch customers from your account. Substitute in your token where it says your_token.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URL
    • OAuth: None
    • Headers:
      • AuthorizationBearer your_token
  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 Loyverse data populate your sheet.

Part 3: API Documentation

Official API documentation:

Leave a Comment

Jump To