Hostinger Lead Qualification, Data Extraction, and Beehiiv Sync - n8n Workflow

A Markdown-formatted string describing the ideal user persona.

Marketing teams using Hostinger for lead capture who need automated qualification.
Developers looking for robust n8n templates integrating Gmail, OpenAI, and specialized marketing tools like Beehiiv.
Businesses aiming to streamline lead flow and ensure only qualified prospects reach their CRM or sales pipelines.
Users seeking to overcome Hostinger's limitations in data storage using custom n8n workflow solutions.

This powerful n8n workflow solves a common operational gap for organizations relying on website builders like Hostinger that may lack robust internal form data storage. By employing this efficient n8n automation, you ensure every incoming lead is immediately processed, qualified, and organized. This specific n8n workflow template uses an AI-powered qualification engine (the OpenAI n8n node) to analyze raw form submissions received via email. It extracts all key variables (name, company, project budget) and assigns a crucial qualification status based on pre-defined business rules (e.g., rejecting leads using personal email domains like Gmail or Yahoo, or missing website information). The resulting n8n workflow provides a seamless lead lifecycle that simultaneously adds contacts to a Beehiiv newsletter and logs all details neatly in a Google Sheet. This makes this n8n automation essential for automated lead management.

A step-by-step explanation the logical flow from trigger to final action.

1. Trigger Capture (Gmail n8n trigger): The automation begins with the New form trigger n8n trigger, configured to monitor a specific Gmail inbox for new form submission notification emails originating from the Hostinger sender address.


2. AI Extraction and Qualification (OpenAI n8n node): The raw email body text containing the form data is passed to the Extract & Qualify n8n node, which utilizes the power of OpenAI. This n8n node uses a detailed system prompt to extract all fields and apply custom business logic. It determines the Is Qualified status (true/false) based on rules like requiring a corporate email and a valid website, returning the entire payload as a structured JSON object.


3. Beehiiv Synchronization: The n8n workflow then moves to integrate with the Beehiiv newsletter platform. First, it uses an HTTP Request n8n node (List Beehiiv publications) to retrieve the necessary publication ID.


4. Subscriber Addition: A second HTTP Request n8n node (Add Beehiiv subscriber) uses the extracted email address from the qualification step to automatically subscribe the new lead to the Beehiiv newsletter.


5. Data Logging (Google Sheets n8n node): The final step of this n8n workflow is logging. The insert in Sheets Google Sheets n8n node appends a new row containing all the enriched data—including the crucial Is Qualified status, the Reason for disqualification, Name, Company, and Budget—into a designated Google Sheets spreadsheet, providing a consolidated, searchable log of every lead processed by this n8n automation.

A Markdown-formatted string explaining the installation and credential setup.

1. Import the n8n workflow: Copy the provided JSON code and import it into your n8n instance.


2. Gmail Credential Setup: Update the New form trigger n8n node with your Gmail account credentials. Ensure the filter is correctly set to capture the specific sender email address used by Hostinger for notifications.


3. OpenAI Credential Setup: Connect your OpenAI account API key to the Extract & Qualify n8n node.


4. Beehiiv Credential Setup: Provide the API key for your Beehiiv newsletter account in the two HTTP Request n8n nodes (List Beehiiv publications and Add Beehiiv subscriber). This uses the generic HTTP Header Auth.


5. Google Sheets Credential Setup: Configure the Google Sheets OAuth2 API credentials in the insert in Sheets n8n node. Select the target spreadsheet and the desired sheet name where the lead data will be logged.


6. Activation: Test the full n8n workflow by submitting a test form response on your Hostinger website and then activate the n8n template.

A Markdown-formatted string listing major nodes and configurations.

New form trigger (n8n trigger / Gmail Trigger):
Function: Starts the n8n workflow upon receiving a new Hostinger form email notification.
Key Configuration: Configured to filter emails by the sender address: [email protected].
Extract & Qualify (OpenAI n8n node):
Function: Analyzes the email text, extracts all form variables, and determines lead qualification status using defined rules (e.g., rejecting personal email domains or missing websites).
Key Configuration: Uses gpt-4.1-mini model; enforced jsonOutput: true; system prompt dictates the qualification logic and required JSON structure.
List Beehiiv publications & Add Beehiiv subscriber (HTTP Request n8n node):
Function: Manages the subscription process to the Beehiiv newsletter.
Key Configuration: The second node dynamically injects the extracted email address using an n8n expression: {{ $('Extract & Qualify').item.json.message.content.email }}.
insert in Sheets (Google Sheets n8n node):
Function: Appends the complete, qualified lead data into a Google Sheets document for permanent storage and tracking.
Key Configuration: Operation set to append. All columns (Name, Email, Is Qualified, Reason, etc.) are mapped using expressions linked to the output of the Extract & Qualify n8n node.