BuiltWith to trello

## ⚙️ **Workflow Overview: Scrape BuiltWith Tech Data and create trello cards**

This automation does three main things:

1. 📥 **Reads domains from Google Sheets**
2. 🌐 **Fetches tech stack data from BuiltWith**
3. 📤 **Create trello cards for scan**

---

## 🧩 **Section 1: Input Collection**

📄➡️📤
**Nodes:**

* `🖱️ Manual Trigger`
* `📗 Read Domains from Google Sheets`

---

### 🔹 What it does:

* The workflow starts **when you click "Test workflow"** (manual trigger). This is useful for testing before setting up a schedule.
* Then it connects to a **Google Sheet**, which contains a list of domains (e.g., `webflow.com`, `shopify.com`) you want to analyze.

### 📚 How it works:

* You’ve connected your Google Sheets account.
* It reads all rows from a specific sheet (e.g., a tab called `Domains`).
* Each row should include at least one column like `Domain`.

### 💡 Beginner Tips:

* Want to analyze other domains? Just paste them into the Google Sheet.
* You can automate this by replacing the manual trigger with a `Cron` node to run every day, week, or month.

---

## 🌍 **Section 2: Tech Stack Lookup**

🔍🌐➡️🧠
**Nodes:**

* `🌐 Fetch Tech Stack from BuiltWith`
* `🧠 Extract Tech Stack Info (Function node)`

---

### 🔹 What it does:

* For each domain, it sends an HTTP GET request to the **BuiltWith API** to fetch that site's detected technologies.
* The **Code (Function)** node then parses the complex response and extracts only what you care about:

  * `Technology` 🛠️
  * `Category` 📦
  * `First Detected` 🕐
  * `Last Detected` ⌛
  * `Domain` 🌐
  * `URL` 🔗

### 🧠 How it works:

* BuiltWith returns a rich JSON structure with all detected tech.
* Your function loops through it and pulls **just one matching technology** per domain (to keep it simple).
* This makes it easy to update a single row in your sheet.

### 💡 Beginner Tips:

* Want **all technologies** per domain? Modify the function to return multiple results per input.
* Make sure to handle **API limits** if you’re processing many domains—add delays using the `Wait` node if needed.

---

# 📊 **Section 3: Create Trello Cards**

📥📝
**Node:**

* `📗 Create Trello Cards with Tech Stack`

---

### 🔹 What it does:

* Takes the extracted data and **create trello cards for scan**.
* Fills in columns like:

  * `Technology`
  * `Category`
  * `First Detected`
  * `Last Detected`
  * `URL`

### ✍️ How it works:

* Provide Due date and member ids


### 💡 Beginner Tips:

* Add more columns like `Confidence`, `Data Source`, or `Notes` if you want to enrich your research.
* Use this sheet for:

  * 💼 Lead qualification
  * 📊 Market analysis
  * 🚀 Tech product targeting

---

## 🎯 Final Thoughts

🔁 This automation turns a **manual and tedious research task** into a repeatable, scalable, and accurate process. By connecting **Google Sheets + BuiltWith + Trello + n8n**, you can:

✅ Automatically analyze websites
✅ Store structured data for marketing or sales
✅ Scale your intelligence gathering with just a few clicks

---