YouTube to WhatsApp sales automation with WordPress, FluentCRM and Whinta
π WhatsApp Automation Template
Designed & Developed by Infridet Solutions Private Limited
π§ Objective:
Automate your lead nurturing and sales process from YouTube/Instagram β Landing Page β CRM β Email β WhatsApp β Sales β Deal Closure using tools like:
- π WordPress (Landing Page + Fluent Forms)
- π§Ύ Google Sheets (Backup Log)
- π© FluentCRM (Lead Tagging + Email Sequences)
- π¬ Whinta.com (WhatsApp Messaging API)
- βοΈ N8N (Workflow Automation Engine)
π§© System Flow Overview:
- Lead Source: YouTube or Instagram CTA
- Landing Page: Built on WordPress with a story-driven design
- Form Capture: Fluent Forms with dynamic input fields
- Data Sync:
- Backup to Google Sheets
- Push lead to FluentCRM and tag as
New Lead
- Email Sequence:
- Warm-up emails (1 to 5)
- Introduce offer or service
- WhatsApp Outreach:
- Send personalized message via Whinta
- Triggered 1 hour after form fill or last email
- Sales Follow-Up:
- Sales team handles replies manually
- CRM tag updated to
Customerupon closing
π Folder Structure (Optional Git/Zip File):
π¦ WhatsApp-Automation-Infridet/
β
βββ whatsapp-automation-n8n.json # N8N Flowchart Import File
βββ email-templates.docx # Warm-up Email Scripts
βββ whinta-api-integration.pdf # API Documentation
βββ crm-tagging-notes.txt # CRM Tag Setup Details
βββ readme.md # This Instruction File
π οΈ Required Integrations & Setup
β Fluent Forms (WordPress)
- Embed form with Name, Email, Phone
- Enable webhook to N8N:
/lead-capture
β Google Sheets
- Use
n8n-nodes-base.googleSheetsnode - Capture name, email, phone, source, timestamp
β FluentCRM
- REST API enabled
- Push contact and assign tag
New Lead - Setup Email Automation via tag trigger
β SMTP Email (Optional)
- Use Gmail SMTP or Brevo
- Trigger email on form submission
β Whinta.com (WhatsApp API)
- Send POST request
- Payload includes
phone,message,sender_id - Customize message with personalization
π¬ Sample WhatsApp Message:
Hey {{name}}, Gyan here from Account Craft π
I saw your form submission β would you like help in starting your YouTube journey this week?
Let me know. I'm just one text away. β
π§ Sample Email (Warmup Day 1):
> Subject: Welcome to Account Craft π
> Body:
> Hi {{name}},
>
> Iβm Gyan from Account Craft. Thanks for joining us!
> Hereβs whatβs coming next: exclusive videos, personalized tips, and real support to get your YouTube channel earning.
>
> Letβs go!
> β Gyan
π CRM Tag Updates:
| Action | Tag Assigned |
|-------------------|------------------|
| On form fill | New Lead |
| After WhatsApp | Engaged |
| After sale closed | Customer |
π Final Output:
Once completed, the system will:
- Log all leads into a database
- Automatically send emails and WhatsApp messages
- Notify your sales team
- Update lead status without manual entry
> Automation Template Designed & Deployed by
> Infridet Solutions Private Limited
> Smart Integrations. Seamless Business.
> π www.infridetsolutions.com | π +91-8853354829
n8n Workflow: Basic Webhook Listener with Google Sheets and Email Integration
This n8n workflow demonstrates a fundamental setup for receiving data via a webhook, logging it to Google Sheets, and sending an email notification. It provides a foundational structure that can be extended for various automation tasks.
What it does
This workflow performs the following steps:
- Listens for incoming data: It starts by waiting for an HTTP POST request to a defined webhook URL.
- Logs data to Google Sheets: Upon receiving data, it appends a new row to a specified Google Sheet, storing the received information.
- Sends an Email Notification: After logging the data, it sends an email to a predefined recipient, potentially including details from the received webhook payload.
Prerequisites/Requirements
To use this workflow, you will need:
- n8n Instance: A running instance of n8n.
- Google Sheets Account: Access to a Google Sheets document where data will be logged.
- Email Sending Service: An SMTP server or an email service configured in n8n for sending emails.
- Webhook Source: An external application or service that can send HTTP POST requests to the n8n webhook URL.
Setup/Usage
- Import the Workflow:
- Copy the provided JSON code.
- In your n8n instance, click on "Workflows" in the left sidebar.
- Click "New" or "Import from JSON" and paste the workflow JSON.
- Configure the Webhook Trigger:
- Locate the "Webhook" node (Node ID: 47).
- Set the "HTTP Method" to
POST. - Note down the "Webhook URL" provided by n8n. This is where your external service will send data.
- Configure Google Sheets Node:
- Locate the "Google Sheets" node (Node ID: 18).
- Credentials: Create or select your Google Sheets OAuth2 credentials. Follow the n8n documentation for setting up Google Sheets credentials if you haven't already.
- Spreadsheet: Specify the "Spreadsheet ID" and "Sheet Name" where you want to log the data.
- Operation: Set the operation to "Append Row".
- Value: Map the data you want to save from the webhook payload to the columns in your Google Sheet. For example, you might use expressions like
{{ $json.body.your_field_name }}to extract data from the incoming webhook.
- Configure Send Email Node:
- Locate the "Send Email" node (Node ID: 11).
- Credentials: Create or select your SMTP or email service credentials.
- To: Enter the email address(es) where you want to receive notifications.
- Subject: Define a subject for the email (e.g., "New Webhook Data Received").
- Body: Compose the email body, optionally including data from the webhook payload or the Google Sheets operation. For example,
New data received: {{ $json.body.message }}.
- Activate the Workflow:
- Once all nodes are configured, save the workflow.
- Toggle the workflow to "Active" to start listening for incoming webhooks.
Now, whenever data is sent to the webhook URL, it will be processed by this workflow, logged to your Google Sheet, and an email notification will be sent.
Related Templates
AI-powered code review with linting, red-marked corrections in Google Sheets & Slack
Advanced Code Review Automation (AI + Lint + Slack) Whoβs it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting β all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0β10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your teamβs channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow β reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why itβs valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n β combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your teamβs review history transparent and centralized.
Daily cash flow reports with Google Sheets, Slack & Email for finance teams
Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. πΈπ§ Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows β Get in touch with us
Create personalized email outreach with AI, Telegram bot & website scraping
Demo Personalized Email This n8n workflow is built for AI and automation agencies to promote their workflows through an interactive demo that prospects can try themselves. The featured system is a deep personalized email demo. --- π How It Works Prospect Interaction A prospect starts the demo via Telegram. The Telegram bot (created with BotFather) connects directly to your n8n instance. Demo Guidance The RAG agent and instructor guide the user step-by-step through the demo. Instructions and responses are dynamically generated based on user input. Workflow Execution When the user triggers an action (e.g., testing the email demo), n8n runs the workflow. The workflow collects website data using Crawl4AI or standard HTTP requests. Email Demo The system personalizes and sends a demo email through SparkPost, showing the automationβs capability. Logging and Control Each user interaction is logged in your database using their name and id. The workflow checks limits to prevent misuse or spam. Error Handling If a low-CPU scraping method fails, the workflow automatically escalates to a higher-CPU method. βοΈ Requirements Before setting up, make sure you have the following: n8n β Automation platform to run the workflow Docker β Required to run Crawl4AI Crawl4AI β For intelligent website crawling Telegram Account β To create your Telegram bot via BotFather SparkPost Account β To send personalized demo emails A database (e.g., PostgreSQL, MySQL, or SQLite) β To store log data such as user name and ID π Features Telegram interface using the BotFather API Instructor and RAG agent to guide prospects through the demo Flow generation limits per user ID to prevent abuse Low-cost yet powerful web scraping, escalating from low- to high-CPU flows if earlier ones fail --- π‘ Development Ideas Replace the RAG logic with your own query-answering and guidance method Remove the flow limit if youβre confident the demo canβt be misused Swap the personalized email demo with any other workflow you want to showcase --- π§ Technical Notes Telegram bot created with BotFather Website crawl process: Extract sub-links via /sitemap.xml, sitemap_index.xml, or standard HTTP requests Fall back to Crawl4AI if normal requests fail Fetch sub-link content via HTTPS or Crawl4AI as backup SparkPost used for sending demo emails --- βοΈ Setup Instructions Create a Telegram Bot Use BotFather on Telegram to create your bot and get the API token. This token will be used to connect your n8n workflow to Telegram. Create a Log Data Table In your database, create a table to store user logs. The table must include at least the following columns: name β to store the userβs name or Telegram username. id β to store the userβs unique identifier. Install Crawl4AI with Docker Follow the installation guide from the official repository: π https://github.com/unclecode/crawl4ai Crawl4AI will handle website crawling and content extraction in your workflow. --- π¦ Notes This setup is optimized for low cost, easy scalability, and real-time interaction with prospects. You can customize each component β Telegram bot behavior, RAG logic, scraping strategy, and email workflow β to fit your agencyβs demo needs. π You can try the live demo here: @emaildemobot ---