Multi Channel AI automation
Worldwide
Job Title: Multi-Channel AI Automation Expert (Gmail + WhatsApp to Google Sheets via n8n) Description: I am looking for an experienced automation freelancer to build a cost-effective, multi-channel AI workflow. Currently, my client inquiries arrive via Gmail and WhatsApp Business. The product and pricing data lives in a Google Sheet. My previous AI setup kept hallucinating data—it was pulling wrong rows and accidentally leaking internal information like "Supplier Name" and wholesale costs into the offers. I need a robust system with strict data guardrails built on n8n (self-hosted or cloud) to keep monthly operational costs near zero and completely avoid expensive platforms like Zapier or Make.com. Requirements & Workflow Logic: 1. Gmail Workflow: - Trigger when a new inquiry email arrives in my inbox. - Look up the corresponding item/pricing in the Google Sheet using strict matching. - Isolate the data: The workflow must hide or filter out internal columns (like Supplier Name) so the AI cannot see them. - Use a raw LLM API (OpenAI or Anthropic) to draft a professional offer email based on the filtered data. - Save the final output as a GMAIL DRAFT. I want a "human-in-the-loop" safety net where I manually review and hit send. 2. WhatsApp Workflow: - Integrate incoming messages using the official WhatsApp Cloud API (Meta Developers console). - Match the query against specific product rows in Google Sheets. - Strict Guardrails: If the AI matches the data with 100% confidence, reply to the client automatically with the retail offer. If the query is ambiguous, vague, or a low-confidence match, the AI must trigger a polite fallback message ("Let me look into that specific item for you and get right back to you!") instead of guessing or leaking data. Skills Needed: - Advanced n8n workflow development - Google Sheets API integration - Meta Developer Console & WhatsApp Cloud API setup - OpenAI / Anthropic API formatting & prompt engineering (system prompt constraints) To Apply: Please briefly explain whether you recommend n8n Cloud or a self-hosted n8n setup for this specific use case, and confirm your experience with the Meta WhatsApp Cloud API.
$100.00
Fixed-price- ExpertExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:50+
- Last viewed by client:3 weeks ago
- Interviewing:2
- Invites sent:0
- Unanswered invites:0
About the client
- IrelandShannon4:16 PM
- $78K total spent225 hires, 8 active
- 2,974 hours
- Small company (2-9 people)
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by