Monitor SEO keyword rankings with SERP API & send drop alerts via Slack
This automated workflow monitors your website's keyword rankings daily and sends instant alerts to your team when significant ranking drops occur. It fetches current ranking positions, compares them with historical data, and triggers notifications through Slack and email when keywords drop beyond your defined threshold. Good to know The workflow uses SERP API for accurate ranking data; API costs apply based on your usage volume Ranking checks are performed daily to avoid overwhelming search engines with requests The system tracks ranking changes over time and maintains historical data for trend analysis Slack integration requires workspace permissions and proper bot configuration False positives may occur due to personalized search results or data center variations How it works Daily SEO Check Trigger initiates the workflow on a scheduled basis Get Keywords Database retrieves your keyword list and current ranking data Filter Active Keywords Only processes only keywords marked as active for monitoring Fetch Google Rankings via SERP API gets current ranking positions for each keyword Wait For Response Wait for gets current ranking positions Parse Rankings & Detect Changes compares new rankings with historical data and identifies significant drops Filter Significant Ranking Drops isolates keywords that dropped beyond your threshold (e.g., 5+ positions) Send Slack Ranking Alert notifies your team channel about ranking drops Send Email Ranking Alert sends detailed email reports to stakeholders Update Rankings in Google Sheet saves new ranking data for historical tracking Generate SEO Monitoring Summary creates a comprehensive report of all ranking changes How to use Import the workflow into n8n and configure your SERP API credentials Set up your Google Sheet with the required keyword database structure Configure Slack webhook URL and email SMTP settings Define your ranking drop threshold (recommended: 5+ position drops) Test the workflow with a small keyword set before full deployment Schedule the workflow to run daily during off-peak hours Requirements SERP API account with sufficient credits for daily keyword checks Google Sheets access for keyword database and ranking storage Slack workspace with webhook permissions for team notifications Email service (SMTP or API) for stakeholder alerts Keywords database properly formatted in Google Sheets Database/Sheet Columns Required Google Sheet: "Keywords Database" Create a Google Sheet with the following columns: | Column Name | Description | Example | |-------------|-------------|---------| | keyword | Target keyword to monitor | "best seo tools" | | domain | Your website domain | "yourwebsite.com" | | current_rank | Latest ranking position | 5 | | previous_rank | Previous day's ranking | 3 | | status | Monitoring status | "active" | | target_url | Expected ranking URL | "/best-seo-tools-guide" | | search_volume | Monthly search volume | 1200 | | difficulty | Keyword difficulty score | 65 | | date_added | When keyword was added | "2025-01-15" | | last_checked | Last monitoring date | "2025-07-30" | | drop_threshold | Custom drop alert threshold | 5 | | category | Keyword grouping | "Product Pages" | Customising this workflow Modify ranking thresholds in the "Filter Significant Ranking Drops" node to adjust sensitivity (e.g., 3+ positions vs 10+ positions) Add competitor monitoring by duplicating the SERP API node and tracking competitor rankings for the same keywords Customize alert messages in Slack and email nodes to include your brand voice and specific stakeholder information Extend to multiple search engines by adding Bing or Yahoo ranking checks alongside Google Implement ranking improvement alerts to celebrate when keywords move up significantly Add mobile vs desktop tracking by configuring separate SERP API calls for different device types
By Oneclick AI SquadAutomate Zoom 🎦 user onboarding with OAuth token management and data tables
This workflow automates the management of Zoom OAuth tokens and the creation of new Zoom users through the Zoom API. This workflow automates the process of creating a new Zoom user by first ensuring a valid OAuth access token is available. It is designed to handle the fact that Zoom access tokens are short-lived (1 hour) by using a longer-lived refresh token (90 days) stored in an n8n Data Table. It includes two main phases: Token Generation & Management The workflow initially requests a Zoom access token using the OAuth 2.0 “authorization code” method. The resulting access token (valid for 1 hour) and refresh token (valid for 90 days) are stored in an n8n Data Table. When executed again, the workflow checks for the most recent token, refreshes it using the refresh token, and updates the Data Table automatically. User Creation in Zoom Once a valid token is retrieved, the workflow collects the user’s first name, last name, and email (set in the “Data” node). It then generates a secure random password for the new user. Using the Zoom API, it sends a POST request to create the new user, automatically triggering an invitation email from Zoom. --- Key Features ✅ Full Automation of Zoom Authentication Eliminates manual token handling by automatically refreshing and updating OAuth credentials. ✅ Centralized Token Storage Securely stores access and refresh tokens in an n8n Data Table, simplifying reuse across workflows. ✅ Error Prevention Ensures that expired tokens are replaced before API requests, avoiding failed Zoom operations. 4.✅ Automatic User Provisioning Creates Zoom users automatically with prefilled credentials and triggers Zoom’s built-in invitation process. ✅ Scalability Can be easily extended to handle bulk user creation, role assignments, or integration with other systems (e.g., HR, CRM). ✅ Transparency & Modularity Each node is clearly labeled with “Sticky Notes” explaining every step, making maintenance and handover simple. --- How it works Trigger and Data Retrieval: The workflow starts manually. It first retrieves user data (first name, last name, email) from the "Data" node. In parallel, it fetches all stored token records from a Data Table. Token Management: The retrieved tokens are sorted and limited to get only the most recent one. This latest token (which contains the refreshtoken) is then used in an HTTP Request to Zoom's OAuth endpoint to generate a fresh, valid accesstoken. User Creation: The new accesstoken and refreshtoken are saved back to the Data Table for future use. The workflow then generates a random password for the new user, merges this password with the initial user data, and finally sends a POST request to the Zoom API to create the new user. If the creation is successful, Zoom automatically sends an invitation email to the new user. --- Set up steps Prepare the Data Table: Create a new Data Table in your n8n project. Add two columns to it: accessToken and refreshToken. Configure Zoom OAuth App: Create a standard OAuth app in the Zoom Marketplace (not a Server-to-Server app). Note your Zoom account_id. Encode your Zoom app's clientid and clientsecret in Base64 format (as clientid:clientsecret). In both the "Get new token" and "Zoom First Access Token" nodes, replace the "XXX" in the Authorization header with this Base64-encoded string. Generate Initial Tokens (First Run Only): Manually execute the "Zoom First Access Token" node once. This node uses an authorization code to fetch the first-ever access and refresh tokens and saves them to your Data Table. The main workflow will use these stored tokens from this point forward. Configure User Data: In the "Data" node, set the default values for the new Zoom user by replacing the "XXX" placeholders for firstname, lastname, and email. After these setup steps, the main workflow (triggered via "When clicking 'Execute workflow'") can be run whenever you need to create a new Zoom user. It will automatically refresh the token and use the provided user data to create the account. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
By DavideCategorize support emails with AI and create tasks in Dart
Automatically turn incoming support emails into categorized, prioritized tasks in Dart—complete with AI-generated summaries, tags, and sender context. What It Does This workflow captures emails from Gmail, uses an AI model to classify them into one of seven categories (e.g., Bug Report, Billing, Feature Request), and creates a structured task in Dart. Each task includes: Title: The email subject Tag: Based on the detected category Priority: Set by the AI based on content analysis Description: Includes confidence level, rationale, summary, and the cleaned full email body Comment: Automatically adds the sender’s name and email for easy reference The workflow also parses and cleans the raw HTML email content, ensuring all data is readable and workflow-ready. Who's It For This template is built for support and operations teams using Dart who want to streamline how incoming emails are sorted and turned into actionable tasks. It’s ideal for organizations managing multiple types of requests and updates from clients, partners, or systems. How to Set Up Import the workflow into n8n Connect your Gmail and Dart accounts Replace the dummy Dartboard ID with your actual board ID Choose your preferred AI model (results may vary depending on model quality) If your target email address is in a google group, use the Filter: "Sender" in the Gmail trigger Requirements n8n account Connected Gmail and Dart account How to Customize the Workflow Modify the category list to match your team’s taxonomy Adjust the AI classification prompt to fine-tune tagging and prioritization Choose your preferred AI model
By Dart