AI-Powered Sales Feedback Analysis and Google Sheets Reporting - n8n Workflow

• Sales Operations Managers needing automated insight into deal win/loss feedback.


• Data Analysts looking to leverage large language models for structured data extraction.


• Businesses seeking advanced n8n templates to combine AI services (like Azure OpenAI) with common office tools.


• n8n users who want an advanced example of using the Code n8n node for data manipulation and parsing.

Analyzing raw sales notes and email correspondence to derive structured, actionable insights is a time-consuming manual task. This expert n8n workflow solves this by fully automating the process using sophisticated AI agents.

This specific n8n automation ingests raw feedback data stored in Google Sheets, utilizes an Azure OpenAI model via the AI Agent n8n node to categorize and summarize the content, and then saves the structured results back to a second sheet. Furthermore, the n8n workflow includes a second layer of analysis where a separate AI agent analyzes the aggregated data to generate a high-level summary report. Finally, this summary is delivered as an actionable email digest, providing sales leadership with up-to-the-minute business intelligence. This powerful n8n solution demonstrates the immense capability of connecting core business data with advanced AI tools.

This comprehensive n8n workflow operates in two main phases: detailed item analysis and aggregate reporting.

1. Initiation: The n8n workflow starts with a manual n8n trigger, initiating the data retrieval phase.


2. Data Ingestion: The Get row(s) in sheet n8n node fetches the raw sales feedback data from a specified Google Sheet.


3. Preparation: The Extract Notes/Emails n8n node (Code) cleans and extracts the necessary text fields from the input data, preparing it for AI consumption.


4. Item Processing Loop: The Loop Over Items n8n node ensures that each record is processed individually, enabling focused AI analysis.


5. AI Analysis (Path 1): The AI Agent (LangChain) utilizes the Azure OpenAI Chat Model to analyze the extracted notes, categorize the outcome, and generate structured data (e.g., classifying win/loss reasons).


6. Formatting and Saving: The output is refined by the Edit Fields (Set) and Parse AI Response (Code) n8n nodes, which structure the AI's textual response into defined JSON fields. The Save to Google Sheets n8n node then writes this newly categorized and structured data back to a separate results sheet.


7. Aggregate Reporting (Path 2): In parallel, the n8n workflow fetches existing data from the results sheet via the Fetch Google Sheet Data n8n node.


8. Summary Generation: A second AI Agent, AI Agent1, using Azure OpenAI Chat Model1, analyzes this aggregated dataset. This n8n node’s task is to identify trends, summarize key takeaways, and draft a concise executive digest.


9. Filtering and Delivery: The Filter Recent Data n8n node ensures only relevant or recent data drives the final output. The workflow concludes with the Send Email Digest n8n node, sending the AI-generated report summary to stakeholders.

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

1. Import the JSON: Copy the provided JSON code and paste it into your n8n instance using the 'Import from JSON' option.


2. Google Sheets Credentials: Configure the four Google Sheets n8n node instances (Get row(s) in sheet, Save to Google Sheets, Fetch Google Sheet Data). You will need to set up a Google Sheets credential in n8n and specify the Spreadsheet IDs and Sheet Names for your source feedback data and your processed results output.


3. Azure OpenAI Credentials: Configure both Azure OpenAI Chat Model and Azure OpenAI Chat Model1 n8n nodes. This requires setting up an Azure OpenAI credential in n8n, specifying your Resource Name, Deployment Name, and API Key.


4. Code Node Review: Review the logic in the Extract Notes/Emails and Parse AI Response n8n nodes to ensure the data field references match the specific column headers in your Google Sheet data.


5. Email Configuration: Update the Send Email Digest n8n node with the correct sender, recipient addresses, and subject line. Ensure you have an active Email Send credential (SMTP, SendGrid, etc.) configured in n8n.


6. Test and Activate: Execute the n8n workflow manually using the When clicking ‘Execute workflow’ n8n trigger to ensure all connections and AI processes are functioning correctly. Once confirmed, you can activate the workflow.

When clicking ‘Execute workflow’ (Manual Trigger): The initiating n8n trigger for the entire n8n workflow. Used for immediate testing or scheduled execution if changed later.
Get row(s) in sheet (Google Sheets n8n node): Fetches the raw sales data or feedback notes from the source spreadsheet. Essential for feeding the AI analysis.
Extract Notes/Emails (Code n8n node): Custom JavaScript code to extract and format specific columns (like 'Notes' or 'Email Body') into a clean variable structure needed by the downstream AI Agent n8n node.
Loop Over Items (Split In Batches n8n node): Ensures that the resource-intensive AI analysis is performed on each individual sales record, maintaining data separation.
AI Agent / Azure OpenAI Chat Model (LangChain n8n node): The primary categorization engine. This n8n node uses the large language model to read unstructured text and output structured classification (e.g., reason for loss, sentiment, deal type).
Parse AI Response (Code n8n node): Essential for transforming the raw AI output (which is often textual JSON) into a proper JSON object that can be easily mapped for saving.
Save to Google Sheets (Google Sheets n8n node): Writes the newly structured and AI-analyzed data (e.g., categorized feedback) into the reporting spreadsheet.
AI Agent1 / Azure OpenAI Chat Model1 (LangChain n8n node): The secondary AI n8n node responsible for analyzing the aggregate data set to generate high-level trends and summaries for the executive email digest.

• Send Email Digest (Email Send n8n node): The final action n8n node that delivers the comprehensive, AI-generated summary report to designated recipients.