Workflow Templates

Community Node Disclaimer This workflow uses KlickTipp community nodes, available for self-hosted n8n instances only. Who’s it for Marketing teams and course/community operators using WordPress and KlickTipp who want to automate the full bridge between lead capture and member engagement: Instant member access:** Automatically create WordPress subscriber accounts after a KlickTipp form signup. Consent-safe provisioning:** Only create accounts if the user explicitly consented. Engagement tracking:** Pull approved WordPress comments and write them into the KlickTipp contact profile. Interest segmentation:** Automatically tag contacts based on which landing page/content they commented on. This workflow removes manual user creation, keeps your marketing database enriched with behavioral data, and enables highly targeted follow-up campaigns. How it works This workflow connects KlickTipp ↔ WordPress in two directions: (1) Signup → Account creation, and (2) Comments → Profile enrichment + tagging. KlickTipp → WordPress (User creation on signup) Triggered by the Form signup for Wordpress in KlickTipp form webhook (RAW form submission): Consent Filter: The Filter node only allows signups where field229493 equals "I give consent". Identity Generation: Set username & password generates: A unique, URL-safe username based on first + last name (normalized, special characters removed) plus the KlickTipp subscriber ID. A 12-digit random numeric password stored as temporary_password. Account Provisioning: Generate Wordpress user from signup creates the user via WordPress (role: subscriber) using the generated username, password, and contact profile data. Role Enforcement: Generate Wordpress user from signup1 sets/ensures the WordPress role via REST API. Feedback to KlickTipp: Update Wordpress user ID in KlickTipp writes the WordPress account data back into KlickTipp custom fields: field229462 → WordPress User ID field228982 → WordPress Username field228983 → Temporary Password This enables automated onboarding emails that include login credentials (if you choose to send them). WordPress → KlickTipp (Comment sync + profile enrichment) Triggered daily by Pull comments trigger (scheduled at 08:00): Fetch Activity: Get last comments from Wordpress retrieves approved comments from the last 24 hours (via the after = now - 24h query parameter). Find the commenter in WordPress: Search WP Users with role Subscriber looks up the comment author by email and restricts results to WordPress users with role subscriber. Verify KlickTipp contact: Check for contact existence tries to find the KlickTipp subscriber by email. If found → continue. If not found → No Operation, do nothing prevents orphaned data writes. Write comment to KlickTipp: Write comment into contact field strips HTML from the comment content and stores the plain text in: field229468 → last comment text Segmentation & Tagging (based on comment source URL) After the comment is stored, Check relevant segment evaluates the link (where the comment was posted) and applies tags accordingly: Landingpage A comment* → *Tag contact** applies tag ID 14162905 Landingpage B comment* → *Tag contact1** applies tag ID 14176702 This gives you interest-based tagging driven by real engagement, not just form submissions. Setup steps Install Community Nodes: Ensure the KlickTipp community node is installed on your self-hosted n8n instance. KlickTipp form + consent field: Use a RAW form and connect it to the webhook trigger. Ensure you collect explicit consent and map it to field229493 with the value "I give consent". Create KlickTipp custom fields: WordPress User ID → field229462 WordPress Username → field228982 WordPress Password → field228983 Last Comment Text → field229468 WordPress API access: Create an Application Password for a WordPress admin user. Configure your WordPress credentials in n8n. Update URLs and segmentation rules: Confirm your WordPress base URL matches your site (https://cht.klicktipptest.de/...). Update the Check relevant segment switch rules to match your real landing page URLs. Test & activate: Run one test signup to confirm user creation + field writeback. Add a test comment and verify the comment text field + tag assignment. Requirements Self-hosted n8n instance (for KlickTipp community nodes). KlickTipp** account with API access. WordPress** site with REST API enabled. WordPress user with permissions + Application Password (to create users and read comments). How to customize Role control:** Change the assigned role from subscriber to other roles where appropriate. Comment sync window:* Adjust the after parameter in *Get last comments from Wordpress** (e.g., last 6 hours, last 7 days). Richer segmentation:* Add more cases in *Check relevant segment** for additional pages/topics and map them to different KlickTipp tag IDs. Data enrichment:** Store additional comment metadata (post title, URL, date) into extra KlickTipp fields if you want deeper profiling.

How it works • Reads all rows from a Google Sheet • Splits them into configurable batches (default: 5 rows per batch) • Calls any external REST API once per row (GET or POST, Header Auth) • Waits 1 second between batches to stay within API rate limits • Routes responses: writes enriched data back to the sheet on success, logs errors on failure • Loops through all batches until the full sheet is processed Set up steps • Takes ~10 minutes to configure • Connect your Google Sheets OAuth2 credential to both Sheet nodes • Set your Sheet ID and tab name in the Read Rows node • Paste your API endpoint URL in the Call API node and connect your Header Auth credential • Adjust batch size and wait duration via the sticky notes inside the workflow • Update the Update Row node with the column(s) you want to write back

Transform your expense tracking with automated AI receipt processing that extracts data and organizes it instantly. What this workflow does Monitors Google Drive for new receipt uploads (images/PDFs) Downloads and processes files automatically Extracts key data using verified VLM Run node (merchant, amount, currency, date) Saves structured data to Airtable for easy tracking Setup Prerequisites: Google Drive account, Airtable account, VLM Run API credentials, n8n instance. Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows. Quick Setup: Configure Google Drive OAuth2, Airtable OAuth2 Create receipt upload folder Add VLM Run API credentials Create Airtable table with columns: Customer, Merchant, Amount, Currency, Date Update folder/table IDs in workflow nodes Test and activate How to customize this workflow to your needs Extend functionality by: Adding expense categories and approval workflows Connecting to accounting software (QuickBooks, Xero) Including Slack notifications for processed receipts Adding data validation and duplicate detection This workflow transforms manual receipt processing into an automated system that saves hours while improving accuracy. > ⚠️ Disclaimer: This workflow requires a self-hosted n8n setup because it uses custom nodes (VLM Run) that are not available on the managed n8n.cloud service.

Simplify expense tracking with AI-powered automation that extracts receipt data and organizes it instantly. What this workflow does Watches Google Drive for new receipt uploads (images/PDFs) Automatically downloads and prepares files for processing Parses key details using the trusted VLM Run node (merchant, customer, amount, currency, date) Stores structured records in Airtable for real-time tracking Setup Prerequisites: Google Drive & Airtable accounts, VLM Run API credentials, n8n instance. Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows. Quick Setup: Configure Google Drive OAuth2 and create a receipt upload folder Add VLM Run API credentials Create an Airtable base with fields: Customer, Merchant, Amount, Currency, Date Update folder/base IDs in workflow nodes Test and activate How to customize this workflow to your needs Extend functionality by: Adding categories, budgets, or approval steps Syncing with accounting tools (QuickBooks, Xero) Sending Slack or email alerts for processed receipts Enabling error handling and duplicate checks This workflow eliminates manual data entry and creates a seamless, automated system that saves time and improves accuracy.

(Retail Automation) Auto-Segment Customers by Purchase Behavior This workflow automatically segments customers based on their purchase behavior whenever a new order or customer update event is received from platforms like WooCommerce, Shopify, or a CRM. It classifies customers into meaningful segments such as new customers, repeat customers, VIP customers, or inactive customers, syncs these segment tags to a CRM or email platform and logs each segmentation event in Google Sheets for tracking and auditing. Quick Implementation Steps Import the workflow JSON into n8n. Configure the Webhook URL in your eCommerce platform or CRM. Review and adjust segmentation rules if needed. Configure the CRM API endpoint and Google Sheets credentials. Activate the workflow and test with sample events. What It Does This workflow listens for customer-related events such as order creation or customer updates via a webhook. Incoming payloads are normalized to extract essential customer and behavioral data, including order count, lifetime spend, last order date, product categories and source system. Using rule-based logic, the workflow evaluates customer behavior and assigns an appropriate segment tag. Customers are classified into segments such as new customers, repeat customers, VIP customers, or inactive customers based on purchase frequency, total spend and recency of activity. Once a segment is determined, the workflow syncs the assigned segment tag to a CRM or email marketing platform and logs the segmentation event in Google Sheets. This ensures clean customer segmentation, consistent tagging and visibility for reporting and audits. Who’s It For This workflow is ideal for: E-commerce businesses using WooCommerce or Shopify Marketing teams running targeted email campaigns CRM administrators managing customer segmentation Growth and retention teams analyzing customer behavior Operations teams maintaining clean customer data Prerequisites To use this workflow, you need: An active n8n instance (self-hosted or cloud) A source system that can send webhook events (WooCommerce, Shopify, or CRM) Customer and order data including order count, lifetime spend and last order date Access to a CRM or email platform API Google Sheets API access and a prepared spreadsheet How to Use & Setup Import the workflow JSON into your n8n instance. Configure Receive Customer Order or Update Event with your webhook path. Ensure your source system sends required fields such as customer stats and order details. Review Normalize Customer Purchase Data to verify field mappings. Adjust segmentation thresholds in Determine Customer Segment if needed. Configure Sync Customer Segment to CRM with your actual CRM API endpoint and authentication. Connect Google Sheets and ensure required columns exist. Activate the workflow and test with sample payloads. How To Customize Nodes Normalize Customer Purchase Data** Add or remove customer or order attributes. Determine Customer Segment** Modify rules for VIP, new, repeat, or inactive customers. Adjust thresholds like lifetime spend or inactivity duration. Assign Segment Nodes** Change segment tag naming conventions. CRM Sync Node** Map segment tags to different CRM fields or formats. Google Sheets Logging** Add more columns such as order value or product categories. Add-ons (Optional Enhancements) This workflow can be extended to: Add category-based customer segments Trigger automated email campaigns based on segment Prevent duplicate CRM updates Add churn prediction or loyalty scoring Send Slack alerts for VIP or inactive customers Generate weekly or monthly segmentation reports Use Case Examples Automatically tagging first-time buyers for onboarding campaigns. Identifying VIP customers based on lifetime spend. Segmenting repeat buyers for loyalty offers. Detecting inactive customers for reactivation campaigns. Keeping CRM customer segments always up to date. There can be many more use cases depending on business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | No segment assigned | Missing customer stats | Verify webhook payload fields | | Wrong segment applied | Rule thresholds incorrect | Review Switch node conditions | | CRM not updated | API endpoint or auth issue | Recheck CRM credentials | | Google Sheet not updating | Sheet permissions missing | Verify Google Sheets access | | Workflow not executing | Workflow inactive | Activate the workflow | Need Help? If you need help setting up, customizing or extending this workflow—or want to build similar customer automation workflows, our n8n workflow development team at WeblineIndia can help design scalable, production-ready n8n automations tailored to your business needs.

Transform your Telegram chats into a creative powerhouse with this AI-driven image editing bot. Send an image document with a descriptive caption, and watch it get intelligently edited in seconds—no design skills required! 📋 What This Template Does This workflow powers a Telegram bot that automatically processes incoming image documents with text prompts. It downloads the file, uses Google Gemini AI to edit the image based on your caption, and instantly replies with the enhanced version. Triggers on new messages containing documents and captions Securely downloads and validates files before AI processing Leverages Gemini for precise, prompt-based image edits Sends the polished result back to the chat seamlessly 🔧 Prerequisites A Telegram bot created via @BotFather Google AI Studio account for Gemini API access n8n instance with Telegram and Google Gemini nodes enabled 🔑 Required Credentials Telegram API Setup Open Telegram and message @BotFather Use /newbot to create your bot and note the token In n8n, go to Credentials → Add Credential → Search "Telegram API" Paste the token and save as "Telegram Bot" Google Gemini API Setup Visit aistudio.google.com and sign in with Google Click "Get API key" → Create API key in a new project In n8n, go to Credentials → Add Credential → Search "Google Gemini API" Enter the API key and save as "Gemini API" ⚙️ Configuration Steps Import the provided JSON into your n8n workflows Assign the Telegram Bot credential to the trigger and Telegram nodes Assign the Gemini API credential to the Edit Image node Activate the workflow and note your bot's username Test by sending an image document with a caption like "add a sunset background" to your bot 🎯 Use Cases Personal creativity boost**: Send a selfie with "make me a superhero" for fun edits during downtime Social media content**: Upload product photos with "enhance lighting and add text overlay" for quick marketing visuals Educational sketches**: Share drawings with "colorize and detail" to turn student ideas into professional illustrations Team collaboration**: In group chats, prompt "remove background" for instant design feedback loops ⚠️ Troubleshooting Bot not responding**: Verify token in credentials and ensure "message" updates are enabled in the trigger File download fails**: Check if the sent file is a document/image; Telegram expires links after 1 hour—resend if needed AI edit errors**: Confirm Gemini API key quotas; shorten prompts if over 100 words for better results No edited image sent**: Inspect execution log for binary data flow; ensure "binaryData" is toggled on in send node

How it works This workflow automatically monitors your Google Business Profile for new reviews and uses AI to generate personalized response suggestions. When a review is detected, the system formats the review data, generates an appropriate AI response based on the rating and content, sends differentiated Slack notifications (urgent alerts for negative reviews, celebration messages for positive ones), and logs everything to Google Sheets for tracking and analysis. Who is this for Local business owners, restaurant managers, retail store operators, service providers, and reputation management teams who want to stay on top of customer feedback and respond promptly with thoughtful, AI-generated responses. Perfect for businesses that receive regular reviews and want to maintain consistent, professional customer engagement without manually monitoring multiple platforms. Requirements Google Business Profile**: Active business profile with review monitoring enabled Google API Credentials**: Service account with access to Business Profile API and Sheets API Slack Webhook**: Incoming webhook URL for team notifications Google Sheets**: Spreadsheet with "Reviews" sheet for logging review data Environment Variables**: Setup for secure credential storage Basic n8n Knowledge**: Understanding of triggers, expressions, and credential management How to set up Configure Google Business Profile API - Create Google Cloud project, enable Business Profile API, set up service account credentials, and add your Business Account ID and Location ID to environment variables Prepare Google Sheets Integration - Create Google Sheet with "Reviews" sheet, add required headers, set GOOGLE_SHEET_ID environment variable, and ensure service account has edit access Setup Slack Notifications - Create Slack webhook in your workspace and set SLACK_WEBHOOK_URL environment variable Customize Business Settings - Update Business Configuration node with your business name and adjust AI response tone preferences How to customize the workflow Modify the Business Configuration node to change your business name, adjust the AI response tone (professional, friendly, casual), customize Slack notification messages in the HTTP Request nodes, or add additional review sources by duplicating the trigger structure.

This workflow automates AI-powered image and video generation using MagicHour.ai's API, enhanced by GPT-4.1 for intelligent prompt optimization. It processes webhook requests, refines prompts using AI, generates media content, and returns the final output. Who's it for Content creators, marketers, social media managers, and developers who need automated AI media generation at scale. Perfect for teams building applications that require on-demand image or video creation without manual intervention. How it works The workflow receives a webhook POST request containing generation parameters (type, orientation, style, duration). GPT-4.1 analyzes and optimizes the user's prompt based on the request type (image or video), then sends it to MagicHour.ai's API. The workflow monitors the generation status through polling loops, downloads the completed media, and returns it via webhook response. Error handling ensures failed requests are captured and reported. Requirements n8n instance** (self-hosted or cloud) MagicHour.ai account** with API access (Bearer token) OpenAI API account** for GPT-4.1 access Basic understanding of webhooks and JSON How to set up Configure credentials: Add MagicHour.ai Bearer token in HTTP Request nodes (ai-image-generator, text-to-video, Get Image Details, Get Video Details) Add OpenAI API credentials in both Generate Image Prompt and Generate video Prompt nodes Activate the workflow: Enable the workflow to activate the webhook endpoint Copy the webhook URL from the Webhook trigger node Test the workflow: Download the n8n-magichour HTML tester Click here to download For image generation, send a POST request with this structure: { "action": "generate", "type": "image", "parameters": { "name": "My Image", "image_count": 1, "orientation": "landscape", "style": { "prompt": "A serene mountain landscape at sunset", "tool": "realistic" } } } For video generation, use: { "action": "generate", "type": "video", "parameters": { "name": "My Video", "end_seconds": 5, "orientation": "landscape", "resolution": "1080p", "style": { "prompt": "A dog running through a field" } } } How to customize the workflow Adjust AI prompt optimization: Modify the system prompts in Generate Image Prompt or Generate video Prompt nodes to change how GPT-4.1 refines user inputs. Current prompts enforce strict character limits and avoid unauthorized content. Change polling intervals: Modify the Wait nodes to adjust how frequently the workflow checks generation status (useful for longer video renders). Modify response format: Update the Respond to Webhook node to customize the output structure sent back to the caller. Add multiple output formats: Extend Download Image/Video nodes to save files to cloud storage (Google Drive, S3) instead of just returning via webhook. Implement queue management: Add a database node before MagicHour.ai calls to queue requests and prevent API rate limiting.

Automated QR Ticket Scanner & Validator This workflow is the perfect companion to the "Automated e-Ticket PDF Generator". It acts as a lightweight, automated check-in system for events. By pairing a simple Google Form with a mobile scanning app, it validates QR codes against your master database in real-time and logs the attendance status. How it works Trigger: The workflow triggers instantly when a new response is submitted to a Google Form (which acts as your QR code scanner input). Data Extraction: It isolates the scanned QR code string from the new Google Sheet row. Database Lookup: It cross-references the scanned code with your Master Participant Database in Google Sheets. Validation (Switch): A logic node checks if the scanned ticket exists and matches the database. Log Results: - VALID: If matched, it logs the participant's details into a "Scan Results" sheet with a "VALID" status. INVALID: If not matched, it logs the scanned code with an "INVALID" status, alerting you to an unregistered ticket. Field Setup (Pro-Tip) To make this work seamlessly at an actual event venue: Create a Google Form: Make a simple form with one short-answer text input for the QR code. Use "Scan to Web" App: Install the Scan to Web app (or a similar keyboard scanner app) on an Android smartphone. Scan Away: Open your Google Form link on the phone, tap the text input field, and use the app to scan the attendee's physical or digital QR code. The app will automatically type the code and submit the form, triggering this n8n workflow instantly! Requirements A Google Workspace account (Google Forms & Google Sheets). A basic understanding of mapping Google Sheets columns in n8n. An Android smartphone with the "Scan to Web" app installed for field scanning.

Generate Secure User Authentication with One Webhook Streamline user onboarding and security for your applications using this n8n workflow. This template handles signup, login, and password resets through a single endpoint, making it ideal for developers building MVPs or scaling apps without a full authentication backend. Who Is This For? This workflow is designed for: Developers, indie hackers, and teams building web, mobile, or API-driven applications. Those who need a quick and secure authentication layer. Anyone tired of writing custom auth code or managing third-party services like Auth0 for simple needs. This template integrates seamlessly into your n8n setup. What Problem Does This Workflow Solve? Building authentication from scratch is time-consuming and complex: User Management: Managing registration, credential verification, and password recovery can take weeks of development time. Security: Ensuring secure password hashing, case-insensitive email matching, and robust error handling adds significant complexity. Integration: Creating consistent APIs for apps (e.g., React Native, Next.js, Flutter) is challenging. This workflow provides a battle-tested, webhook-based authentication system that is: Database-agnostic (works with PostgreSQL/Supabase). Extensible—deploy once and integrate across all your apps. What This Workflow Does The workflow handles authentication tasks through a single webhook endpoint, offering the following functionality: Webhook Entry: Listens for POST requests at /webhook/auth. Processes a simple JSON payload, routing actions via a "path" parameter (signup, signin, forgot). Signup: Inserts new users into your database. Uses bcrypt-hashed passwords (via pgcrypto). Returns user details in the response. Login: Queries for case-insensitive email matches. Verifies passwords securely. Returns user information on successful login. Forgot Password: Generates a random 8-character password. Updates the password hash in the database. Returns the new password (suitable for email delivery). Routing & Validation: Uses n8n Switch and IF nodes to securely handle paths and credentials. Standardized Responses: Outputs clean JSON with status, message, and data for easy frontend parsing. Error Handling: Gracefully manages invalid inputs, duplicate entries, or database errors. No more boilerplate—get authentication up and running in minutes! Setup Instructions Follow these steps to set up the workflow: Connect Your Accounts: Use PostgreSQL or Supabase for user storage (free tiers are sufficient). Enable the following PostgreSQL extensions: uuid-ossp and pgcrypto. Create the Users Table: sqlCREATE TABLE users ( id uuid PRIMARY KEY DEFAULT uuid_generate_v4(), full_name text NOT NULL, email text UNIQUE NOT NULL, password_hash text NOT NULL, created_at timestamptz DEFAULT now() ); Configure Credentials : Add PostgreSQL credentials to the n8n nodes ("Signup", "Login", "Reset Password"). Import the JSON workflow into n8n. Activate the workflow. Test the Workflow: Use Postman or curl to send requests to the auto-generated webhook URL. How to Customize This Workflow Extend the workflow to fit your specific needs with these modifications: Add JWT Sessions: Insert a node after successful login to generate and sign JWT tokens (e.g., using the Crypto node). Email Integration: Add a SendGrid or Mailgun node to the "Forgot Password" flow to automatically send new credentials. Rate Limiting: Include an HTTP Request node to check usage quotas before processing requests. Multi-Database Support: Replace PostgreSQL with MySQL or MongoDB by updating the query nodes. Frontend Enhancements: Extend JSON responses to include user avatars or roles by joining additional tables in SQL queries. Triggers: Add a Schedule node for batch user imports. Include a webhook for external authentication calls.

Enhance event logistics with this automated n8n workflow. Triggered by seating requests, it fetches attendee data and venue templates from Google Sheets, calculates totals, and optimizes seating layouts. The workflow generates detailed recommendations, splits individual assignments, and sends alerts, ensuring efficient venue planning and real-time updates. 🎪📋 Key Features Optimizes seating arrangements based on attendee data and event type. Generates venue layouts with visual and statistical insights. Provides real-time alerts with comprehensive seating plans. Logs detailed assignments and layouts in Google Sheets. Workflow Process The Webhook Trigger node initiates the workflow upon receiving venue requirements and attendee data via webhook. Validate Request Data** ensures the incoming data is complete and accurate. Fetch Attendee Data** retrieves attendee information, including groups, accessibility needs, and VIP preferences from Google Sheets. Fetch Venue Templates** reads venue layout templates from Google Sheets. Calculate Totals** aggregates attendee data and venue constraints for optimal planning. Combine All Data** merges attendee and venue data for analysis. AI Optimization** uses algorithms to calculate optimal seating based on venue dimensions, attendee groups, accessibility needs, VIP placement, and aisle placement. Optimize Seating Layout** refines the seating plan for efficiency. Format Recommendations** structures the seating plan with visual layout map, seat assignments, statistics & metrics, and optimization tips. Split Seat Assignments** divides the plan into individual seat assignments. Send Response** returns the complete seating plan with visual layout map, seat assignment list, statistics & recommendations, and export-ready format. Send Alert** notifies organizers with the finalized plan details. Update Sheets** saves the master plan summary, individual seat assignments, and layout specifications to Google Sheets. Save Individual Assignments** appends or updates individual seat assignments to Google Sheets. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set up the Webhook Trigger with your event management system's API credentials. Configure the AI Optimization node with a suitable algorithm or model. Test the workflow by sending sample seating requests and verifying layouts. Adjust optimization parameters as needed for specific venue or event requirements. Prerequisites Google Sheets OAuth2 credentials Webhook integration with the event management system Structured attendee and venue data in a Google Sheet Google Sheet Structure: Attendee Data Sheet with columns: Name Group Accessibility Needs VIP Status Preferences Updated At Venue Templates Sheet with columns: Venue Name Capacity Dimensions Layout Template Updated At Modification Options Customize the Validate Request Data node to include additional validation rules. Adjust the AI Optimization node to prioritize specific criteria (e.g., proximity, accessibility). Modify the Format Recommendations node to include custom visual formats. Integrate with venue management tools for live layout updates. Set custom alert triggers in the Send Alert node. Discover more workflows – Get in touch with us

Who is this for Content creators looking for topic ideas SEO specialists doing keyword research Marketing teams planning content calendars What this workflow does Discover keyword opportunities from 4 different sources (longtail, questions, similar, related) and export analyzed results to Google Sheets. What you'll get Longtail, question, similar, and related keyword variations Opportunity scores based on volume, difficulty, and CPC Search intent classification (informational, commercial, transactional, navigational) Content type suggestions (how-to guide, listicle, comparison, etc.) Trend analysis with historical search volume data Estimated monthly traffic potential Priority ranking (HIGH/MEDIUM/LOW) SERP features analysis All results automatically exported to Google Sheets How it works Fetches 4 types of keywords from SE Ranking (longtail, questions, similar, related) Merges and deduplicates all results Analyzes each keyword with custom scoring algorithm Calculates opportunity scores (volume 40%, difficulty 40%, CPC 20%) Detects search intent and suggests content types Exports enriched data to Google Sheets with 17 columns Requirements SE Ranking account with API access (Get one here) SE Ranking community node installed (Install from npm) Google Sheets account Setup steps Install the SE Ranking community node Add your SE Ranking API credentials Connect your Google Sheets account Update the seed keyword in all 4 SE Ranking nodes (default: "digital marketing") Select or create a Google Sheet for export Customization Adjust volumeFrom and difficultyTo filters in SE Ranking nodes for different opportunity ranges Change limit parameter to fetch more/fewer keywords per source (max 1000) Modify opportunity score formula in the Code node (currently: volume 40%, difficulty 40%, CPC 20%) Update content type detection patterns to match your industry Change source parameter for different countries (us, uk, de, fr, etc.)