Headline: Hiring n8n & WhatsApp Automation Developer (Chat Mitra + Razorpay)
– Fixed Project
About the Project
I am looking for an experienced automation expert to build an end-to-end
WhatsApp file delivery system. I need you to build a dynamic conversational flow
connected to Chat Mitra, use an n8n backend (installed and configured on my plain
Hostinger KVM2 VPS) to generate menus directly from a database, process
payments via Razorpay, and automate digital file delivery via email.
Tech Stack You Will Work With (Strictly Limited To):
WhatsApp API: Chat Mitra
Automation: n8n (To be installed via Docker on a plain Hostinger Ubuntu
VPS)
Payments: Razorpay
Delivery: SMTP Email (via custom domain)
Scope of Work
1. Server & n8n Setup
Install and configure Docker, n8n, and any necessary reverse proxy (e.g.,
Nginx/Traefik) on a fresh Hostinger Ubuntu 24.04 VPS.
Configure secure local directories on the server for hosting the PDF files.
2. Email & SMTP Setup
Create the official business email via my Hostinger account for our custom
domain.
Configure all necessary DNS records (SPF, DKIM, DMARC) so the n8n
automated delivery emails do not land in spam.
3. 100% Dynamic Menus (n8n Driven) & Navigation
The entire WhatsApp menu flow must be dynamically generated by n8n.
Dual Source Database Architecture: n8n must be configured to read from
two separate master Excel/CSV databases: one dedicated exclusively to
Technical courses and one dedicated exclusively to Non-Technical courses.
When the user sends “Hi”, Chat Mitra must instantly webhook n8n to
generate the first menu.
GLOBAL UI REQUIREMENT: Every single interactive message or menu
window generated by n8n must include a “Back” button, allowing the user to
seamlessly return to the previous step at any point in the flow.
Initial Category Selection: The first menu must ask the user to select between
two main categories: 1. Technical or 2. Non-Technical.
Branching Flow Sequences:
o If Technical (Reads from Database 1): The flow sequence is Course
Name → Semester → Product.
o If Non-Technical (Reads from Database 2): The flow sequence is State
→ Medium → Stream → Course Name → Semester → Product.
As we add new rows to the databases, the WhatsApp menus must update
automatically without requiring manual edits to the Chat Mitra chatbot.
4. Support Routing
Add a “Request Course / Help” option to the Main Menu and at the end of
the flow.
If clicked, the bot must reply with a text message directing the user to email
support.
5. Course Display
After the final product selection, n8n must push an Interactive List Message
back to WhatsApp displaying the available subjects/products.
CRITICAL UI REQUIREMENT: The items within this Interactive List
Message must be populated using the Title column from the database (e.g.,
“Dummy Subject Title 1”).
Do not use internal course codes for the list display.
6. Cart System
When a subject/product is selected from the list, n8n must push a message
detailing the Title and price.
Display only one interactive button: “Add to Cart”.
(No syllabus preview is required) .
Multi-Select Cart Logic: When a user clicks “Add to Cart”, n8n must
temporarily store this selection and reply with a cart summary message,
offering two buttons: “Add More Subjects” (which loops them back to the
Course Display list) or “Proceed to Checkout”.
7. Student Details & Anti-Abuse Logic
Once the user clicks “Proceed to Checkout”, prompt the user to enter their Full
Name (with basic validation to reject special characters/numbers), followed
by their Email Address (with format validation).
CRITICAL CHECK: At this point, n8n must check the user’s mobile number
against the master databases.
If the user has already made more than 3 purchases from this specific mobile
number within the current Financial Year (FY), the system must instantly
block the transaction and notify the user to avoid illegitimate purchases.
Finally, display a required Declaration message containing a hyperlink to our
Terms & Conditions along with an “I Agree” button.
Upon agreement, send this complete checkout payload (containing all cart
items) to n8n via Webhook.
8. Payment Generation
Receiving the final checkout payload, n8n must calculate the total cart value,
generate a specific Razorpay payment link for the combined amount, and
send it via WhatsApp.
9. Fulfillment, Invoicing & Analytics (Consolidated Email Logic)
Catch the Razorpay payment.captured webhook.
Trigger the SMTP email node to send a single fulfillment email to the
customer.
Anti-Piracy PDF Stamping: Before sending, n8n must dynamically
stamp/watermark every PDF file from the cart with a timestamp and the
generated Invoice Number to strictly control piracy. This stamp must be
placed in the footer at the bottom-left corner in a small but legible font size.
This email must contain BOTH the stamped PDF notes as file attachments
(pulled from the local VPS) AND the attached Razorpay Payment Receipt or
Invoice.
Sales Record Database (Single Workbook): n8n must explicitly record every
successful sale back into our master sales ledger. This ledger will be one
single Google Sheets/Excel workbook containing two separate sheets (tabs) .
n8n must dynamically route and log the sale into either the “Technical” sheet
or the “Non-Technical” sheet based on the purchased items, logging the
mobile number, state-wise, and quarter-wise data.
(Updated Requirement) n8n must track cumulative sales turnover. If the
total turnover is under ₹20 Lakhs, attach standard Razorpay receipts to the
fulfillment email. Once the turnover exceeds ₹20 Lakhs, the workflow must
dynamically switch to using the Razorpay Invoices API to generate and attach
GST-compliant invoices to that same email instead.
Send a final automated message via Chat Mitra confirming successful
payment and email delivery.
Security & Access Provided
You will be provided with “Skeleton Files” containing 100% fake, randomized
dummy data (including dummy PDFs and pricing) to build the database
logic.
You are responsible for using your own test Chat Mitra sandbox/number
during development to avoid triggering messages to live users.
You will not have access to our live proprietary curriculum.
You will be provided with Razorpay TEST API keys only.
You will get temporary SSH/root access to a plain Hostinger Ubuntu VPS to
configure the environment, Chat Mitra API tokens, and limited Hostinger
hPanel access (only for email/DNS setup).
To Apply: Please DM me with:
Your fixed-price quote for this exact scope of work.
Your estimated timeline for completion (in days).