Summarize Google Sheets form feedback via OpenAI's GPT-4

• Automate feedback analysis from Google Forms to streamline reporting.
• Generate insightful summaries of customer feedback for better decision-making.
• Enhance communication by sending professional reports via email.

Trigger the workflow manually to initiate the process. Fetch responses from a specified Google Sheets document. Aggregate feedback into structured arrays for analysis. Use OpenAI's GPT-4 to generate a summary report based on 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 the Google Sheets node with the appropriate document ID and sheet name.
3. 3
   Set up OpenAI credentials for the summarization step.
4. 4
   Connect the Gmail node with your email account for sending reports.
5. 5
   Test the workflow to ensure all connections and configurations are working correctly.