Multi Channel AI automation

Posted 3 weeks ago

Worldwide

Summary

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
  • Expert
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Artificial Intelligence
Activity on this job
  • Proposals:50+
  • Last viewed by client:3 weeks ago
  • Interviewing:
    2
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Oct 16, 2000
  • Ireland
    Shannon4:16 PM
  • $78K total spent
    225 hires, 8 active
  • 2,974 hours
  • Small company (2-9 people)

Explore similar jobs on Upwork

Job Aggregation and Dashboard CreationHourly‐ Posted 8 months ago
Automation
Data Scraping
Data Extraction
API
UI/UX Prototyping
Web Scraping
Install and Integrate UTM Grabber PluginFixed-price‐ Posted 3 weeks ago
WordPress

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers 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

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo