Tharwat Mohamed
I'm a system engineer , who's facinated by ai and automation , I like building systems and agents
Templates by Tharwat Mohamed
Customer support WhatsApp bot with Google Docs knowledge base and Gemini AI
Document-Aware WhatsApp AI Bot for Customer Support Google Docs-Powered WhatsApp Support Agent 24/7 WhatsApp AI Assistant with Live Knowledge from Google Docs 📝Description Template Smart WhatsApp AI Assistant Using Google Docs Help customers instantly on WhatsApp using a smart AI assistant that reads your company’s internal knowledge from a Google Doc in real time. Built for clubs, restaurants, agencies, or any business where clients ask questions based on a policy, FAQ, or services document. ⚙️ How it works Users send free-form questions to your WhatsApp Business number (e.g. “What are the gym rules?” or “Are you open today?”) The bot automatically reads your company’s internal Google Doc (policy, schedule, etc.) It merges the document content with today’s date and the user’s question to craft a custom AI prompt The AI (Gemini or ChatGPT) then replies back on WhatsApp using natural, helpful language All conversations are logged to Google Sheets for reporting or audit > 💡Bonus: The AI even understands dates inside the document and compares them to today’s date — e.g. if your document says “Closed May 25 for 30 days,” it will say “We're currently closed until June 24. 🧰 Set up steps Connect your WhatsApp Cloud API account (Meta) Add your Google account and grant access to the Doc containing your company info Choose your AI model (ChatGPT/OpenAI or Gemini) Paste your document ID into the Google Docs node Connect your WhatsApp webhook to Meta (only takes 5 minutes) Done — start receiving and answering customer questions! > 📄 Works best with free-tier OpenAI/Gemini, Google Docs, and Meta's Cloud API (no phone required). Everything is modular, extensible, and low-code. 🔄 Customization Tips Change the Google Doc anytime to update answers — no retraining needed Add your logo and business name in the AI agent’s “System Prompt” Add fallback routes like “Escalate to human” if the bot can't help Clone for multiple brands by duplicating the workflow and swapping in new docs 🤝 Need Help Setting It Up? If you'd like help connecting your WhatsApp Business API, setting up Google Docs access, or customizing this AI assistant for your business or clients… 📩 I offer setup, branding, and customization services: WhatsApp Cloud API setup & verification Google OAuth & Doc structure guidance AI model configuration (OpenAI / Gemini) Branding & prompt tone customization Logging, reporting, and escalation logic Just send a message via: Email: tharwat.elsayed2000@gmail.com WhatsApp: +20 106 180 3236
By Tharwat MohamedResume screening & evaluation system with Gemini AI, Google Sheets & Drive for HR
🚀 AI Resume Screener (n8n Workflow Template) An AI-powered resume screening system that automatically evaluates applicants from a simple web form and gives you clear, job-specific scoring — no manual filtering needed. ⚡ What the workflow does 📄 Accepts CV uploads via a web form (PDF) 🧠 Extracts key info using AI (education, skills, job history, city, birthdate, phone) 🎯 Dynamically matches the candidate to job role criteria stored in Google Sheets 📝 Generates an HR-style evaluation and a numeric score (1–10) 📥 Saves the result in a Google Sheet and uploads the original CV to Google Drive 💡 Why you’ll love it FeatureBenefitAI scoringInstantly ranks candidate fit without reading every CVGoogle Sheet-drivenEasily update job profiles — no code changesFast setupConnect your accounts and you're live in ~15 minsScalableWorks for any department, team, or organizationDeveloper-friendlyExtend with Slack alerts, translations, or automations 🧰 Requirements 🔑 OpenAI or Google Gemini API Key 📄 Google Sheet with 2 columns: Role, Profile Wanted ☁️ Google Drive account 🌐 n8n account (self-hosted or cloud) 🛠 Setup in 5 Steps Import the workflow into n8n Connect Google Sheets, Drive, and OpenAI or Gemini Add your job roles and descriptions in Google Sheets Publish the form and test with a sample CV Watch candidate profiles and scores populate automatically 🤝 Want help setting it up? Includes free setup guidance by the creator — available by email or WhatsApp after purchase. I’m happy to assist you in customizing or deploying this workflow for your team. 📧 Email: tharwat.elsayed2000@gmail.com 💬 WhatsApp: +20106 180 3236
By Tharwat MohamedWhatsApp AI assistant for Q&A & bookings with Gemini, Pinecone & Google Sheets
Overview Turn WhatsApp chats into instant answers and real-time bookings—all in one n8n workflow. Your AI Agent leverages Gemini embeddings + Pinecone for on-the-fly knowledge retrieval, then logs reservations directly into Google Sheets. Features AI-powered Q&A: Natural-language responses driven by Gemini + Pinecone vector search Seamless Reservations: Book services via WhatsApp; entries auto-append to Google Sheets Auto-Embedding Sub-workflow: Drag-and-drop Google Drive docs get indexed in Pinecone 24-Hour Follow-Up: Automated template messages if no response within a day Personal Support Pledge: Hands-on help until your workflow runs flawlessly Requirements n8n account (self-hosted or n8n.cloud) Google Cloud project with Gemini & Drive APIs enabled Pinecone account (free tier works) Google Sheets account WhatsApp Business API credentials (e.g. Twilio, 360dialog) Setup Instructions Import Workflow Download the .json file from your Gumroad purchase In n8n Editor → Import → From File → select the JSON Add Credentials Google Service Account (Gemini & Drive APIs) Pinecone (API Key + Environment) Google Sheets OAuth2 WhatsApp Business API (HTTP credential or native) Configure Nodes AI Agent: select Gemini credentials; update system prompt with your business name & services Pinecone Loader: point “Google Drive” node to your docs folder Sheets Append: set Spreadsheet ID, sheet name “reservations”, map Timestamp, UserID, Service, Date, Time, Notes WhatsApp Trigger & Send: set webhook URL; choose approved template name Test End-to-End Activate the workflow → send a test WhatsApp message → verify AI reply + new row in your sheet Google Sheet Structure Column Description Timestamp Auto-generated when a user books UserID : Unique WhatsApp user identifier Service : Chosen service or product name Date : Booking date Time : Booking time slot Notes : Any extra information (e.g., special requests) Customization Add New Services: Edit the system prompt’s services list Change Follow-Up Window: Adjust the “24-hour window check” node logic Embed Different Docs: Point the Drive node at any folder of PDFs/TXT 📞 Personal Support Pledge: I’ll work with you (via WhatsApp or email, remote desktop ) until your workflow is running flawlessly—no extra fees, no “good luck” drop‑off. Just send a message via: Email: tharwat.elsayed2000@gmail.com WhatsApp: +20 106 180 3236
By Tharwat MohamedBook beauty appointments and answer FAQs with GPT-4, Google Calendar, Gmail, and Instagram
📝 Description Instagram AI Beauty Assistant with Booking & Calendar Automation 💄 Smart Instagram AI Assistant for Beauty & Cosmetics Brands Help customers instantly on Instagram using a smart AI assistant designed specifically for beauty, skincare, makeup, and nail businesses. This workflow answers product questions using FAQs only, handles voice messages, and schedules consultation bookings with timezone-safe Google Calendar reservations and automatic confirmation emails. Perfect for salons, cosmetic brands, clinics, and Instagram-first businesses. ⚙️ How it works Customers send messages or voice notes via Instagram DM The AI detects whether the message is: A product or policy question A voice message (which gets transcribed) A request to book a consultation or meeting Product questions are answered only using your FAQs (no hallucinations) Booking requests: Get grounded using the current date and time Check available slots before booking Collect customer details (name, phone, email, topic) Confirmed bookings are created in Google Calendar with rich event summaries A confirmation email is sent automatically to the customer 🧰 Setup steps Connect your Instagram webhook or messaging API Connect your OpenAI account (chat + voice transcription) Connect Google Calendar for reservations Connect Gmail for confirmation emails Customize your FAQs and availability rules Set your business timezone That’s it — your Instagram assistant is ready to work 24/7 ✨ 🔄 Customization tips Update FAQs anytime without retraining the AI Adjust tone and branding in the system message Customize calendar summaries and email templates Add rescheduling, cancellation, or reminders Clone the workflow for multiple beauty brands or clients 🤝 Need Help Setting It Up or Customizing It? If you’d like help connecting Instagram, setting up Google Calendar and Gmail, or customizing this AI assistant for your business or for clients… 📩 I offer setup and customization services including: Instagram DM automation setup Google Calendar & Gmail configuration Timezone-safe booking logic FAQ structuring and prompt tuning Branding and tone customization Error handling and escalation logic You can reach me here: Email: tharwat.elsayed2000@gmail.com WhatsApp: +20 106 180 3236
By Tharwat MohamedWhatsApp AI agent that understand text, image , audio
Overview 📌 This template is a multimodal WhatsApp assistant that understands text, images, and audio, aggregates media inputs, and returns intelligent replies using Google Gemini. It can fetch knowledge from Google Docs, log conversations into Google Sheets, and respond via WhatsApp — all orchestrated inside n8n. Features ✨ Multimodal input handling: Receives images and audio from WhatsApp, analyzes them, and sends contextual responses. 🖼️🎧 Audio transcription: Converts voice messages to text for analysis. 🔊➡️📝 Image analysis: Extracts objects/labels/text from images to inform responses. 🖼️🔍 Knowledge fetch: Pulls relevant documents from Google Docs for richer answers. 📄📚 Conversation logging: Appends each interaction to Google Sheets for auditing or analytics. 📈 Modular design: Clear subflows for media reception, transcription, image analysis, aggregation, and the AI Agent. ⚙️ Ready for customization: Swap models, change providers, or extend with a vector store. 🔁 Requirements ✅ n8n instance (self-hosted or n8n.cloud) with public webhook access Google Cloud project with these APIs enabled: Vertex AI (Gemini), Cloud Vision API, Cloud Speech-to-Text, Drive & Docs & Sheets 🧠 Google Service Account JSON key (with permissions for above services) 🔐 WhatsApp Business API provider credentials (Twilio, 360dialog, or similar) 📞 (Optional) Pinecone or another vector store if you want embeddings / retrieval augmentation 🗂️ Setup Instructions 🔧 Import the workflow Download the .json from your package and in n8n Editor → Import → From File → select JSON. Save. Create credentials Google Service Account: Create service account in GCP, grant Vertex AI, Vision, Speech, Drive, Docs, Sheets roles, download JSON → create n8n Google Service Account credential and upload JSON. WhatsApp: Add your WhatsApp API credentials (API key/token, phone ID, webhook secret). (Optional) Vector store: Add Pinecone credentials if using embeddings. Configure media receiver nodes WhatsApp Trigger: Ensure webhook URL is set on your WhatsApp provider to forward incoming messages/media to n8n. 🌐 Audio Receiver nodes: point to incoming audio payload path or download URL. 🎧 Image Receiver nodes: point to image URL or attachment field. 🖼️ Transcription & Image Analysis Transcribe Audio: Select Google Speech-to-Text via your Google Service Account credential. Confirm language and sampling settings. 🗣️➡️📝 Analyze Image: Point to Vision API via same Google credential. Choose required outputs (labels, landmarks, OCR). 🔎 Aggregate media Confirm the Aggregate node collects text + transcribed audio + image analysis results into a single payload for the AI Agent. 🧩 AI Agent (Gemini) Open AI Agent node → choose your Google Gemini/Vertex AI credentials. Edit System Prompt to include: how to prioritize image/audio text, where to look up knowledge (Docs), and style/tone. Replace placeholders (business name, policies). ✍️ Knowledge Fetch (Google Docs) Configure Get a document in Google Docs node to point to your knowledge docs folder or specific document IDs. 📂 Conversation Logging Configure Google Sheets node to append rows to your chosen spreadsheet (structure below). 🧾 WhatsApp Reply Map AI Agent output to the WhatsApp Send message node and choose template messaging if needed. 💬 Test end-to-end Activate the workflow, send a text message, an image, and an audio message to your WhatsApp test number. Verify the AI reply and that logs appear in Google Sheets. 🧪 Google Sheet: Conversation Log (suggested columns) 🗒️ Column Type Description Timestamp Date/Time When the message arrived UserID Text WhatsApp user identifier (phone) MessageType Text text / image / audio / mixed MessageText Text Original text or transcribed text ImageAnalysis Text Vision API summary / labels / OCR text AttachmentURL Text Link to image/audio file AIResponse Text Final text reply sent to user Notes Text Any extra flags (e.g., escalation) Customization 🔁 Swap Gemini with another model provider by changing the AI node credentials and prompt structure. 🔄 Add a vector store (Pinecone) to enable retrieval-augmented generation from indexed docs. 🧠 Extend image analysis to OCR for receipts/invoices or barcode detection. 📑 Add an escalation path (send to human) by adding an “If → Escalate” node when confidence is low. 🚨 Suggested Node Renaming (for clarity) 🏷️ Rename generic nodes to explicit names so reviewers and users instantly understand flow: WhatsApp Trigger → WhatsApp Trigger (Inbound) Switch → Message Type Router audio receiver1/2 → Audio Receiver (Download) / Audio Receiver (Fallback) 🎧 Transcribe a recording → Transcribe Audio (Speech-to-Text) 📝 image receiver1/2 → Image Receiver (Download) / Image Receiver (Fallback) 🖼️ Analyze image → Image Analysis (Vision API) 🔍 Aggregate → Aggregate Media Inputs 🧩 AI Agent → Multimodal AI Agent (Gemini) 🤖 Get a document in Google Docs → Fetch Knowledge Doc 📂 Code → Format AI Response 🧾 Send message → WhatsApp – Send Reply 💬 Testing & Going Live 🚀 Ensure n8n webhook is publicly reachable (use an SSL domain/tunnel). 🔒 Test in a sandbox WhatsApp number first. 🧪 Monitor n8n Executions and enable an Error Workflow for graceful failure handling. ⚠️ If you expect high media volume, consider storage/retention policy for attachments. 🗄️ Support & Notes 🤝 I offer setup assistance and will help troubleshoot credential issues or prompt tuning until your workflow is working perfectly. Include contact info and a short support pledge in your template description to build trust. Feel free to ping me anytime—even after launch!👉 Contact: tharwat.elsayed2000@gmail.com | +20 106 180 3236
By Tharwat Mohamed