Technical project

Building an Order
Intelligence System

Etsy hides customer contact data inside raw transaction email metadata. There's no native CRM, no export, no easy way to know who bought what and when — unless you dig through your inbox manually.

I built an n8n automation workflow to solve this. Every time an order confirmation arrived, the workflow scraped the email metadata, extracted the customer, product, order value, and date — then logged it to a structured Excel sheet and deleted the source email to keep my inbox clean.

I then researched using this data for targeted re-engagement campaigns — sending a thank-you with a promo code tied to the exact product they ordered. I got as far as designing the outreach sequence before I caught it: direct email outreach to Etsy customers violates Etsy's seller policies and anti-spam legislation.

The real lesson: Catching a compliance issue before executing it is more valuable than never having thought of the idea. I documented my findings and moved on.

▶ Walkthrough Video — Coming Soon

Full n8n workflow demo with anonymized order data.
Rebuild in progress — video dropping on YouTube soon.
01
Order Email Received
Etsy sends a transaction confirmation to Gmail inbox with order metadata embedded in raw email body
Trigger: Gmail webhook
02
Parse Email Metadata
n8n scrapes customer email, product name, order value ($), and purchase date from raw email content
Node: Email parser
03
Log to Excel Sheet
Structured row appended to running spreadsheet — building a queryable customer order history over time
Node: Excel / Sheets
04
Delete Source Email
Original transaction email removed from inbox automatically — zero manual cleanup required
Node: Gmail delete
05
Outreach Campaign — Shelved
Designed a re-engagement sequence tied to purchase history. Identified policy conflicts with Etsy ToS and anti-spam law before launch.
Compliance: Not executed

Other experiments

Not everything worked. That's kind of the point.

Ended

AI Website Sales

Tried selling AI-built websites to small businesses via cold calling. Loved the product concept. Hated the cold outreach. Two weeks in, I had read four books on persuasion and sales — and still dreaded every call. Learned that medium and message both matter.

Full story on the blog →
2023

Window Cleaning Business

Joined a former coworker's window cleaning business to help scale it up — handling client outreach, scheduling, and day-to-day operations. My first real taste of entrepreneurship and what it actually takes to build something.

More in About →
Ongoing

Documenting the Journey

Started a YouTube channel to document building in public — the wins, the pivots, the failures. Not polished. Just honest footage of what it actually looks like to figure things out.

Watch on YouTube →