Approve pet boarding bookings and send vaccine reminders with Gmail, Sheets and OpenAI

by Khairul Muhtadin ✓ · 3 views · created 2026-10-05 · Document Extraction, AI Chatbot

What this workflow does

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

How it runs

Trigger: When someone submits an n8n form (“Pet boarding booking request”) (plus 2 other triggers).

1. Normalize Booking (Edit Fields (Set)): sets 13 fields: owner_name, owner_email, pet_name…
2. Read Booking Register (Google Sheets): uses Google Sheets
3. Read Register for Digest (Google Sheets): uses Google Sheets
4. Validate Booking (If): checks a condition and branches into true / false
5. Find Expiring Vaccines (Code): runs custom JavaScript code
6. Summarize Bookings (Code): runs custom JavaScript code
7. Check Vaccine Validity (Code): runs custom JavaScript code
8. Email Intake Problem to Kennel (Gmail): uses Gmail
9. Any Expiring? (If): checks a condition and branches into true / false
10. Draft Kennel Digest (AI Agent): runs an AI agent, with model: Digest Model

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

Services it uses

GmailOpenAI Chat ModelGoogle Sheets

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
• Gmailn8n-nodes-base.gmail
• Coden8n-nodes-base.code
• AI Agent@n8n/n8n-nodes-langchain.agent
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Google Sheetsn8n-nodes-base.googleSheets
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

Boarding bookings only get approved when the vaccination records actually hold up. This n8n workflow takes boarding requests from a form, checks rabies, DHPP and bordetella expiry dates against the stay, has gpt-6-luna write the owner reply for whatever the…

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