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

n8n template #2164

Summary

This n8n workflow was developed to collect and summarize feedback from an event that was collected via a Google Form and saved in a Google Sheets document. The workflow is triggered manually by clicking on the "Test workflow" button. The Google Sheets node retrieves the responses from the feedback form. The Aggregate node then combines all responses for each question into arrays and prepares the data for analysis. The OpenAI node processes the aggregated feedback data. System Prompt instructs the model to analyze the responses and generate a summary report that includes the overall sentiment regarding the event and constructive suggestions for improvement. The Markdown node converts the summ

How to set it up

Open template #2164 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 3 credentials under Credentials → Add credential: Google Sheets, Gmail, OpenAI. Then open each of those nodes and pick the credential.
Check the model in the OpenAI node. The template may point at a model your account can't use; swap it for one you have access to.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Summarize Google Sheets form feedback via OpenAI's GPT-4" (https://n8n.io/workflows/2164). It uses: Google Sheets, Gmail, OpenAI. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Google Sheets Gmail OpenAI

Questions

Yes. Yulia published it free on n8n.io as a verified creator, and it has 8,532 views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets, Gmail, OpenAI. The other 0 nodes are built into n8n.

Similar workflows

NameViews