Summarize Google Sheets Form Feedback via OpenAI

Name: Summarize Google Sheets Form Feedback via OpenAI
Rating: 3.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

17 views

0 downloads

Community Contributedautomationemailfeedbackgoogle sheetsgpt-4openaisummarization

Automatically summarizes feedback from Google Sheets forms using OpenAI's GPT-4.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of collecting and summarizing feedback submitted through Google Forms. It retrieves responses from a Google Sheet, aggregates them, and then uses OpenAI's GPT-4 to generate a concise summary report. Finally, the report is converted to HTML and sent via email.

Key Features

Integrates with Google Sheets and Google Forms.
Utilizes OpenAI's GPT-4 for advanced summarization.
Automatically aggregates and processes feedback data.
Converts Markdown summaries to HTML for email.
Sends summarized feedback via Gmail.

How To Use

Set up Google Form and Sheet: Create a Google Form and link it to a Google Sheet to collect responses.
Configure Google Sheets Node: Update the documentId and sheetName to match your Google Sheet.
Configure OpenAI Node: Ensure your OpenAI API credentials are set up and select gpt-4-turbo-preview.
Configure Gmail Node: Set up your Gmail credentials and the recipient email address.
Activate Workflow: Run the workflow manually or set up a trigger for automatic execution.

Apps Used

automation

feedback

google sheets

gpt-4

openai

summarization

Workflow JSON

{
  "id": "0dd7b522-0275-4e28-9df0-89aaf168f5e7",
  "name": "Summarize Google Sheets Form Feedback via OpenAI",
  "nodes": 0,
  "category": "Community Contributed",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.