Freelancer - n8n Automation Expert – Gmail / Google Sheets / Slack / AI Email Classification

[sachin_karma]

@BenKo

Resolved translation direction confusion and proceeded with task

We are looking for an experienced automation developer to build 6 interconnected email automation workflows for a B2B travel agency. A fully detailed requirements document is already in place – this is a build job, not a discovery project.

The Client: A German-speaking travel agency. Primary project language is German. English communication is fine on our side.

---

The Project – 6 Workflows:

• Automatic Email Labeling – AI-powered classification of incoming emails into 5 categories (invoices, hotel updates, accounts (approx. 50 different clients), urgent, booking changes) via Gmail API + LLM of your choice (Claude, OpenAI, Gemini)
• Hotel Update Forwarding – Auto-forward labeled hotel updates to the sales team inbox
• Super Urgent Escalation – Keyword detection + automatic Slack notification to sales channel
• Request Status Tracking – Automatic intake of new requests into Google Sheets with unique reference number, full timestamp tracking across all status stages (Pending → Acknowledged → Offer Sent → Follow Up → Negotiation → Confirmed/Declined)
• Daily Reporting – Formula-based dashboard in Google Sheets + daily Slack digest with link and one-line summary
• Incoming Confirmation – Auto-reply to first-contact emails only, with auto-reply loop protection

---

Tech Stack at Client:

• Gmail (Google Workspace) – primary email platform
• Google Sheets – tracking & reporting database
• Slack – internal communication & alerting
• Proprietary booking engine (REST API access to be clarified)
• LLM API for multilingual email classification (DE/EN/FR)

---

Technology:

We are open to different approaches. Our preference is n8n (self-hosted, installed by us) as the primary automation layer – but we are open to alternatives if you have strong experience with another solution that makes more sense for this project.

For the tracking database, Google Sheets is our first idea, but we are also open to using a proper database if you can make a strong case based on your expertise.

This will be the first set of automations for the client – more projects are already in the pipeline.

---

Required Skills:

• n8n or comparable automation platform (advanced level)
• Gmail API / Google Workspace API
• Google Sheets API
• Slack API
• LLM/AI API integration (Claude, OpenAI or Gemini)
• Clean workflow documentation & error handling
• REST API integration experience

---

What we provide:

• Fully detailed requirements document with all fields, status stages and logic pre-defined
• Direct contact person throughout the project

---

What we expect:

• Structured proposal with fixed rates per workflow and as a total package
• At least 1 example of a similar project (email automation, Gmail integration or Sheets tracking)
• Clean, documented workflows – no black-box builds
• German or English communication

Hey @BenKo

I’ve built almost the same setup recently — Gmail API + LLM classification feeding into Sheets tracking with Slack alerts. Happy to build all 6 workflows on n8n (self-hosted) exactly to your spec.

Here’s the approach: • AI labeling with multilingual prompts (DE/EN/FR) using Claude or OpenAI for the 5 categories + 50 client accounts • Gmail API auto-forwarding for hotel updates, keyword-triggered Slack escalation for urgent cases • Sheets tracking with unique reference IDs, full timestamp logs across all 7 status stages • Formula-based dashboard + daily Slack digest with link and summary line • First-contact auto-reply with loop protection (header checks + sender history) • Clean error handling, retries, and a Loom walkthrough per workflow

I’d suggest sticking with Sheets for v1 — easy for the team to inspect — and revisiting Supabase later if volume grows. Fixed price per workflow + total package on request.

Let’s schedule a call to discuss the details further.