Import Etsy Data to Google Sheets

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

Contents

• Before You Begin
• Part 1: Connect to the Etsy API
• Part 2: Pull Data from Etsy to Sheets
• Part 3: Fetch and Append New Receipts
• Part 4: Create a Custom Request
• Part 5: Handle Pagination
• Part 6: API Documentation

Before You Begin

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

Part 1: Connect to the Etsy API

The easiest way to get started with the Etsy API is through API Connector's built-in integration.

1. Select Etsy from the drop-down list of applications
   
2. Under Authorization, click Connect to Etsy
   
3. You be asked to authorize the connection. Click Grant access
   
4. You’ll then be returned to your Google Sheet, and can verify that your Etsy connection is now active.

Part 2: Pull Data from Etsy to Sheets

Now that we’re connected, let’s pull some data into Sheets.

1. Under Endpoint, choose /shops. This will return your shop ID, which you'll need for subsequent requests.
   
2. Fill in your shop name, select a destination sheet, name your request, and click Run. You'll see your shop ID returned in the results.shop_id field.
   
3. You can now plug this value into other requests. For example, the /shops/{shop_id}/listings endpoint requires the shop ID as a parameter.
   
   

Part 3: Fetch and Append New Receipts

Rather than retrieving the entire data set each time you run your request, you can set your request to fetch new data only. There are a few approaches you could take; here’s one:

1. Create an initial request to the /receipts endpoint. Use the field editor to select just the fields you want and assign them to specific columns in your report.
2. Run the request, sending the response to a sheet called EtsyData.
3. Now in a second sheet, get the maximum (i.e. most recent) created_timestamp from the response data with a formula like =max(EtsyData!Y:Y)+1
   
4. Update your request to reference this cell in the min_created parameter of your request.
   
5. This will ensure that each request starts from the end of the prior data pull. Select Append mode to add each new data pull to the end of your existing dataset.
6. Set your request to run on a schedule. You won’t need to update your request again.

Part 4: Create a Custom Request

Alternatively, you can create a custom request instead of using API Connector’s built-in integration, using any of the endpoints and parameters shown in the API documentation.

Here's an example request setup. Substitute your own store ID where it says your_shop_id.

• Application: Custom
• Method: GET
• Request URL: https://openapi.etsy.com/v3/application/shops/your_shop_id/listings
• OAuth: Etsy

Part 5: Handle Pagination

By default, Etsy limits results to 25 at a time. To get more, set the limit parameter to 100.

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

• Pagination type: offset-limit
• Offset parameter: offset
• Limit parameter: limit
• Limit value: 100
• Run until: choose when to stop fetching data
  

Part 6: API Documentation

Official API documentation: https://developers.etsy.com/documentation/reference