Skip to content

README.md

Latest commit

 

History

History
50 lines (31 loc) · 1.51 KB

README.md

File metadata and controls

50 lines (31 loc) · 1.51 KB
Raw

Summarize feedbacks

Purpose

Reads customer/user feedback entries from a Google Sheet, uses OpenAI to summarise themes and sentiment, and emails the digest.

Trigger Type

Manual / Unknown

Input Format

Feedback entries in a Google Sheets tab (manual trigger).

Output Format

AI-generated feedback summary emailed to the product team.

External Services Used

Gmail, Google Sheets, OpenAI (GPT)

High-Level Flow

  1. Manual trigger fires the workflow
  2. Feedback rows loaded from Google Sheets
  3. All entries compiled and sent to OpenAI for analysis
  4. AI identifies top themes, pain points, and positive signals
  5. Summary email dispatched to product team

Required Environment Variables / Credentials

  • GOOGLE_SHEETS_ID — (set in n8n credentials or environment)
  • PRODUCT_TEAM_EMAIL — (set in n8n credentials or environment)
  • OPENAI_API_KEY — (set in n8n credentials or environment)
  • SENDER_EMAIL — (set in n8n credentials or environment)

Note: All credentials must be configured in n8n's Credentials manager.
Never hardcode secrets in the workflow JSON.

Setup Instructions

  1. Import summarize-feedbacks.json into your n8n instance via Workflows → Import from file.
  2. Open the workflow and configure all credential nodes (look for nodes marked with a credential warning).
  3. Set the required environment variables in n8n's settings or your .env file.
  4. Activate the workflow.

Generated by n8n Workflow Auditor · Safe for public GitHub upload.