Automate Etsy Sales Data using Integromat

Updated: Dec 25, 2021




Overview

As a small business owner, you might need to know which product performs well, who your customers are and where they order from. You might need customized reporting that ETSY cannot provide. For which you need the ETSY Sales Data in a usable format. With Integromat , you can extract these data into a spreadsheet or google sheet with which you can do a number of reporting or analysis.

These reports might also help you target ads on you own domain and reduce the dependency on ETSY. In this article, lets explore how you can automate Etsy sales data to a google sheet.


The Basics

What is Integromat?

Integromat is a no-code integration tool. It lets you connect applications and automate data flow between applications without having to write any code.

What is ETSY?

Etsy is an e-commerce marketplace for unique, customized, handmade, and creative goods. As a seller you can sell any unbranded handmade products right from vintage goods to handcrafted arts.


Prerequisites

  1. Etsy Shop - You must have a seller account, preferably with at least one sale.

  2. Integromat Account - It has a “always free” plan to get started.

  3. Google Sheet template with all the columns needed from Etsy. Here is a template you can download.


The Architecture

I highly recommend you to watch this video if you are a newbie to Integromat. Integromat Tutorial for Beginners 2021 - YouTube

Integromat is a no code integration solution and its fairly easy to use. So instead of going into the details of “How's”, I'll explain the what's

Behind the scenes Integromat uses ETSY Receipts API (Receipt - Etsy Developers ) It caches the last receipt and every time the flow executes, it pulls in a fresh list of new receipts from your shop. If thats a lot, the good part is you don't have to worry about it. However, if you a techie keep going.

So based on my design, we watch the receipts, and once we get a receipt, ie. a sales receipt, we read the receipt, get the transaction number.