Workflow Templates

Build an AI Research Assistant for WhatsApp with Perplexity and Claude 💡 Ever wished you could get a deep, multi-source research report on any topic, delivered directly to your WhatsApp chat in seconds? This workflow transforms your WhatsApp into a powerful, on-demand research assistant, perfect for students, professionals, and curious minds. Leveraging the deep research capabilities of Perplexity, the nuanced formatting skills of Anthropic's Claude, and the messaging power of Twilio, this workflow automates the entire process from query to polished answer. Ask it anything, and receive a well-structured, easy-to-read summary moments later. What This Workflow Does 🚀 📲 Listens for Incoming Queries: The workflow starts when a user sends a message to your configured Twilio WhatsApp number. 🧠 Performs Deep Research: It takes the user's query and feeds it to the Perplexity node, which uses the sonar-pro model to conduct a comprehensive, multi-source analysis on the topic. 🎨 Polishes the Content: The raw, detailed research report from Perplexity is then passed to an Anthropic Claude model. This crucial step refines the text, adds engaging emojis, ensures it's under the WhatsApp character limit, and formats it perfectly for mobile viewing. 💬 Sends an Instant Reply: The final, beautifully formatted summary is sent directly back to the user's WhatsApp chat via Twilio, completing the entire request. Nodes Used 🛠️ Webhook: To receive the initial message from Twilio and trigger the workflow. Perplexity: To perform the AI-powered deep research on the user's query. Anthropic (via LangChain): To connect to and use the Claude model for reformatting and polishing the content. Twilio: To send the final, formatted message back to the user on WhatsApp. How to Set Up This Workflow ⚙️ This workflow requires careful setup between n8n and Twilio to function correctly. Follow these steps closely. 1\. Prerequisites ✅ You will need accounts for the following services: n8n (Cloud or self-hosted) Twilio Perplexity AI (for an API key) Anthropic (for a Claude API key) 2\. Configure Credentials 🔑 In your n8n instance, add your API keys for Twilio, Perplexity, and Anthropic. You can add credentials in n8n by going to the Credentials tab in the left-hand menu. Learn more about managing credentials in n8n. 3\. Set Up Your Twilio WhatsApp Number 📱 Log in to your Twilio account. Either purchase a phone number that is WhatsApp-enabled or use the free Twilio Sandbox for WhatsApp for testing. Follow Twilio's guide to connect your number or sandbox to the WhatsApp Business API. Read Twilio's Getting Started with WhatsApp Guide. 4\. Expose Your n8n Webhook URL 🌐 For Twilio to communicate with n8n, your n8n webhook URL must be publicly accessible. Open the Fetch Whatsapp Request (Webhook) node in the workflow. You will see two URLs: Test and Production. For this guide, we will use the Test URL. If you are running n8n locally or on a private server, you must expose this URL to the public internet. You can do this easily using n8n's built-in tunnel feature. Start n8n from your computer's command line with the following command: n8n start --tunnel After starting, n8n will provide you with a public "tunnel URL". It will look something like https://[subdomain].hooks.n8n.cloud/. Copy this public tunnel URL. Learn more about tunneling in the n8n docs. 5\. Connect Twilio to Your n8n Webhook 🔗 In your Twilio Console, navigate to the settings for the phone number (or sandbox) you configured in Step 3. Scroll down to the Messaging section. Find the field labeled "A MESSAGE COMES IN". Paste your n8n Test URL (or your public tunnel URL from the previous step) into this field. Ensure the dropdown next to it is set to HTTP POST. Click Save. 6\. Activate and Test Your Workflow ▶️ Go back to your n8n canvas. Click "Test workflow" in the top right corner. This will put your webhook in a "listening" state. Now, send a message from your personal WhatsApp to your configured Twilio WhatsApp number. You should see the workflow execute successfully in n8n and receive a formatted reply on WhatsApp\! Once you've confirmed it works, save and activate the workflow to have it run permanently. Further Reading 📚 n8n Webhook Node Documentation n8n Twilio Node Documentation Perplexity API Documentation Anthropic API Documentation

[LI] – Search Profiles > ⚠️ Self-hosted disclaimer: > This workflow uses the SerpAPI community node, which is available only on self-hosted n8n instances. > For n8n Cloud, you may need to use an HTTP Request node with the SerpAPI REST API instead. Who’s it for Recruiters, talent sourcers, SDRs, and anyone who wants to automatically gather public LinkedIn profiles from Google search results based on keywords — across multiple pages — and log them to a Google Sheet for further analysis. What it does / How it works This workflow extends the standard LinkedIn profile search to include pagination, allowing you to fetch results from multiple Google result pages in one go. Here’s the step-by-step process: Form Trigger – “LinkedIn Search” Collects: Keywords (comma separated) – e.g., python, fintech, warsaw Pages to fetch – number of Google pages to scrape (each page ≈ 10 results) Triggers the workflow when submitted. Format Keywords (Set) Converts the keywords into a Google-ready query string: ("python") ("fintech") ("warsaw") These parentheses improve relevance in Google searches. Build Page List (Code) Creates a list of pages to iterate through. For example, if “Pages to fetch” = 3, it generates 3 search batches with proper start offsets (0, 10, 20). Keeps track of: Grouped keywords (keywordsGrouped) Raw keywords Submission timestamp Loop Over Items (Split In Batches) Loops through the page list one batch at a time. Sends each batch to SerpAPI Search and continues until all pages are processed. SerpAPI Search Queries Google with: site:pl.linkedin.com/in/ ("keyword1") ("keyword2") ("keyword3") Fixed to the Warsaw, Masovian Voivodeship, Poland location. The start parameter controls pagination. Check how many results are returned (Switch) If no results → Triggers No profiles found. If results found → Passes data forward. Split Out Extracts each LinkedIn result from the organic_results array. Get Full Name to property of object (Code) Extracts a clean full name from the search result title (text before “–” or “|”). Append profile in sheet (Google Sheets) Saves the following fields into your connected sheet: | Column | Description | |---------|-------------| | Date | Submission timestamp | | Profile | Public LinkedIn profile URL | | Full name | Extracted candidate name | | Keywords | Original keywords from the form | Loop Over Items (continue) After writing each batch, it loops to the next Google page until all pages are complete. Form Response (final step) Sends a confirmation back to the user after all pages are processed: Check linked file 🧾 Google Sheets Setup Before using the workflow, prepare your Google Sheet with these columns in row 1: | Column Name | Description | |--------------|-------------| | Date | Automatically filled with the form submission time | | Profile | LinkedIn profile link | | Full name | Extracted name from search results | | Keywords | Original search input | > You can expand the sheet to include optional fields like Snippet, Job Title, or Notes if you modify the mapping in the Append profile in sheet node. Requirements SerpAPI account* – with API key stored securely in *n8n Credentials**. Google Sheets OAuth2 credentials** – connected to your target sheet with edit access. n8n instance (Cloud or self-hosted)** > Note: SerpAPI node is part of the Community package and may require self-hosted n8n. How to set up Import the [LI] - Search profiles workflow into n8n. Connect your credentials: SerpAPI – use your API key. Google Sheets OAuth2 – ensure you have write permissions. Update the Google Sheets node to point to your own spreadsheet and worksheet. (Optional) Edit the location field in SerpAPI Search for different regions. Activate the workflow and open the public form (via webhook URL). Enter your keywords and specify the number of pages to fetch. How to customize the workflow Change search region:** Modify the location in the SerpAPI node or change the domain to site:linkedin.com/in/ for global searches. Add pagination beyond 3–4 pages:** Increase “Pages to fetch” — but note that excessive pages may trigger Google rate limits. Avoid duplicates:* Add a *Google Sheets → Read* + *IF** node before appending new URLs. Add notifications:* Add *Slack, **Discord, or Email nodes after Google Sheets to alert your team when new data arrives. Capture more data:** Map additional fields like title, snippet, or position into your Sheet. Security notes Never store API keys directly in nodes — always use n8n Credentials. Keep your Google Sheet private and limit edit access. Remove identifying data before sharing your workflow publicly. 💡 Improvement suggestions | Area | Recommendation | Benefit | |-------|----------------|----------| | Dynamic location | Add a “Location” field to the form and feed it to SerpAPI dynamically. | Broader and location-specific searches | | Rate limiting | Add a short Wait node (e.g., 1–2s) between page fetches. | Prevents API throttling | | De-duplication | Check for existing URLs before appending. | Prevents duplicates | | Logging | Add a second sheet or log file with timestamps per run. | Easier debugging and tracking | | Data enrichment | Add a LinkedIn or People Data API enrichment step. | Collect richer candidate data | ✅ Summary: This workflow automates the process of searching public LinkedIn profiles from Google across multiple pages. It formats user-entered keywords into advanced Google queries, iterates through paginated SerpAPI results, extracts profile data, and stores it neatly in a Google Sheet — all through a single, user-friendly form.

Automated Web Form Data Collection and Storage to Google Sheets Overview This n8n workflow allows you to collect data from a web form and automatically store it in a Google Sheet. It includes data cleanup, date stamping, optional batching, and throttling for smooth handling of single or bulk submissions. What It Does Accepts data submitted from a frontend form via HTTP POST Cleans and structures the incoming JSON data Adds the current date automatically Appends structured data into a predefined Google Sheet Supports optional batch processing and a wait/delay mechanism to control data flow Features Webhook trigger for external form submissions JavaScript-based data cleaning and formatting Looping and delay nodes to manage bulk submissions Direct integration with Google Sheets via OAuth2 Fully mapped columns to match sheet structure Custom date field (submitted_date) auto-generated per entry Who’s It For This workflow is perfect for: Developers or marketers collecting lead data via online forms Small businesses tracking submissions from landing pages or contact forms Event organizers managing RSVP or booking forms Anyone needing to collect and store structured data in Google Sheets automatically Prerequisites Make sure the following are ready before use: An n8n instance (self-hosted or cloud) A Google account with edit access to the target Google Sheet Google Sheets OAuth2 API credentials** configured in n8n A web form or app capable of sending POST requests with the following fields: business_name location whatsapp email name Google Sheet Format Ensure your Google Sheet contains the following exact column names (case-sensitive): | Business Name | Location | WhatsApp Number | Email | Name | Date | |---------------|------------|------------------|----------------------|----------------|------------| | SpaGreen | Bangladesh | 8801322827753 | spagreen@gmail.com | Abdul Mannan | 2025-09-14 | | Dev Code Journey | Bangladesh | 8801322827753 | admin@gmail.com | Shakil Ahammed | 2025-09-14 | > Note: The "Email" column includes a trailing space — this must match exactly in both the sheet and column mapping settings. Setup Instructions 1. Configure Webhook Use the Webhook node with path: /93a81ced-e52c-4d31-96d2-c91a20bd7453 Accepts POST requests from a frontend form or application 2. Clean Incoming Data The JavaScript (Code) node extracts the submitted fields Adds a submitted_date in YYYY-MM-DD format 3. Loop Over Items (Optional for Batches) The Split In Batches node allows handling bulk form submissions For single entries, the workflow still works without adjustment 4. Append to Google Sheet The Google Sheets node appends each submission as a new row Mapped fields include: Business Name Location WhatsApp Number Email Name Date (auto-filled) 5. Add Delay (Optional) The Wait node adds a 5-second delay per loop Helps throttle requests when handling large batches How to Use It Clone or import the workflow into your n8n instance Update the Webhook URL in your frontend form’s POST action Connect your Google Sheets account in the Google Sheets node Confirm that your target sheet matches the required column structure Start sending data from your form — new entries will appear in your sheet automatically > This setup ensures form submissions are received, cleaned, stored efficiently, and processed in a controlled manner. Notes Use the Sticky Notes in the workflow to understand each node’s purpose You can modify the delay duration or disable looping for single submissions For added security, consider securing your webhook with headers or tokens Ideal Use Cases Contact forms Lead capture pages Event signups or bookings Newsletter or email list opt-ins Surveys or feedback forms Support WhatsApp Support: Chat Now Discord: Join SpaGreen Community Facebook Group: SpaGreen Support Website: spagreen Developer Portfolio: Codecanyon SpaGreen

This workflow automates the process of receiving vendor quotations, extracting and summarizing their contents using AI, and logging the results for comparison. The system listens for new file uploads via webhook, processes each file using a summarization engine, and generates a well-formatted summary table that is stored in Google Sheets and sent via email to stakeholders. Good to Know Saves hours of manual work** by auto-comparing multiple vendor quotations. Uses AI summarization** to intelligently identify highlights and differences in each quote. Supports structured summaries** for quick stakeholder decision-making. Maintains a Google Sheets log** for historical comparison and auditing. Email notifications** ensure stakeholders receive real-time updates. How It Works 1. Upload Quotes Webhook trigger that listens for uploaded vendor quotation files (PDF, Excel, or Docs). 2. Extract File Data Parses the uploaded file and extracts relevant quote data (price, items, vendor name, etc.). 3. AI Summarization Sends extracted data to an AI API (Grok) to generate a human-readable comparison summary. 4. Wait For Reply Pauses the workflow until the AI response is fully received. 5. Format Summary Formats the AI-generated content into a structured summary (e.g., table format or comparison bullets). 6. Log to Google Sheets Appends the formatted summary to a Google Sheet for tracking and reference. 7. Send Email Emails the summary to predefined recipients (procurement, finance, etc.). Data Sources Uploaded Vendor Quotation Files** – Typically in PDF, DOCX, or Excel format containing vendor proposals. AI API (Grok)** – Processes the quote data and returns a summarized comparison. How to Use Import the workflow into your n8n instance (self-hosted or cloud). Configure the Webhook URL to receive file uploads. Set up file extraction logic in the “Extract File Data” node to match your file format. Configure your Grok API credentials in the “AI Summarization” node. Connect your Google Sheets account to the “Log to Google Sheets” node. Customize the recipient email address in the “Send Email” node. Test with sample quotation files to validate the entire flow. Requirements Self-hosted n8n instance** (if using community nodes). API key for Grok** or another AI summarization service. Google account access** to log summary data to Sheets. Mail credentials** for sending automated emails (SMTP setup). File parsing logic** (for PDFs, DOCX, Excel) depending on your vendor formats. Customizing This Workflow Modify the Extract File Data node** to support additional quote formats or fields. Enhance AI Summarization** with custom prompts or models for industry-specific terms. Format output into a PDF summary** or comparison chart if needed. Add Slack/Teams integration** for real-time team alerts. Apply filters** to compare only specific vendors or line items.

Automatically detects and hides hate speech/toxic comments, alerts your team, and logs flagged content for review. Workflow Overview Trigger**: A Schedule node runs every 15 minutes to poll for new comments (Instagram doesn't natively push notifications easily, so polling is used). You could replace this with a Webhook if you set up Instagram webhooks via Graph API. Scan Comments**: Uses Instagram Graph API (via HTTP Request) to fetch recent posts and their comments. Assumes you have an Instagram Business Account and a valid access token (from Facebook Developer Portal). Detect Toxicity**: For each comment, it sends the text to Google's Perspective API (a free toxicity detection API; sign up at https://perspectiveapi.com/ for an API key). Threshold for "toxic" is set to >0.7 toxicity score (configurable). Auto-Hide Offensive Ones**: If toxic, uses Instagram API to hide the comment. Alert Team**: Sends a Slack notification (or email; configurable) with details. Store Evidence**: Appends the toxic comment details (text, user, score, timestamp) to a Google Sheet for auditing. Error Handling**: Basic error node to notify if API calls fail. Business Value Alignment**: This automates protection, reducing manual moderation and building trust. Prerequisites: n8n installed (self-hosted or cloud). Instagram Graph API access token (set in n8n credentials or as environment variable). Perspective API key (free tier available). Slack webhook or email credentials. Google Sheets API credentials (for storage). How to Import In n8n, go to the workflows list. Click "Import from JSON" (or paste into a new workflow). Update placeholders: Replace YOUR_INSTAGRAM_ACCESS_TOKEN with your token. Replace YOUR_PERSPECTIVE_API_KEY with your key. Set up credentials for HTTP Request (Instagram), Slack, and Google Sheets. Adjust YOUR_INSTAGRAM_BUSINESS_ACCOUNT_ID and YOUR_MEDIA_ID (or make it dynamic). Test and activate. If you encounter issues (e.g., API rate limits), adjust the schedule or add waits. Notes on Customization Looping**: The "Loop Over Comments" uses SplitInBatches to process comments one by one, avoiding API rate limits. Toxicity API**: I used Perspective API as it's reliable and free for low volume. If you prefer another (e.g., Hugging Face), swap the HTTP Request body. Instagram API**: This fetches comments for the first recent post (simplified). To handle multiple posts, add another loop. Alerts**: Slack is used; change to Email node if preferred. Storage**: Google Sheets for simplicity; could be swapped for MongoDB or Airtable. Sticky Notes**: Three notes explain phases – they won't affect execution but help in the UI. Testing**: Start with test data. Instagram API requires app review for production.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Transform Complex Research Papers into Accessible Summaries This workflow automatically generates multiple types of summaries from research papers, making complex academic content accessible to different audiences. By combining PDF Vector's advanced parsing capabilities with GPT-4's language understanding, researchers can quickly digest papers outside their expertise, communicate findings to diverse stakeholders, and create social media-friendly research highlights. Target Audience & Problem Solved This template is designed for: Research communicators** translating complex findings for public audiences Journal editors** creating accessible abstracts and highlights Science journalists** quickly understanding technical papers Academic institutions** improving research visibility and impact Funding agencies** reviewing large volumes of research outputs It solves the critical challenge of research accessibility by automatically generating summaries tailored to different audience needs - from technical experts to the general public. Prerequisites n8n instance with PDF Vector node installed OpenAI API key with GPT-4 or GPT-3.5 access PDF Vector API credentials Basic understanding of webhook setup Optional: Slack/Email integration for notifications Minimum 20 API credits per paper summarized Step-by-Step Setup Instructions Configure API Credentials Navigate to n8n Credentials section Add PDF Vector credentials with your API key Add OpenAI credentials with your API key Test both connections to ensure they work Set Up the Webhook Endpoint Import the workflow template into n8n Note the webhook URL from the "Webhook - Paper URL" node This URL will receive POST requests with paper URLs Example request format: { "paperUrl": "https://example.com/paper.pdf" } Configure Summary Models Review the OpenAI model settings in each summary node GPT-4 recommended for executive and technical summaries GPT-3.5-turbo suitable for lay and social media summaries Adjust temperature settings for creativity vs accuracy Customize Output Formats Modify the "Combine All Summaries" node for your needs Add additional fields or metadata as required Configure response format (JSON, HTML, plain text) Test the Workflow Use a tool like Postman or curl to send a test request Monitor the execution for any errors Verify all four summary types are generated Check response time and adjust timeout if needed Implementation Details The workflow implements a sophisticated summarization pipeline: PDF Parsing: Uses LLM-enhanced parsing for accurate extraction from complex layouts Parallel Processing: Generates all summary types simultaneously for efficiency Audience Targeting: Each summary type uses specific prompts and constraints Quality Control: Structured prompts ensure consistent, high-quality outputs Flexible Output: Returns all summaries in a single API response Customization Guide Adding Custom Summary Types: Create new summary nodes with specialized prompts: // Example: Policy Brief Summary { "content": "Create a policy brief (max 300 words) highlighting: Policy-relevant findings Recommendations for policymakers Societal implications Implementation considerations Paper content: {{ $json.content }}" } Modifying Summary Lengths: Adjust word limits in each summary prompt: // In Executive Summary node: "max 500 words" // Change to your desired length // In Tweet Summary node: "max 280 characters" // Twitter limit Adding Language Translation: Extend the workflow with translation nodes: // After summary generation, add: "Translate this summary to Spanish: {{ $json.executiveSummary }}" Implementing Caching: Add a caching layer to avoid reprocessing: Use Redis or n8n's static data Cache based on paper DOI or URL hash Set appropriate TTL for cache entries Batch Processing Enhancement: For multiple papers, modify the workflow: Accept array of paper URLs Use SplitInBatches node for processing Aggregate results before responding Summary Types: Executive Summary: 1-page overview for decision makers Technical Summary: Detailed summary for researchers Lay Summary: Plain language for general audience Social Media: Tweet-sized key findings Key Features: Parse complex academic PDFs with LLM enhancement Generate multiple summary types simultaneously Extract and highlight key methodology and findings Create audience-appropriate language and depth API-driven for easy integration Advanced Features Quality Metrics: Add a quality assessment node: // Evaluate summary quality const qualityChecks = { hasKeyFindings: summary.includes('findings'), appropriateLength: summary.length <= maxLength, noJargon: !technicalTerms.some(term => summary.includes(term)) }; Template Variations: Create field-specific templates: Medical research: Include clinical implications Engineering papers: Focus on technical specifications Social sciences: Emphasize methodology and limitations

Dynamic Search Interface with Elasticsearch and Automated Report Generation 🎯 What this workflow does This template creates a comprehensive data search and reporting system that allows users to query large datasets through an intuitive web form interface. The system performs real-time searches against Elasticsearch, processes results, and automatically generates structured reports in multiple formats for data analysis and business intelligence. Key Features: 🔍 Interactive web form for dynamic data querying ⚡ Real-time Elasticsearch data retrieval with complex filtering 📊 Auto-generated reports (Text & CSV formats) with custom formatting 💾 Automatic file storage system for data persistence 🎯 Configurable search parameters (amounts, time ranges, entity filters) 🔧 Scalable architecture for handling large datasets 🛠️ Setup requirements Prerequisites Elasticsearch cluster** running on https://localhost:9220 Transaction dataset** indexed in bank_transactions index Sample dataset**: Download from Bank Transaction Dataset File system access** to /tmp/ directory for report storage HTTP Basic Authentication** credentials for Elasticsearch Required Elasticsearch Index Structure This template uses the Bank Transaction Dataset from GitHub: https://github.com/dataminexcode/n8n-workflow/blob/main/Dynamic%20Search%20Interface%20with%20Elasticsearch%20and%20Automated%20Report%20Generation/data You can use this python script for importing the csv file into elasticsearch: Python script for importing data Your bank_transactions index should contain documents with these fields: { "transaction_id": "TXN_123456789", "customer_id": "CUST_000001", "amount": 5000, "merchant_category": "grocery_net", "timestamp": "2025-08-10T15:30:00Z" } Dataset Info: This dataset contains realistic financial transaction data perfect for testing search algorithms and report generation, with over 1 million transaction records including various transaction patterns and data types. Credentials Setup Create HTTP Basic Auth credentials in n8n Configure with your Elasticsearch username/password Assign to the "Search Elasticsearch" node ⚙️ Configuration 1. Form Customization Webhook Path**: Update the webhook ID if needed Form Fields**: Modify amounts, time ranges, or add new filters Validation**: Adjust required fields based on your needs 2. Elasticsearch Configuration URL**: Change localhost:9220 to your ES cluster endpoint Index Name**: Update bank_transactions to your index name Query Logic**: Modify search criteria in "Build Search Query" node Result Limit**: Adjust the size: 100 parameter for more/fewer results 3. File Storage Directory**: Change /tmp/ to your preferred storage location Filename Pattern**: Modify fraud_report_YYYY-MM-DD.{ext} format Permissions**: Ensure n8n has write access to the target directory 4. Report Formatting CSV Headers**: Customize column names in the Format Report node Text Layout**: Modify the report template for your organization Data Fields**: Add/remove transaction fields as needed 🚀 How to use For Administrators: Import this workflow template Configure Elasticsearch credentials Activate the workflow Share the webhook URL with data analysts For Data Analysts: Access the search interface via the webhook URL Set parameters: Minimum amount, time range, entity filter Choose format: Text report or CSV export Submit form to generate instant data report Review results in the generated file Sample Use Cases: Data analysis**: Search for transactions > $10,000 in last 24 hours Entity investigation**: Filter all activity for specific customer ID Pattern analysis**: Quick analysis of transaction activity patterns Business reporting**: Generate CSV exports for business intelligence Dataset testing**: Perfect for testing with the transaction dataset 📊 Sample Output Text Report Format: DATA ANALYSIS REPORT Search Criteria: Minimum Amount: $10000 Time Range: Last 24 Hours Customer: All Results: 3 transactions found TRANSACTIONS: Transaction ID: TXN_123456789 Customer: CUST_000001 Amount: $15000 Merchant: grocery_net Time: 2025-08-10T15:30:00Z CSV Export Format: Transaction_ID,Customer_ID,Amount,Merchant_Category,Timestamp "TXN_123456789","CUST_000001",15000,"grocery_net","2025-08-10T15:30:00Z" 🔧 Customization ideas Enhanced Analytics Features: Add data validation and quality checks Implement statistical analysis (averages, trends, patterns) Include data visualization charts and graphs Generate summary metrics and KPIs Advanced Search Capabilities: Multi-field search with complex boolean logic Fuzzy search and text matching algorithms Date range filtering with custom periods Aggregation queries for data grouping Integration Options: Email notifications**: Alert teams of significant data findings Slack integration**: Post analytics results to team channels Dashboard updates**: Push metrics to business intelligence systems API endpoints**: Expose search functionality as REST API Report Enhancements: PDF generation**: Create formatted PDF analytics reports Data visualization**: Add charts, graphs, and trending analysis Executive summaries**: Include key metrics and business insights Export formats**: Support for Excel, JSON, and other data formats 🏷️ Tags elasticsearch, data-search, reporting, analytics, automation, business-intelligence, data-processing, csv-export 📈 Use cases Business Intelligence**: Organizations analyzing transaction patterns and trends E-commerce Analytics**: Detecting payment patterns and customer behavior analysis Data Science**: Real-time data exploration and pattern recognition systems Operations Teams**: Automated reporting and data monitoring workflows Research & Development**: Testing search algorithms and data processing techniques Training & Education**: Learning Elasticsearch integration with realistic datasets Financial Technology**: Transaction data analysis and business reporting systems ⚠️ Important notes Security Considerations: Never expose Elasticsearch credentials in logs or form data Implement proper access controls for the webhook URL Consider encryption for sensitive data processing Regular audit of generated reports and access logs Performance Tips: Index optimization improves search response times Consider pagination for large result sets Monitor Elasticsearch cluster performance under load Archive old reports to manage disk usage Data Management: Ensure data retention policies align with business requirements Implement audit trails for all search operations Consider data privacy requirements when processing datasets Document all configuration changes for maintenance This template provides a production-ready data search and reporting system that can be easily customized for various data analysis needs. The modular design allows for incremental enhancements while maintaining core search and reporting functionality.

🧠 Sentiment Analysis of Product Reviews using Google Sheets & OpenAI 🚀 Quick Implementation Steps Automated customer feedback analyzer: Trigger**: Google Sheets triggers on new product review rows. Sentiment Analysis**: Review text sent to OpenAI. Writeback**: Resulting sentiment (Positive, Neutral, Negative) is written back to the sheet. Just connect your credentials and sheet — you're ready to go! 🔍 What It Does This workflow automatically analyzes user-submitted product reviews and classifies them by sentiment using OpenAI’s powerful language models. It eliminates the need to manually sift through feedback by tagging each review with a sentiment score. The sentiment result is then written back to the Google Sheet next to the original review, enabling you to get a fast, clear snapshot of overall customer perception, satisfaction and pain points. Whether you're monitoring 10 or 10,000 reviews, this process scales effortlessly and updates every minute. 👤 Who’s It For This workflow is designed for: E-commerce teams** collecting user reviews. Product teams** monitoring customer feedback. Marketing teams** identifying promotable reviews. Support teams** watching for negative experiences. SaaS platforms**, apps, and survey tools managing structured text feedback. ✅ Requirements You’ll need: A Google Sheet with two columns: Review and Sentiment Google Sheets OAuth2 credentials in n8n OpenAI API Key (for GPT-4o-mini or GPT-3.5) n8n instance with LangChain and OpenAI nodes enabled ⚙️ How It Works Google Sheets Trigger: Watches for new rows every minute OpenAI Integration: Uses LangChain’s Sentiment Analysis node Passes review text into GPT-4o-mini via the OpenAI Chat Model node Sheet Update: The sentiment result (Positive, Negative, or Neutral) is written into the Sentiment column in the same row. Sticky Notes included for better visual understanding inside the workflow editor. 🛠️ Steps to Configure and Use 1. Prepare Your Google Sheet Make sure your sheet is named Sheet1 with the following structure: | Review | Sentiment | |---------------------------------------|-----------| | Absolutely love it! | | | Not worth the price. | | 2. Set Up Credentials Google Sheets**: OAuth2 credentials OpenAI**: API Key added via OpenAI API credential in n8n 3. Import & Activate Workflow Import the workflow JSON into your n8n instance. Assign the proper credentials to the trigger and OpenAI nodes. Activate the workflow. 🧩 How To Customize 🛎️ Alerting: Add Slack/Email nodes for negative sentiment alerts 🔄 Triggering: Change the polling interval to real-time triggers (e.g., webhook) 📊 Extended Sentiment: Modify sentiment categories (e.g., "Mixed", "Sarcastic") 🧾 Summary Report: Add Cron + Aggregation nodes for daily/weekly summaries 🧠 Prompt Tuning: Adjust system prompt for deeper or context-based sentiment evaluation 🧱 Add‑ons (Optional Features) Email Digest of Negative Reviews Google Drive Logging Team Notification via Slack Summary to Notion, Airtable, or Google Docs 📌 Use Case Examples Online Stores**: Auto-tag reviews for reputation monitoring Product Teams**: See which feature releases generate positive or negative buzz CX Dashboards**: Feed real-time sentiment to internal BI tools Marketing**: Extract glowing reviews for social proof Support**: Triage issues by flagging critical comments instantly ...and many more applications wherever text feedback is collected. 🧰 Troubleshooting Guide | Issue | Possible Cause | Suggested Fix | |-------------------------|---------------------------------------------|---------------------------------------------------| | Sentiment not updating | Sheet credentials missing or misconfigured | Reconnect Google Sheets OAuth2 | | Blank sentiment | Review column empty or misaligned | Ensure proper column header & value present | | OpenAI errors | Invalid or expired API key | Regenerate API Key from OpenAI and re-auth | | Workflow doesn’t run | Polling settings incorrect | Confirm interval & document ID in trigger node | 🤝 Need Help? If you need assistance for ✅ Help setting up this workflow ⚙️ Customizing prompts or output 🚀 Automating your full review pipeline 👉 Contact us today at WeblineIndia. We will be happy to assist.

🎁 Verified Referral Reward Notification Workflow Overview Transform your referral program into a fully automated, fraud-resistant system that delivers professional rewards to verified referrers. This workflow combines email validation, dynamic coupon generation with visual design, automated email delivery, and comprehensive tracking—all without manual intervention. What This Workflow Does 1. Receives Referral Submissions Accepts form submissions via webhook (compatible with Jotform, Typeform, Google Forms, or any webhook-enabled form) Captures referrer details, email, referred friend, and campaign information 2. Validates Email Addresses Prevents fraud and abuse by verifying email authenticity using VerifiEmail API Checks for disposable emails, invalid formats, and non-existent addresses Ensures high deliverability rates for reward emails 3. Generates Personalized Coupon Cards Creates unique coupon codes with smart formatting (e.g., REF-JOHN1234) Designs beautiful HTML/CSS coupon cards with gradient backgrounds and professional styling Converts HTML to high-quality PNG images using HTMLCSStoImage API 4. Sends Professional Reward Emails Delivers branded thank-you emails with embedded coupon images Includes both visual coupon card and text-based coupon code Personalized with referrer's name and campaign details 5. Tracks Everything in Google Sheets Logs successful rewards with timestamps, coupon codes, and image URLs Records failed verifications for analysis and optimization Provides audit trail and performance metrics 6. Handles Invalid Submissions Gracefully Sends polite notification emails for failed verifications Explains possible reasons (typos, disposable emails, invalid formats) Encourages users to correct and resubmit Perfect For E-commerce stores running referral programs SaaS companies with customer referral incentives Marketing agencies managing client referral campaigns Any business wanting to automate reward distribution Companies needing fraud prevention in their referral systems Key Benefits ✅ Fraud Prevention - Email verification stops fake submissions ✅ Professional Branding - Beautiful, customizable coupon designs ✅ Full Automation - Zero manual work after setup ✅ Complete Tracking - Every submission logged with full details ✅ High Deliverability - Only sends to verified, valid emails ✅ Scalable - Handles unlimited submissions automatically ✅ Analytics Ready - Google Sheets data ready for reporting and dashboards Technical Highlights Conditional logic for valid/invalid email paths Dynamic HTML generation with inline CSS Image rendering for visual coupons Error handling and graceful degradation Comprehensive logging for both success and failure paths Use Cases Referral Marketing Programs - Reward customers for bringing friends Ambassador Programs - Incentivize brand advocates Holiday Campaigns - Run seasonal referral promotions Growth Marketing - Scale word-of-mouth acquisition Partner Programs - Automate partner referral rewards Required Services & APIs Free Tier Available: VerifiEmail** - Email verification (https://verifi.email) HTMLCSStoImage** - HTML to image conversion (https://htmlcsstoimg.com) Google Services (Free): Gmail** - Email sending via OAuth Google Sheets** - Data tracking and logging Form Options (Any webhook-enabled service): Jotform Typeform Google Forms (via extensions) Tally Any custom form with webhook support Setup Time ⏱️ 15-20 minutes (including credential setup and testing) Skill Level 🎯 Beginner-Friendly - Detailed documentation and sticky notes guide you through every step What You'll Need Before Starting Gmail account with 2FA enabled Google Sheet for tracking (template provided in documentation) VerifiEmail API key (free signup) HTMLCSStoImage API key (free signup) Form platform with webhook capability Customization Options Modify coupon discount percentage Change HTML/CSS design and branding Customize email templates Adjust coupon code format Add additional data fields Integrate with CRM or marketing tools A/B test different coupon designs Set validity periods dynamically Featured Community Workflows Submission Notes Why This Workflow Deserves to be Featured: Solves Real Business Problem - Referral fraud is a genuine issue costing businesses money. This workflow provides an elegant solution. Production Ready - Not a demo or proof-of-concept. This is battle-tested code ready for real-world use. Comprehensive Documentation - Every node has detailed sticky notes explaining purpose, configuration, and data flow. Beginner Accessible - Despite sophistication, clear documentation makes it approachable for n8n newcomers. Scalable Architecture - Handles both success and failure paths gracefully with proper error handling. Multi-Service Integration - Demonstrates best practices for connecting multiple APIs and Google services. Visual Excellence - Generates beautiful, professional coupon cards that enhance brand perception. Analytics Built-In - Google Sheets integration enables immediate tracking and reporting. Customizable Template - Easy to adapt for different industries, brands, and use cases. Community Value - Provides a foundation others can build upon and learn from. Business Impact: Reduces manual work by 100% Cuts fraudulent referrals by ~70-80% Improves customer experience with instant rewards Provides actionable data for marketing optimization Scales to handle thousands of referrals automatically Version History v1.0 - Initial release with full automation and dual-path logic Tested and validated in production environment Includes comprehensive documentation and setup guides Support & Documentation Full implementation guide included with: Step-by-step setup instructions Credential configuration details Testing procedures Troubleshooting tips Customization examples Google Sheets template structure License MIT License - Free to use, modify, and distribute Perfect for businesses looking to automate their referral programs without sacrificing quality or control.

Personalized Promo Code Cards for Verified Users Overview This workflow automatically generates beautiful, personalized promotional cards with QR codes and sends them via email to verified users. Perfect for e-commerce stores, marketing campaigns, and customer engagement initiatives. Key Features Email Verification**: Validates email addresses using Verifi Email API to prevent fraud and ensure deliverability Dynamic Promo Cards**: Generates stunning, personalized promotional cards with custom discount codes and QR codes Automated Email Delivery**: Sends professionally designed HTML emails with embedded promo card images Real-time Logging**: Tracks all promo distributions in Google Sheets for monitoring and analytics Error Handling**: Includes error path for invalid emails with admin notifications Fully Customizable**: Easy to customize card design, email template, and discount values Workflow Process Webhook Trigger: Receives user data (name, email, promo_code, discount_value, discount_type) Data Processing: Formats and validates incoming data with default values Email Verification: Checks email validity using Verifi Email API Validation Gateway: Routes valid emails to generation or invalid to error path Card Generation: Creates personalized promo card image using HTML/CSS to Image API Email Delivery: Sends beautifully designed email with promo card via Gmail Logging: Records successful distributions in Google Sheets Error Notification: Sends admin alerts for failed attempts What's Included Beautiful Promo Card Design Gradient purple background (#667eea to #764ba2) Personalized greeting with customer name Prominent discount display in circular badge QR code for easy checkout redemption Validity date clearly shown Professional, mobile-responsive design Professional Email Template Engaging gradient header matching promo card Highlighted promo code section with dashed border Three feature icons (Easy to Use, Exclusive Deal, Limited Time) Call-to-action button Embedded promo card image Clean footer with expiry and contact info Required Integrations & APIs 1. Verifi Email API Purpose**: Email verification and validation Get API Key**: https://verifi.email Setup**: Sign up → Generate API key → Add to workflow credentials 2. HTML/CSS to Image API Purpose**: Convert HTML promo card to PNG image Get API Key**: https://htmlcsstoimg.com Setup**: Create account → Copy API key → Configure in workflow 3. Gmail API (OAuth2) Purpose**: Send personalized promo emails Get Credentials**: https://console.cloud.google.com/ Setup Steps**: Create new project Enable Gmail API Create OAuth 2.0 Client ID Add credentials to n8n 4. Google Sheets API Purpose**: Log promo distributions for tracking Get Credentials**: https://console.cloud.google.com/ Setup Steps**: Enable Google Sheets API Create Service Account (or use OAuth2) Share your Google Sheet with the service account email Add credentials to n8n Quick Start Guide Step 1: Import the Workflow Copy the workflow JSON Go to n8n dashboard Click "Import from File" or "Import from URL" Paste the workflow Step 2: Configure Credentials Set up the following credentials in n8n: Verifi Email API credentials HTML/CSS to Image API credentials Gmail OAuth2 credentials Google Sheets credentials Step 3: Create Google Sheet Create a new Google Sheet Add headers: Timestamp, Name, Email, Promo Code, Discount Value, Status Share with your service account (if using service account auth) Copy the Sheet ID and update in the workflow Step 4: Customize Settings QR Code URL**: Update the checkout URL in the promo card HTML (line with YOURSTORE.com) Admin Email**: Change admin notification email in the "Error Path" node Validity Date**: Update expiry date in both promo card and email template Colors/Design**: Customize gradient colors and styling as needed Step 5: Test the Workflow Activate the workflow Copy the webhook URL Send a POST request with test data: { "name": "John Doe", "email": "john@example.com", "promo_code": "SAVE20", "discount_value": "20%", "discount_type": "percentage" } Input Parameters Send a POST request to the webhook with the following JSON body: { "name": "Customer Name", // Optional: defaults to "Valued Customer" "email": "customer@example.com", // Required: customer email address "promo_code": "SUMMER25", // Optional: defaults to "WELCOME10" "discount_value": "25%", // Optional: defaults to "10%" "discount_type": "percentage" // Optional: defaults to "percentage" } Use Cases E-commerce Welcome offers for new customers Abandoned cart recovery with discount codes Birthday/anniversary promotions Loyalty rewards for repeat customers Marketing Campaigns Seasonal sale promotions Referral program rewards Social media contest prizes Email list incentives Customer Engagement Re-engagement campaigns VIP member benefits Event registration perks Survey completion rewards Customization Options Promo Card Design Modify colors and gradients in the HTML/CSS Change logo/emoji in the header Adjust card dimensions and layout Customize QR code size and styling Update validity date format Email Template Change email subject line Modify header text and styling Add company branding/logo Customize CTA button text and link Update footer information Business Logic Add conditional discounts based on user tier Implement time-based validity Add product-specific promo codes Include multiple discount tiers Add custom validation rules Monitoring & Analytics The workflow automatically logs: Timestamp of each promo distribution Customer name and email Promo code assigned Discount value Distribution status (Success/Failed) Use this data to: Track campaign performance Monitor redemption rates Identify popular discount amounts Analyze email delivery success Debug failed attempts Troubleshooting Common Issues Email not sending: Verify Gmail API credentials are correct Check OAuth2 token hasn't expired Ensure Gmail account has proper permissions Image not generating: Confirm HTML/CSS to Image API key is valid Check API usage limits haven't been exceeded Verify HTML syntax is correct Email validation failing: Ensure Verifi Email API credentials are active Check API rate limits Verify email format in incoming data Google Sheets not updating: Confirm Sheet ID is correct Check service account has edit permissions Verify sheet name matches configuration Pro Tips Test with Invalid Emails: Try sending to invalid emails to verify error handling works Monitor API Limits: Keep track of API usage to avoid hitting rate limits A/B Test Designs: Create multiple card variations to see which performs better Personalize Further: Add more custom fields like user tier, purchase history, etc. Schedule Reports: Create a companion workflow to send daily/weekly promo distribution reports Performance Metrics Processing Time**: 30-60 seconds per request Success Rate**: 95%+ for valid email addresses Scalability**: Handles hundreds of requests per hour Error Recovery**: Automatic admin notifications for failures Security & Privacy Email validation prevents spam and fraud No sensitive data stored in workflow All API credentials encrypted in n8n Google Sheets logging can be disabled if needed Compliant with email marketing best practices Best Practices Email Deliverability: Always validate emails before sending Rate Limiting: Implement delays for bulk sends to avoid spam filters Personalization: Use customer names and relevant discount amounts Clear CTAs: Make it easy for customers to redeem their codes Tracking: Monitor distribution and redemption metrics Testing: Always test with real emails before launching campaigns 📄 License This workflow template is provided as-is for use in your n8n instance. Feel free to customize and adapt to your specific needs. Why Use This Workflow? ✅ Saves Time: Automates entire promo distribution process ✅ Reduces Errors: Email validation prevents bounce rates ✅ Professional Output: Beautiful, branded promo cards ✅ Easy Tracking: Real-time logging in Google Sheets ✅ Scalable: Handles high volume campaigns ✅ Customizable: Easy to adapt to your brand ✅ Cost-Effective: Uses affordable or free tier APIs Perfect for marketers, e-commerce managers, and anyone looking to automate personalized promotional campaigns!

University Admission Confirmation & Welcome Kit A robust n8n workflow template that automates the university admission process for colleges, universities, and educational programs. This workflow validates student emails, generates professional PDF admission letters, sends personalized welcome emails, and handles errors efficiently — all in under 15 seconds per submission. Perfect for streamlining student onboarding with professional communication. Overview This workflow automates the process of handling new admission submissions by: Verifying student emails in real-time Generating university-branded admission confirmation PDFs Sending personalized welcome emails Logging invalid entries and preventing spam Key Features Email Verification & Fraud Prevention Real-time email validation using VerifiEmail API Checks RFC compliance, MX records, disposable emails, and spoofed addresses Rejects invalid emails before processing Prevents fake registrations and ensures deliverability Automated PDF Generation Creates branded, print-ready admission letters using PDFMunk Includes student details, program information, and verification badge Professional design with gradient headers and university branding Dynamic data integration for personalized documents Smart Email Notifications Student Welcome Email:** Personalized confirmation with PDF attachment Invalid Email Alerts:** Notifies admissions team of failed validations Responsive Design:** Mobile-friendly, clear next steps Intelligent Routing Conditional logic based on validation results Valid emails → generate PDF + send email Invalid emails → log and stop workflow Saves API usage and execution time Error Handling Comprehensive error detection for validation and API failures Detailed logging for invalid addresses Stops on failure to avoid unnecessary processing Sends admin alerts with actionable info Perfect For Universities & Colleges (Undergraduate & Postgraduate Admissions) Online Education Platforms (MOOCs, Certifications) Training & Vocational Programs Study Abroad Agencies Scholarship & Fellowship Applications Continuing Education Departments Workflow Statistics | Metric | Detail | |---------|--------| | Total Nodes | 15 | | Complexity | ⭐⭐ Medium | | Processing Time | 8–15 seconds per submission | | Setup Time | 10–15 minutes | | Code Required | ❌ No code (No-code solution) | | Maintenance | Minimal (Set & forget) | Requirements Required Services & APIs | Service | Purpose | Signup | |----------|----------|--------| | VerifiEmail API | Email validation | verifi.email | | PDFMunk API | PDF generation | pdfmunk.com | | Gmail | Email notifications | Google Cloud Console | Optional Integrations Google Forms or Typeform (data source) Google Sheets (admission tracking) Slack (team notifications) CRM (Salesforce, HubSpot, etc.) What Gets Created PDF Admission Letter Generated using PDFMunk API Includes: University-branded header & gradient design Email verification badge Student details (Name, Course, Application ID) Admission date & program info Professional footer & signature Email Notifications 1. Student Welcome Email Personalized greeting + attached PDF Next steps checklist (enrollment, orientation, etc.) Mobile-responsive design 2. Invalid Email Alert (Admin) Sent to admissions@youruniversity.edu Includes failure reasons, student name, and application ID Actionable follow-up steps Quick Start Guide 1️⃣ Import Template Copy workflow JSON In n8n → Workflows → Import from Clipboard Paste and import 2️⃣ Configure Credentials (10 minutes) A. VerifiEmail API Sign up → get API key → add under VerifiEmail account B. PDFMunk API Sign up → get API key → add under HtmlcsstopdfApi account C. Gmail OAuth2 Create project in Google Cloud Console Enable Gmail API → OAuth 2.0 credentials Add under Gmail account in n8n 3️⃣ Update Email Addresses Welcome Email Node:** admissions@youruniversity.edu Invalid Alert Node:** admissions team email Update branding details in email + PDF templates 4️⃣ Test the Workflow curl -X POST https://your-n8n.com/webhook/admission-form \ -H "Content-Type: application/json" \ -d '{ "name": "John Doe", "email": "john.doe@example.com", "course": "B.Tech Computer Science", "college_name": "TechNova University", "application_id": "TN-2025-0451", "admission_date": "2025-10-12" }' 5️⃣ Activate Workflow Toggle ON in n8n (top-right corner). 🧠 Detailed Setup Instructions Step 1: VerifiEmail Configuration Sign up → get API key Add in VerifiEmail Node credentials Test with sample email Step 2: PDFMunk Setup Sign up → get API key Add in HTML to PDF Node Test with sample execution Step 3: Gmail Configuration Enable Gmail API Add OAuth 2.0 credentials Authenticate with Gmail account Test sending an email Step 4: Webhook Setup Copy webhook URL from “Webhook - Admission Form” node Connect your form platform (Google Form, Typeform, etc.) Ensure JSON payload includes: name, email, course, college_name, application_id, admission_date Step 5: Test & Validate ✅ Valid email: Check PDF generation + welcome email ❌ Invalid email: Confirm admin alert sent ⚠️ Missing data: Review error logs 🔄 Workflow Diagram Start ↓ Webhook Trigger ↓ Email Verification (VerifiEmail API) ↓ Conditional Check (Valid?) ↙️ ↘️ TRUE FALSE ↓ ↓ Generate PDF Log Error ↓ ↓ Send Welcome Email End ↓ Done ✅ Processing Flow Details | Stage | Time | | ----------------------- | ----------- | | Webhook → Data capture | ~0s | | Email Verification | ~2–3s | | PDF Generation | ~4–6s | | Email Delivery | ~2–3s | | Total (Valid Email) | 8–15s ⚡ | | Invalid Email Path | 3–5s 🚀 | Customization Options Easy Customizations Email Templates:** Update HTML & university branding PDF Template:** Modify HTML (colors, fonts, fields) Error Messages:** Customize admin alerts Advanced Customizations Add Tracking:** Google Sheets or CRM Multi-Language Support:** Generate localized PDFs Extra Notifications:** Slack or SMS for staff CRM Integration:** Auto-push student data to Salesforce Troubleshooting | Issue | Cause | Solution | | -------------------- | ----------------------------- | ----------------------------- | | Email marked invalid | API key or quota issue | Check VerifiEmail dashboard | | PDF not generated | HTML error or expired API key | Validate HTML + check PDFMunk | | Email not sent | OAuth expired | Re-auth Gmail credential | | Webhook inactive | URL incorrect or workflow off | Activate + test via curl | Performance & Scalability | Metric | Current Capacity | | ---------------------- | --------------------------------- | | Concurrent Submissions | 10–20 | | Daily Volume | 500–1000 | | PDF Size | 100–500 KB | | Storage | Temporary (email attachment only) | Scaling Up Upgrade API tiers for high-volume admissions Add queue system or DB logging Validate large payloads & compress data Security & Privacy All API calls via HTTPS OAuth2 for Gmail authentication No student data stored post-execution Encrypted verification process Compliance GDPR compliant (minimal retention) Secure credential storage in n8n Full audit via execution logs License This template is provided as-is for commercial and personal use under the MIT License.

⚠️ Disclaimer: This workflow utilizes community nodes that needs self hosted version Code for UI Form is accessible here The bykhaisa workflow streamlines makeup service bookings by capturing customer details via webhook, calculating pricing including add-ons and payment types, generating payment invoices with Xendit, and sending personalized WhatsApp booking confirmations. This powerful combination of n8n, GoWhatsApp API, and Xendit reduces manual work and accelerates payment collection, saving you valuable time and boosting client satisfaction. 💡 Why Use bykhaisa? Save Time:** Automate booking and payment processes to eliminate hours spent on manual data entry Simplify Payments:** Generate invoices instantly with Xendit, making it easier for clients to pay securely and promptly Enhance Communication:** Send automated WhatsApp messages that keep customers informed and engaged without lifting a finger Stand Out:** Offer a modern, seamless booking experience that elevates your makeup business above competitors still stuck in the stone age ⚡ Perfect For Makeup Artists & Studios:** Who want a hassle-free booking and payment system Beauty Salons:** Seeking smooth client communication and invoicing automation Freelancers:** Looking to appear professional with automated workflows and instant payment requests General Business with booking system**: to make a seamless booking process 🔧 How It Works ⏱ Trigger: Customer sends booking details via Form (a POST request to the webhook) 📎 Process: Extract and format booking data, calculate prices with add-ons and urgent fees, and create a unique booking ID 🤖 Smart Logic: Calculate whether payment is a Down Payment (DP) or full amount, set invoice expiry, and generate Xendit invoices automatically 💌 Output: WhatsApp notification with booking details and payment link sent to customer, complete with friendly typing delays for that human touch 🗂 Storage: Booking data enriched with pricing and payment state, ready for follow-up or record-keeping 🔐 Quick Setup Import JSON file to your n8n instances Add credentials: Xendit API key, GoWhatsApp API credentials Customize: Adjust pricing logic, add-on fees, and payment types as needed Update: Replace webhook URLs and redirect URLs for payment success/failure pages Test: Run the workflow with sample booking data to verify end-to-end automation 🧩 Requirements Active n8n instances Xendit account & API credentials for invoice generation GoWhatsApp API setup for WhatsApp messaging Optional: Custom domain for webhook endpoint 🛠️ Level Up Ideas Add calendar integration to automatically block booked slots Integrate Google Sheets or Airtable for backup and reporting Set up payment reminders and follow-ups via WhatsApp automatically 🧠 Nodes Used Webhook** - Receives booking requests Set (Process Booking)** - Data transformation and formatting Code (Calculate Price)** - Custom pricing logic with add-ons HTTP Request (Generate Invoice)** - Xendit invoice creation Respond to Webhook** - Send response back to client GoWhatsApp** - WhatsApp messaging functionality 📋 Workflow Categories Category:** E-commerce, Bussiness Tags:** automation, booking, invoicing, payments, whatsapp, makeup Made by: khaisa Studio Need custom work? Contact Me