Summarize Google Sheets feedback via OpenAI's GPT-4

• Automate feedback collection and analysis from Google Forms.
• Generate insightful reports from customer feedback.
• Enhance decision-making with summarized event feedback.

Trigger the workflow manually to start the process. Retrieve feedback data from Google Sheets. Aggregate responses into structured arrays. Use OpenAI's GPT-4 to summarize the feedback. Convert the summary from Markdown to HTML format. Send the final report via Gmail to designated recipients.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure Google Sheets and OpenAI credentials.
3. 3
   Set the Google Sheets document ID and sheet name.
4. 4
   Adjust the email settings for the Gmail node.
5. 5
   Test the workflow to ensure proper functionality.