About This Project
I orchestrated an n8n workflow with Gemini and Google Sheets to automate customer messaging, preserve conversation context, and enforce strict usage/security rules in production webhook traffic.
Technologies
n8nGoogle GeminiGoogle Sheets APIWebhookJavaScript
Key Features
●Automated inventory-aware WhatsApp responses using Gemini prompt orchestration
●Built Google Sheets based status and conversation logging for non-technical teams
●Implemented context windows to improve response relevance and reduce hallucinations
●Created an authorized customer pool and separated unknown webhook traffic
●Applied rate limits, daily quotas, and silent blocking for abuse prevention
●Optimized API usage and operational cost while maintaining response quality
