Summarize Google Sheets Form Feedback via OpenAI's GPT-4

This n8n workflow automates the process of summarizing feedback submitted through Google Forms and stored in Google Sheets. It leverages OpenAI's GPT-4 to generate concise summaries and then sends these summaries via Gmail.

What it does

This workflow simplifies the task of processing feedback by:

1. Triggering Manually: The workflow is initiated manually, allowing you to control when the feedback summarization process runs.
2. Reading Google Sheet Data: It connects to a specified Google Sheet to read the latest feedback entries.
3. Aggregating Feedback: It combines the feedback entries into a single, structured format suitable for AI processing.
4. Summarizing with OpenAI: It sends the aggregated feedback to OpenAI (GPT-4) to generate a concise summary.
5. Formatting Output: The generated summary is then formatted into a readable Markdown document.
6. Sending Email: Finally, it sends an email containing the Markdown-formatted summary via Gmail.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: Access to a Google Sheet containing your form feedback.
• OpenAI API Key: An API key for OpenAI with access to GPT-4 (or a similar model).
• Gmail Account: A Gmail account configured as a credential in n8n for sending emails.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click "New" to create a new workflow.
   • Click the three dots menu (...) in the top right, select "Import from JSON," and paste the copied JSON.
2. Configure Credentials:
   • Google Sheets: Edit the "Google Sheets" node (ID: 18). Select or create a Google Sheets credential that has access to your feedback spreadsheet.
   • OpenAI: Edit the "OpenAI" node (ID: 840). Select or create an OpenAI API credential. Ensure it has access to the gpt-4 model.
   • Gmail: Edit the "Gmail" node (ID: 356). Select or create a Gmail credential.
3. Customize Nodes:
   • Google Sheets (ID: 18):
     • Specify the "Spreadsheet ID" and "Sheet Name" where your feedback data is located.
     • Adjust the "Read Range" if you only want to process specific rows or columns.
   • OpenAI (ID: 840):
     • Review and adjust the prompt to guide GPT-4 on how to summarize the feedback effectively. Ensure the prompt correctly references the incoming data from the "Aggregate" node.
     • Select the desired OpenAI model (e.g., gpt-4).
   • Gmail (ID: 356):
     • Set the "To" email address(es) where you want to receive the summaries.
     • Customize the "Subject" of the email.
     • Review the "Body" to ensure it correctly embeds the Markdown summary from the "Markdown" node.
4. Execute the Workflow:
   • Click the "When clicking ‘Execute workflow’" node (ID: 838) and then click "Execute Workflow" to run it manually.

The workflow will then read your Google Sheet, summarize the data using OpenAI, and send the formatted summary to the specified email address.