Etsy - export data using JSON

Alternatively, you can use the Coupler.io web interface to set up the connection. Check out how it works in the example of the Stripe to Google Sheets integration.

After that, open your spreadsheet and go to   Add-Ons => Coupler.io => Open Dashboard. Click +Add importer and choose JSON. 

How to import data via Etsy API

To import data using the Etsy API, you need to use a JSON URL that matches a specific category of data you need. Let’s get a list of all data entities you can import. For this, enter the following URL in the JSON URL field of your JSON importer:

https://openapi.etsy.com/v2?api_key={KEYSTRING}

• {KEYSTRING} – insert the KEYSTRING you obtained once created an Etsy app

Click  Save&Run and welcome the data imported from Etsy in Google Sheets.

We’ve got 242 records of data entities or resources as they are called according to Etsy API documentation. However, we are going to use only those that fall under two categories:

• results.http_method – GET (column I)
• results.visibility – Public (column H)

Because GET is the type of requests to fetch data from API and public resources are what we can export with an API key without OAuth authorization.

Use the Google Sheets filter functionality to filter data by these two categories. Click on the Filter button on the toolbar:

After that, the filter icon appears next to the name of each column. Click the icon on the column you want to filter, and select the filter criteria. For example, here is how we filtered out the GET values in the   results.http_method column:

Once we have filtered the values by two criteria (GET and public), we have 97 entities.

One of them is to import all active listings – what we’ve already done when exporting current for sale listings in CSV. Let’s check out how it works.

Import Etsy active listings to Google Sheets

In the   results.uri column, you’ll find the URI to attach to the base Etsy API  URL. 

Base Etsy API URL is:

https://openapi.etsy.com/v2/

Note that there are a few URIs associated with active listings: 

• /shops/:shop_id/listings/active – imports active listings of a certain Etsy shop. You can use the shop name as :shop_id
• /listings/active – imports active listings of the entire Etsy marketplace (you can import the results from all Etsy shops filtered by country, keyword, price, etc.)

So, the JSON URL to import active listings should look as follows:

https://openapi.etsy.com/v2/listings/active?api_key={KEYSTRING}

Let’s import all active listings with the following filters:

• Minimum price – $30
• Maximum price – $40
• Tag – necklace

Here are the parameters you should use in the JSON importer:

We’ve also specified the following destination Sheet Name (where your data will be imported to): “  Active listings price <40 and >30“. Click Save&Run, and there you go!

You can see that some of the results have price values outside of the specified range; for example 27GBP and 285TRY. The default currency is USD, so Etsy can return results in other currencies that correspond to the specified range based on the actual currency rate.

Etsy will return results with a limit of 25 records per page. You can increase this value up to 100 (maximum value) with the help of the “limit: 100” parameter. To get the next records, you need to use the “page:” parameter and specify the page number. 

In our example, to get the next 25 records, we should use the following JSON parameters:

Click  Save&Run, and the next 25 records will be appended to the first imported data set:

Please read our blog post to learn more: Export Data from Etsy.