Automated BuiltWith Tech Stack Discovery to Trello Lead Cards - n8n Workflow

• Sales Development Representatives (SDRs) and BDRs needing qualified lead data.
• Marketing teams performing competitive analysis or ICP verification.
• n8n Automation Specialists seeking proven n8n templates for CRM integration.
• Researchers needing to quickly analyze a large list of domains.

This automation solves the tedious task of manually researching the technology stack of potential leads. By leveraging the power of n8n, this n8n workflow connects three essential tools: Google Sheets (input list), BuiltWith (data source), and Trello (sales pipeline). The system automatically processes hundreds of domains, extracts crucial technical indicators (like the primary CMS or framework), and organizes them into immediate, actionable lead cards in Trello. Using this n8n workflow ensures your outreach efforts are highly targeted based on specific technology usage.

This powerful n8n workflow is initiated by a manual n8n trigger, though it can easily be configured to run on a schedule.

1. Data Ingestion: The workflow starts with the Manual Trigger n8n node, which is followed immediately by the Google Sheets n8n node. This node reads the list of target domains from a designated column in your source Google Sheet.


2. External Data Fetching: For every domain item retrieved, the workflow executes an HTTP Request n8n node configured to connect to the BuiltWith API. This step fetches the detailed technology stack associated with that specific domain.


3. Data Transformation and Filtering: The output from BuiltWith is a complex JSON object. A custom Code n8n node is used to parse this response, extracting only key fields: Technology, Category, First Detected, Last Detected, Domain, and URL. This ensures only clean, relevant data proceeds.


4. Pipeline Creation: Finally, the processed data is passed to the Trello n8n node. This node automatically creates a new card in a specified Trello board/list. The card description is dynamically populated with the extracted technology details, effectively moving a prospect from a raw list to an actionable sales lead.

To set up this n8n workflow using these n8n templates, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and import it directly into your n8n instance via the 'Workflows' section by selecting 'New' > 'Import from JSON'.


2. Google Sheets Credentials: The 'Read Domains from Google Sheets' n8n node requires valid Google Sheets OAuth2 credentials. Set up a connection and ensure the service account has read access to the specified domain spreadsheet (1Hs9LcBpC-kaGgDQjkkqBEJzDeAd85RWL1fXTYEdCA).


3. BuiltWith API Key: Locate the 'Fetch detail via BuiltWith' n8n node. Update the query parameter KEY with your actual BuiltWith API key. Note that API usage limits may apply depending on your BuiltWith subscription.


4. Trello Setup: Configure the 'Trello' n8n node with your Trello API credentials. Specify the target Board ID and List ID where the new lead cards should be created.


5. Execution: Once all credentials and configurations are complete, you can test the n8n workflow by clicking 'Execute Workflow'.

The following n8n node components are crucial to the operation of this n8n workflow:

Manual Trigger (n8n trigger): The entry point, used to start the n8n workflow manually for testing or single-run execution. It contains no complex configuration.
Read Domains from Google Sheets (Google Sheets n8n node):
Function: Reads domain names from a spreadsheet to provide the initial data input.
Key Configuration: Reads from Document ID 1Hs9LcBpC-kaGgDQjkkqBEJzDeAd85RWL1fXTYEdCA and sheet name gid=0.
Fetch detail via BuiltWith (HTTP Request n8n node):
Function: Queries the BuiltWith v21 API to retrieve detailed tech stack information for the input domain.
Key Configuration: Uses the expression ={{ $json.Domain }} to dynamically insert the domain name from the previous step into the LOOKUP query parameter.
Extract Tech Stack Info (Code n8n node):
Function: Custom JavaScript used to cleanse and structure the complex BuiltWith API response. It focuses on extracting the first detected technology and its corresponding category, detection dates, domain, and URL.
Key Configuration: Defines an output object containing six structured fields, making the data readable for the subsequent Trello n8n node.
Trello (Trello n8n node):
Function: Creates a new Trello card in a designated board and list using the structured data.
* Key Configuration: The card description is templated using expressions like {{ $json.Technology }} to embed the tech stack details, transforming research data into an actionable lead.