Domain Technology Stack Finder using Google Sheets - n8n Workflow

Sales and Marketing Teams: Identify prospects using specific e-commerce technologies (e.g., Shopify, Magento) for targeted outreach.
Market Researchers: Gather large datasets on technology adoption rates within specific niches.
Data Analysts: Enrich existing domain lists with structural information and technical metadata.
n8n Users: Anyone looking for advanced web scraping and data processing logic using a custom n8n workflow.

Acquiring accurate market intelligence, especially knowing what technology a potential client uses, is crucial for B2B sales and strategic partnerships. Manually checking hundreds of domains is impossible. This robust n8n workflow solves this by automating the entire process. It pulls raw domain data from Google Sheets, corrects the URL formatting using a dedicated n8n node, then fetches the page HTML. The core logic resides in a sophisticated Code n8n node that uses string and regex pattern matching to detect key indicators for platforms like WooCommerce, Shopify, Magento, along with underlying frameworks (Next.js, React) and specific features (PWA, Checkout). By using this n8n template, you gain actionable intelligence updated directly back into your source Google Sheet, saving immense time and ensuring data consistency.

This n8n workflow operates in a highly efficient sequence to ensure reliable data extraction and polite scraping practices:

1. Trigger and Input: The n8n workflow can be started manually using the 'When clicking 'Execute workflow'' n8n trigger, or automatically on a schedule via the 'Schedule Trigger' n8n node.


2. Data Retrieval: The 'Get row(s) in sheet1' Google Sheets n8n node reads all domain names from the specified spreadsheet and worksheet.


3. URL Standardization: The 'URL Preprocessor' Code n8n node cleans up the input. It checks if the domain has a protocol (like https://) and adds it if missing, ensuring the subsequent HTTP request can be successful.


4. Batch Processing: The 'Split In Batches1' n8n node divides the domains into batches (default 5 items) to manage concurrent requests effectively.


5. Web Scraping: The 'HTTP Request1' n8n node visits each standardized URL and fetches the full HTML content of the page. Crucially, it's configured to continue even on errors (like 404s or timeouts), capturing the error state instead of stopping the entire n8n workflow.


6. Rate Limiting: The 'Rate Limiting Wait1' n8n node introduces a 2-second pause between requests for batch processing, preventing IP bans or server overload.


7. Technology Analysis (The Core): The 'Enhanced Technology Detection1' Code n8n node takes the HTML content and performs deep analysis. It scans for hundreds of known platform, framework, and feature signatures (using regex and string matching). It assigns a Confidence Score and logs specific error types if the scrape failed.


8. Data Writeback: Finally, the 'Update Enhanced Results1' Google Sheets n8n node updates the original Google Sheet rows, matching records based on the original Domain column and writing back the detected Platform, Cart/Checkout status, Framework, Payment Gateway, Confidence Score, and Remarks.

To use this powerful n8n workflow template, follow these steps:

1. Import: Copy the entire JSON code and paste it into your n8n instance using the 'New' menu -> 'Import from JSON'.


2. Google Sheets Setup:

1. Credential Setup: Configure the Google Sheets n8n node credentials. You will need to connect your Google account and grant n8n access to the specific spreadsheet used in this n8n workflow.


2. Configuration: In the 'Get row(s) in sheet1' and 'Update Enhanced Results1' nodes, verify that the 'Document ID' matches your Google Sheet and the 'Sheet Name' is correct.


3. Execution: Run the n8n workflow either manually using the 'Execute Workflow' button or activate the 'Schedule Trigger' to run automatically.

Schedule Trigger / When clicking 'Execute workflow': These act as the n8n trigger points. The Schedule Trigger is set to run hourly, enabling continuous data enrichment.
Google Sheets (Get row(s) in sheet1): This n8n node retrieves all data items from the specified Google Sheet, providing the list of domains for analysis.
Code (URL Preprocessor): Essential data normalization n8n node. It standardizes domain inputs by ensuring they have an https:// protocol prefix and removes trailing slashes, preventing failed HTTP requests.
Split In Batches1: A flow control n8n node set to process 5 items at a time, crucial for managing resource usage and maintaining flow stability when processing large lists.
HTTP Request1: The scraping n8n node. It is configured with retries and a 20-second timeout. Crucially, it converts the response to plain text (html output property) and is set to continue on error, passing error details to the next step.
Wait (Rate Limiting Wait1): Implements a 2-second delay after each batch of HTTP requests. This is a vital n8n node for preventing services from blocking the scraper.
Code (Enhanced Technology Detection1): The intelligence hub. This n8n node analyzes the raw HTML content for proprietary patterns (regex and string includes) to classify the E-commerce platform, frontend framework, and specific site features (cart, checkout, PWA). It handles error conditions passed from the HTTP request and calculates a confidence score.
Google Sheets (Update Enhanced Results1): The final write action n8n node. It uses the Domain column as the matching key to update the corresponding row with the rich metadata generated by the previous Code n8n node.