Search API Connector Documentation

Print

Import Etsy Data to Google Sheets

Last Updated On
byAna
< Knowledge Base

In this guide, we’ll walk through how to pull data from the Etsy API directly into Google Sheets, using the API Connector add-on for Sheets. We’ll first get an API keystring from Etsy, and then set up a request to pull in product data from Etsy to your spreadsheet.

CONTENTS

BEFORE YOU BEGIN

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

PART 1: GET YOUR ETSY API KEYSTRING

  1. Log in to Etsy and create a developer account here: https://www.etsy.com/developers/register
  2. In the left-hand sidebar click Create a New App
    etsy-img1
  3. Fill out the information requested and click Create App.
    etsy-img2
  4. You should now see a page containing your Etsy Keystring. Keep this handy as you’ll need it in a moment. Congrats! You’re now ready to use the Etsy API.
    etsy-img3

PART 2: CREATE YOUR API REQUEST URL

We’ll first set up a pull to view a shop’s listings. This can be any public shop on the Etsy platform.

  • Base URL: https://openapi.etsy.com
  • Endpoint: /v2/shops/SHOP_NAME/listings/active
  • Query string: ?api_key=YOUR_KEYSTRING

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

https://openapi.etsy.com/v2/shops/SHOP_NAME/listings/active?api_key=YOUR_KEYSTRING

PART 3: PULL ETSY API DATA INTO SHEETS

Now let’s add our URL into API Connector and import Etsy data into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Open.
  2. In the Create Request tab, enter the Request URL we just created
    etsy-img4
  3. We don’t need any headers so just leave that section as is. We don’t need extra authentication either so just leave Authentication as None.
  4. Create a new tab and click ‘Set current’ to use that tab as your data destination.
  5. Name your request and click Run. A moment later you’ll see Etsy data populate your Google Sheet.
    etsy-img5

PART 4: HANDLE PAGINATION

By default, Etsy limits results to 25 at a time. To get more add &limit=100 to the end of your URL as described in their documentation.

If 100 records is not enough, you can loop through Etsy’s paginated records using the following settings:

  • API Request URL: enter your request as usual, including &limit=100
  • Pagination type: offset-limit
  • Offset parameter: offset
  • Limit parameter: limit
  • Limit value: 100
  • Number of pages: enter the number of pages you’d like to fetch
    etsy-img6

IMPORTANT SECURITY NOTE

Anyone with Owner or Edit access to your Google Sheet can view all the information you’ve saved within API Connector, including API keys and other credentials. Treat these keys as passwords and limit access to your sheet accordingly.

Previous Import Dark Sky Data to Google Sheets
Next Import EventTemple Data to Google Sheets

5 thoughts on “Import Etsy Data to Google Sheets”

  1. I’m very new to this and trying to connect to Etsy.

    I уntered the following data in the “Add Custom OAuth” form:

    Authorization Base URL:
    https://openapi.etsy.com/v2

    Token URL:
    https://openapi.etsy.com/v2/oauth/request_token?scope=email_r

    Client ID:
    azm3uoqeh5glvuaqa1jj9XXX

    Client Secret:
    xsargf6XXX

    Then a page opened in a new tab with the following error:
    “API request missing api_key or valid OAuth parameters”

    How this can be solved? Any help appreciated.

    Here is Etsy page about their OAuth:
    https://www.etsy.com/developers/documentation/getting_started/oauth

    Reply

    • Hi Roman, thanks for the message and sorry you’re having trouble getting connected to Etsy. I checked the Oauth docs you linked and they say Etsy is using the old OAuth 1.0 standard while API Connector uses OAuth 2.0, so that’s probably the issue.

      If you’re just making an app for your personal use, I think you can just use an API key like they describe here: https://www.etsy.com/developers/documentation/getting_started/api_basics

      In that case your request would look like this:
      https://openapi.etsy.com/v2/shops/YOUR_SHOP_NAME/listings/active?api_key=YOUR_KEYSTRING
      You don’t need headers or OAuth2 so just leave those empty.

      Can you please run that URL and let me know how it goes?

      Reply

      • Dear Ana,

        Thank you so much for getting back to me. Your example works, though I need to access my private shop data (receipts), and when I’m making a request like the following:

        https://openapi.etsy.com/v2/shops/MY_SHOP/receipts?api_key=azm3uoqeh5glvuaqa1jj9gf1

        API Connector says “This method requires authentication.”

        It’s a shame if the reason for the auth error is an old version of OAuth at Etsy. Nevertheless, thank you for your help.

        Kindly,
        Roman

  2. hi, great job!
    I ask 2 questions from inexperienced:
    Is it possible, with this tool, to import only orders from etsy to google sheet?
    in the practical configuration phase now I see that the Open API v3 is present, does something change?

    Reply

    • Hey Tobias, now that Etsy v3 is available, we are working on adding an integration for it. Once that’s ready you will be able to import your orders from Etsy to Sheets, but unfortunately it’s not quite available yet. Sorry about that, please check back soon.

      Reply

Leave a Comment

Table of Contents