Advanced n8n Workflow Creation

Job ID: 40032275

Budget: $250 – $750 USD

I need a complete AI automation system built for Facebook, Instagram (limited by Meta rules), and WhatsApp using n8n.
The system will be used by different businesses such as phone shops, pharmacies, clothing stores, shoe shops, spare-part shops, and service-based businesses.

Below is the full specification — please read carefully because everything is required.

------------------------------------------------------------
1) MASTER WORKFLOW (ONE TEMPLATE)
------------------------------------------------------------
You will build ONE Master n8n Workflow that I can later duplicate for each business.

The workflow must support platform activation flags:
- facebook_active = true/false
- instagram_active = true/false
- whatsapp_active = true/false

If a platform is OFF → that entire module must not run.

Each business may use:
• Facebook only
• Facebook + WhatsApp
• WhatsApp only
• Facebook + Instagram
• All platforms

------------------------------------------------------------
2) PRODUCT IMAGES (IMPORTANT)
------------------------------------------------------------
PDF files usually don’t have images, so the system must use a separate image storage location.

Requirements:
• Owner can upload product photos via WhatsApp control panel
• OR via Google Drive (or any simple storage you recommend)
• Every image filename must include product name + details to prevent confusion
Example: “iPhone15ProMax_White_256GB.jpg”

AI must send these product images in:
• Direct messages
• WhatsApp replies
• Messenger replies

------------------------------------------------------------
3) PDF CATALOG SYSTEM
------------------------------------------------------------
Each business has its own PDF catalog.

AI must extract:
- product name
- price
- description
- manufacturer
- expiry date (if pharmacy)
- quantity per pack
- SKU / product code

PDF structure may differ for every business → so the workflow must support flexible parsing with an optional helper prompt.

------------------------------------------------------------
4) POST UNDERSTANDING
------------------------------------------------------------
AI must detect post type:

A) Product post
B) General post (welcome, announcement, etc.)

If multiple products exist in the same post:
→ AI sends ALL product details in private message.

If general post:
→ reply with friendly general response.

------------------------------------------------------------
5) COMMENT REPLY RULES
------------------------------------------------------------
• ONE reply per customer per post
• If customer comments on another post → new reply is allowed
• NO PRICES in comments, ever

If customer asks “price?” → reply:
“Details will be sent in private message.”

Auto-like on each comment.

------------------------------------------------------------
6) PRIVATE MESSAGES (FB/IG DM/WHATSAPP)
------------------------------------------------------------
AI must chat like a human:
• natural Libyan Arabic
• sends product images, details, prices
• asks logical questions
• long conversation handling

Conversation memory must be:
• ON or OFF (controlled by owner)

------------------------------------------------------------
7) VOICE MESSAGE SUPPORT
------------------------------------------------------------
If customer sends a voice note:
1. Convert voice → text
2. AI processes text
3. AI replies normally

------------------------------------------------------------
8) BOOKING SYSTEM (GOOGLE SHEETS)
------------------------------------------------------------
Booking happens when customer says:
“Book it”, “نبي نحجز”, “Yes”.

Collect:
- customer name
- phone number
- product
- quantity
- date
- notes (delivery, packaging, color…)
- STATUS (Reserved / Cancelled / Paid / Delivered)

System must:
• Save booking into Google Sheets
• Notify business owner on WhatsApp:
“New booking received: [details]”

Owner can:
• Mark Paid / Delivered from WhatsApp OR Google Sheets
• Cancel or edit an order directly from WhatsApp

------------------------------------------------------------
9) WHATSAPP CONTROL PANEL
------------------------------------------------------------
Used by the business owner.
2 more staff numbers can be added.

Owner can:
1. Upload/replace PDF
2. Upload product photos
3. Update stock: “This product is out of stock”
4. Change bot personality / tone
5. Turn platforms ON/OFF (FB/IG/WA)
6. Ask for daily/weekly bookings
7. Cancel or edit orders
8. Receive HUMAN-TAKEOVER alerts when customer needs a human

------------------------------------------------------------
10) DATA INPUT
------------------------------------------------------------
Owner can update data through:
• WhatsApp panel
• OR Google Drive
• OR any simple method you recommend

Not limited to WhatsApp only.

------------------------------------------------------------
11) SERVICE-BASED BUSINESSES
------------------------------------------------------------
If the business doesn’t sell products:
• PDF becomes a “service list”
• Booking becomes “appointment booking”
• Same logic applies

------------------------------------------------------------
REQUIREMENTS
------------------------------------------------------------
• Must be clean, efficient, scalable
• Must follow all Meta API rules
• Must be able to duplicate workflow easily
• Must include documentation + video explaining how to duplicate workflow for new businesses