Personalized Customer Feedback Analysis and PDF Report Generator - n8n Workflow

• Teams needing automated customer feedback loops.


• Businesses utilizing OpenAI for operational analysis.


• Developers looking for robust n8n templates integrating PDF generation, Gmail, and Slack.


• Anyone seeking a no-code/low-code solution built with n8n to manage incoming survey responses.

This sophisticated n8n workflow transforms raw customer feedback into actionable insights and professional reports automatically. By leveraging the power of an OpenAI n8n node, the system performs real-time sentiment analysis, extracts key highlights, and generates an executive summary. The core problem this n8n automation solves is the manual effort required to process, analyze, report on, and log high volumes of feedback. The final PDF report is built using custom HTML within an n8n node and then converted to a professional, shareable document, which is subsequently emailed to the customer via the Gmail n8n node and logged immediately to Google Sheets. This highly integrated n8n template ensures no feedback submission is missed, providing rapid analysis and clear communication to both the customer and internal teams.

The process begins with an n8n trigger: the Webhook n8n node, which receives POST requests containing feedback data from external forms (Step 1). The data immediately flows to a Code n8n node ("Clean & Normalize Data1") where it is sanitized, missing fields are handled, and email validity is checked (Step 2).

Next, the Generate AI Summary1 OpenAI n8n node processes the cleaned feedback, requesting a structured JSON analysis for sentiment, highlights, and recommendations (Step 3). The subsequent Code n8n node ("Parse AI Response1") ensures the AI output is correctly parsed, even handling markdown cleanup, and maps the sentiment to a corresponding color code (Step 4).

The core reporting mechanism involves the Build HTML Report1 Code n8n node, which dynamically generates a polished HTML document incorporating the original feedback and the AI summary (Step 5). This HTML is then converted into a professional PDF document using the HTML to PDF1 n8n node (Step 6).

An If n8n node ("Check Valid Email1") validates if the customer provided a usable email. If true, the Email User Report1 Gmail n8n node sends the customer a personalized email containing the downloadable PDF link (Step 9). Finally, regardless of email status, the data is logged to Google Sheets using the Log Feedback Data1 n8n node, and a summary alert, including the PDF link, is posted to a designated Slack channel via the Notify Team1 Slack n8n node. The entire n8n workflow concludes by sending a success message back to the initiating system (Step 12).

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


2. Credential Setup: Configure the following credentials within your n8n environment:

1. Webhook Configuration: Activate the Webhook - Receive Feedback1 n8n trigger to generate the permanent endpoint URL. Integrate this URL into your external feedback form system (e.g., Typeform, Google Forms).


2. Testing: Execute the n8n workflow using test data (as suggested in the Sticky Notes) to verify all connections and data transformations, ensuring the final Gmail n8n node and Slack n8n node function as expected.

Webhook - Receive Feedback1 (n8n trigger): The starting point of this automation. It listens for incoming POST requests containing customer feedback data.
Clean & Normalize Data1 (Code n8n node): This crucial node performs data sanitation, handling edge cases like empty names and invalid emails, ensuring reliable input for the OpenAI n8n node.
Generate AI Summary1 (OpenAI n8n node): Sends the structured feedback data to GPT-3.5-turbo (or GPT-4) with a precise system prompt that mandates the output must be valid JSON containing sentiment, highlights, and a summary. This is a powerful use case for the n8n workflow.
Parse AI Response1 (Code n8n node): Responsible for post-processing the AI output. It cleans up potential markdown wrappers (json, etc.), parses the JSON string, and maps the sentiment to a visual color code used in the subsequent Gmail n8n node and HTML report.
Build HTML Report1 (Code n8n node): Dynamically constructs a visually appealing, professional HTML document incorporating all feedback fields and AI analysis, ready for PDF conversion.
HTML to PDF1 (HTML to PDF n8n node): Takes the generated HTML and converts it into a hosted PDF file, returning a temporary URL and an expiration date.
Check Valid Email1 (If n8n node): Acts as a routing mechanism, checking the hasValidEmail flag generated earlier to determine if the report should be emailed to the customer.
Email User Report1 (Gmail n8n node): Sends a personalized thank-you email containing the AI summary and a direct link to download the generated PDF report.
Log Feedback Data1 (Google Sheets n8n node): Appends all critical data, including the AI summary and PDF URL, to a tracking Google Sheet, providing a centralized data log for this n8n workflow.
Notify Team1 (Slack n8n node): Sends an immediate alert to the team Slack channel, summarizing the feedback and providing the PDF link for quick review.