AI-powered webinar feedback replies with GPT-4, Google Sheets, and Gmail
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets, Gmail and OpenAI.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- ID Generation (Code): runs custom JavaScript code
- Normalize Feedback (Code): runs custom JavaScript code
- Store Partial (Google Sheets): append
- Merge: merges the data from its input branches
- Message a model (OpenAI): uses OpenAI
- Common Resources (Code): runs custom JavaScript code
- Build Email HTML (Code): runs custom JavaScript code
- Parse AI Response (Code): runs custom JavaScript code
- Send AI Thank You Email (Gmail): uses Gmail
- Store Feedback (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - OpenAI
@n8n/n8n-nodes-langchain.openAi - Merge
n8n-nodes-base.merge
From the author
How it works This workflow captures webinar feedback through a webhook and normalizes the submitted data for processing. It stores raw feedback in Google Sheets, uses an AI model to understand sentiment and intent, and generates a personalized response. A…