Manage farm box shares and weekly harvest emails with gpt-6-luna, Google Sheets and Gmail

by Khairul Muhtadin ✓ · 1 views · created 2026-10-05 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 25 nodes and runs when someone submits an n8n form (“Farm box change request”) (plus 2 other triggers). Along the way it connects OpenAI Chat Model, Google Sheets and Gmail.

How it runs

Trigger: When someone submits an n8n form (“Farm box change request”) (plus 2 other triggers).

1. Normalize Request (Edit Fields (Set)): sets 7 fields: member_name, member_email, request…
2. Read Member Balances (Google Sheets): uses Google Sheets
3. Read Active Members (Google Sheets): uses Google Sheets
4. Validate Request (If): checks a condition and branches into true / false
5. Find Outstanding Balances (Code): runs custom JavaScript code
6. Collapse Members (Code): runs custom JavaScript code
7. Classify and Draft Reply (AI Agent): runs an AI agent, with model: Reply Model
8. Email Farm About Invalid Request (Gmail): uses Gmail
9. Email Balance Reminders (Gmail): uses Gmail
10. Read This Week's Harvest (Google Sheets): uses Google Sheets

…plus 10 more steps. See the full node list below.

Services it uses

OpenAI Chat ModelGoogle SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (9)

• n8n Form Triggern8n-nodes-base.formTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• AI Agent@n8n/n8n-nodes-langchain.agent
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Gmailn8n-nodes-base.gmail
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

Farm box members change their plans, and someone has to catch every skip, pause and pickup swap before the next delivery. This n8n workflow takes each change request from a form, has gpt-6-luna classify it and draft the confirmation, logs it to Google Sheets…

View the original on n8n.io → Check your own copy