Communication

Classify contact form messages and save data automatically

14 nodes 340 168 Automatic trigger
Download

Workflow Description

Automation that receives contact form submissions, classifies them using AI into categories like complaints and inquiries, sends automated email responses, and stores data in a spreadsheet for future reference and analysis.

How it works

  1. 1.Receive contact form data automatically when submitted
  2. 2.Analyze and classify message text using OpenAI
  3. 3.Send immediate email reply to the customer
  4. 4.Save message and classification to Google Sheets
  5. 5.Route messages by priority or category

Use cases

  • Separate customer complaints from general inquiries automatically
  • Create an organized record of all contact messages for review and reporting

Requirements

  • Active OpenAI account for text classification
  • Gmail or email service configured for automated responses
  • Accessible Google Sheets file with write permissions

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Form Trigger If OpenAI Email Send Google Sheets

Details

Trigger Automatic trigger
Nodes 14
Apps 5
Views 340
Downloads 168

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (14)

/

On form submission

Form Trigger

#1

Text Classifier

If

#2

OpenAI

OpenAI

#3

Prod. Dep.

Email Send

#4

Quote Dep.

Email Send

#5

Gen. Dep.

Email Send

#6

Order Dep.

Email Send

#7

Other Dep.

Email Send

#8

Quote DB

Google Sheets

#9

Prod DB

Google Sheets

#10

General DB

Google Sheets

#11

Order DB

Google Sheets

#12

Other DB

Google Sheets

#13

Sticky Note

Sticky Note

#14