Turn contact form messages into clear, routed requests. Great for ecommerce and support teams that need faster replies and clean records without manual sorting.

A built in form collects name, email, and message. An AI classifier, powered by OpenAI, reads the message and tags it as quote request, product info, general problem, order info, or other. Based on that tag, the request goes to the right department by email, and the message is saved in the matching Google Sheets spreadsheet. Each branch uses a reply to field so your team can answer the customer directly.

Setup is simple. Connect OpenAI, your SMTP email, and Google Sheets. Map the fields and point each branch to the right inbox and sheet. Teams usually cut triage time from an hour to minutes and reduce copy paste errors. Use it for store inquiries, quote requests, product questions, and order issues. Expect faster first responses, cleaner data, and a process that scales as volume grows.

• Form capture collects name, email, and message for each submission.
• AI classification uses OpenAI to tag messages into five clear categories with a safe fallback.
• Department routing sends emails to the right team with the customer email as reply to.
• Google Sheets logging saves each request in the matching sheet for easy tracking.
• Separate sheets for quotes, products, general issues, orders, and other requests.
• Supports extra fields like product type and keeps them in emails and logs.
• Medium complexity design that is easy to edit and extend.

• Reduce manual sorting from 60 minutes to 5 minutes
• Automate up to 90% of message triage
• Improve data accuracy by 95% with direct sheet logging
• Handle 5 times more inquiries without extra staff
• Connect OpenAI, email, and Google Sheets in one flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, OpenAI and SMTP. See the Tools Required section above for links to create accounts with these services.
3. Open the OpenAI node. In the Credential to connect with dropdown, click Create new credential. Enter your OpenAI API key from your OpenAI account API page, name the credential clearly, and save.
4. Open each Google Sheets node. In the Credential to connect with dropdown, click Create new credential, choose Google Sheets OAuth, sign in to your Google account, and allow access. Use a clear name for the credential.
5. Open each Email node. In the Credential to connect with dropdown, click Create new credential, choose SMTP, then enter your SMTP host, port, username, and password. Enable SSL or TLS as required by your email provider and test the connection.
6. Open the Form Trigger node. Confirm the fields for Name, Email, and Message are present. Copy the public form URL for testing after activation.
7. Open the Text Classifier node. Verify the five categories and the fallback are set. Ensure it is linked to the OpenAI language model. Run a test message to see the predicted category.
8. Open each Email node and set the To and From addresses for the correct team inbox. Keep the Reply To set to the form Email field so the team can answer the customer directly.
9. Open each Google Sheets node and select the spreadsheet and worksheet for that category. Map columns to Name, Email, Message, and any extra fields. Use Append mode and run a test to confirm a new row is created.
10. Activate the workflow. Submit test messages that mention quotes, product questions, order issues, and general problems. Confirm the correct team gets an email and the matching sheet logs the entry.
11. If a message is misrouted, adjust the category descriptions in the classifier. For email errors, check SMTP ports and credentials. For sheet errors, confirm Google permissions and that the selected sheet exists.