AI-Powered Webinar Feedback Replies with GPT-4, Google Sheets, and Gmail

This n8n workflow automates the process of generating personalized replies to webinar feedback, storing the original feedback and generated replies in Google Sheets, and then sending these replies via Gmail. It leverages the power of GPT-4 to create human-like responses, streamlining communication and ensuring timely follow-ups.

What it does

This workflow automates the following steps:

1. Receives Webinar Feedback: It starts by listening for incoming webinar feedback via a webhook. This acts as the trigger for the entire automation.
2. Generates AI Reply: The received feedback is then sent to OpenAI (GPT-4) to generate a personalized and appropriate reply.
3. Stores Feedback and Reply: Both the original webinar feedback and the AI-generated reply are recorded in a Google Sheet for logging and tracking purposes.
4. Sends Email Reply: Finally, the AI-generated reply is sent to the feedback provider via Gmail, ensuring prompt communication.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Account: An active n8n instance (cloud or self-hosted).
• OpenAI API Key: An API key for OpenAI, with access to GPT-4.
• Google Sheets Account: A Google account with access to Google Sheets. You'll need to create a spreadsheet to store the feedback and replies.
• Gmail Account: A Google account with access to Gmail for sending emails.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, click on "Workflows" in the left sidebar.
   • Click "New" -> "Import from JSON" and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • OpenAI: Set up your OpenAI credential using your API key.
   • Google Sheets: Set up your Google Sheets credential. This typically involves OAuth authentication.
   • Gmail: Set up your Gmail credential, also usually via OAuth.
3. Configure Nodes:
   • Webhook: Activate the Webhook node. Copy the webhook URL and configure your webinar feedback system to send data to this URL when new feedback is submitted.
   • Google Sheets:
     • Specify the Spreadsheet ID and Sheet Name where you want to store the feedback and replies.
     • Ensure the sheet has appropriate headers (e.g., "Feedback", "AI Reply", "Timestamp", "Email").
   • OpenAI:
     • Ensure the "Model" is set to a GPT-4 variant (e.g., gpt-4).
     • Review the prompt to ensure it generates the desired type of reply.
   • Gmail:
     • Configure the "To" email address using an expression to dynamically pull the email from the incoming webhook data (e.g., {{ $json.email }}).
     • Set the "Subject" and "Body" of the email to include the AI-generated reply and any other relevant information.
4. Activate the Workflow: Once all credentials and nodes are configured, activate the workflow.

Now, whenever new webinar feedback is sent to the webhook, the workflow will automatically process it, generate a reply, log it, and send the email.