AI Proposal Generator from Sheets to Drafts - n8n Workflow

Sales professionals or teams needing to rapidly generate tailored business proposals.
Users familiar with n8n templates and automation seeking to integrate advanced AI models (like Azure's GPT-4o).
Operations specialists looking for a reliable n8n workflow solution to bridge data entry (Sheets) and communication (Gmail).
Developers wanting an example of combining the LangChain AI Agent n8n node with Google and Gmail services.

Generating personalized business proposals is often a bottleneck for sales teams. This advanced n8n workflow solves this by completely automating the process. By leveraging the power of Azure OpenAI (GPT-4o), the n8n workflow reads client details and project requirements directly from a specified Google Sheet. It uses an AI Agent n8n node to generate high-quality, structured proposal content. The flow then ensures the generated text is correctly formatted before automatically creating a draft email in Gmail. This provides a massive boost to productivity, allowing users to review and send pre-written, highly customized proposals rather than starting from scratch. This specific n8n template demonstrates robust data handling and powerful AI orchestration capabilities.

This comprehensive n8n workflow is initiated manually, making it a powerful on-demand generation tool:

1. Trigger and Data Retrieval: The workflow starts with the 'When clicking ‘Execute workflow’' n8n trigger. It immediately connects to Google Sheets via the 'Get row(s) in sheet' n8n node to fetch all relevant client data, including proposal requirements.


2. Conditional Filtering: The 'checks propsal status' If n8n node analyzes the retrieved data, filtering only those rows where a proposal is marked as 'Pending' or otherwise requires generation.


3. Batch Processing: The 'Loop Over Items' n8n node (Split In Batches) ensures that each filtered client record is processed sequentially and individually, preventing token limit issues and maintaining data integrity for the subsequent steps.


4. AI Generation: For each item, the 'AI Agent' n8n node, powered by the 'Azure OpenAI Chat Model' n8n node (likely utilizing GPT-4o), receives the client context. The AI Agent executes instructions to craft a detailed, customized business proposal based on the input columns from the sheet.


5. Data Transformation: The 'Code' n8n node takes the raw output from the AI Agent. This crucial step cleans, structures, and formats the generated proposal text into a ready-to-use email body and subject line. This prepares the data for the final destination.


6. Draft Creation: Finally, the 'Create a draft' Gmail n8n node receives the formatted content and saves the complete, personalized proposal as a new draft in the connected Gmail account. This completes the fully automated n8n workflow.

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

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


2. Google Sheets Setup: Configure the 'Get row(s) in sheet' n8n node. You will need a Google Sheets credential and must specify the Spreadsheet ID and Sheet Name containing your client data. Ensure the column headers match the fields expected by the subsequent AI Agent n8n node.


3. Azure OpenAI Credentials: Set up your Azure OpenAI Service credentials within n8n. The 'Azure OpenAI Chat Model' n8n node requires the API Base URL, API Key, and the Deployment Name (which specifies the model, e.g., gpt-4o).


4. Gmail Credentials: Configure the 'Create a draft' Gmail n8n node with your Gmail credentials. This ensures the n8n workflow has permission to create drafts in your account.


5. Activation: Once all credentials and parameters are configured for every n8n node, activate the n8n workflow and run it using the manual n8n trigger.

When clicking ‘Execute workflow’ (Manual Trigger): This is the entry point, serving as the n8n trigger to start the process on demand.
Get row(s) in sheet (Google Sheets n8n node): Retrieves all client and project data rows from the specified spreadsheet, feeding the information into the n8n workflow.
checks propsal status (If n8n node): A critical core logic flow control n8n node. It filters the input data, allowing only items that meet a specific criteria (e.g., Status == 'Pending Proposal') to proceed to the AI generation step.
Loop Over Items (Split In Batches n8n node): Manages the execution flow, ensuring the expensive AI step is run sequentially for each qualifying item, crucial for a reliable n8n workflow.
AI Agent (Langchain Agent n8n node): The brain of this automation. It uses a predefined prompt and the language model connection to dynamically generate the proposal content based on the data provided by the preceding n8n node.
Azure OpenAI Chat Model (Langchain LM Chat Azure OpenAI n8n node): Provides the large language model backend (GPT-4o via Azure) to the AI Agent n8n node.
Code (Code n8n node): Used for advanced data manipulation. It parses the raw text output from the AI Agent, extracts components, and structures the final output JSON payload needed by the Gmail n8n node.
Create a draft (Gmail n8n node): The final action n8n node. It takes the structured content and creates a fully formed email draft in the user's inbox, including the subject, body, and intended recipient.