HTTP Request and Mailjet integration

Who is this template for? This SEO Keyword Monitoring workflow template is perfect for SEO professionals, digital marketing agencies, website owners, and content strategists who need to track their search rankings and get actionable insights when they're not performing well. Whether you're managing multiple client sites, monitoring your own brand's visibility, or conducting competitive analysis, this automation provides comprehensive rank tracking with AI-powered recommendations. What problem does this workflow solve? Manual keyword rank tracking is time-consuming and often provides limited actionable insights. SEO professionals typically struggle with: Manually checking search rankings across different countries and languages Identifying why a website isn't ranking for target keywords Getting specific, actionable recommendations for SEO improvements Tracking competitor performance and market positioning Scaling rank monitoring across multiple keywords and domains Generating professional reports for clients or stakeholders What this workflow does This n8n workflow automates comprehensive SEO keyword monitoring with intelligent analysis and reporting. It tracks your rankings in Google search results and provides AI-powered insights when your site isn't performing as expected. Here's what it includes: Multi-language web form** that accepts keyword, domain, country (24 options), and language (12 options) Intelligent localization** that converts country/language selections into proper API codes Real-time Google SERP scraping** using Apify's Google Search API (up to 100 results per query) Automated rank detection** that checks if your domain appears in the search results Dual email reporting system:** Success reports: Beautiful HTML tables showing your rankings, competitor positions, titles, URLs, and descriptions AI-powered improvement reports: When your site doesn't rank, an AI agent (LLaMA 70B) analyzes the search results and provides specific, actionable SEO recommendations Professional email formatting** with HTML markup for easy sharing with clients or teams Setup Getting started is straightforward: Connect your Apify account Sign up for a free Apify account 🡥 Get your Personal API Token from Settings → API & Integrations Replace YOUR_API_TOKEN in the HTTP Request node with your actual token Configure the AI model The workflow uses Groq AI with LLaMA 70B by default Connect your Groq account or replace with OpenAI, Claude, or another LLM The AI agent analyzes search results and provides tailored SEO recommendations Set up email delivery / data export Configure the Mailjet nodes with your email credentials Or replace with Gmail, Outlook, SMTP, or other email providers Or replace with/add Google Sheets, Airtable, Notion or similar service, for data storage Set your sender and recipient email addresses Test the workflow Click "Test workflow" to access the web form Enter a keyword, domain, country, and language Check your email for either ranking results or AI-powered recommendations Activate the workflow Turn on the trigger so you can access the form anytime Share the form URL with team members or clients How to customize this workflow This template is highly flexible and can be adapted for various SEO monitoring needs: Scale up monitoring:** Add loops to track multiple keywords simultaneously Alternative outputs:* Replace email nodes with Google Sheets, *Airtable, or Notion for data storage Team notifications:* Connect to Slack, *Discord, or Microsoft Teams for instant alerts Scheduled monitoring:* Add cron triggers* for daily, weekly, or monthly automated checks Enhanced analysis:** Integrate additional AI models for deeper competitive analysis Custom reporting:** Modify the HTML templates to match your brand or client requirements Data persistence:* Add database connections* to store historical ranking data Competitor tracking:** Expand the logic to monitor multiple domains for the same keywords Key features 24 country support:** Track rankings in major markets worldwide 12 language options:** Monitor multilingual SEO performance AI-powered insights:** Get specific recommendations when rankings are low Professional reporting:** HTML-formatted emails ready for client delivery Competitor analysis:** See who's ranking above you with full SERP data Scalable architecture:** Easy to extend for enterprise-level monitoring This workflow transforms manual rank checking into an intelligent, automated system that not only tracks your performance but actively helps you improve it with AI-driven recommendations. Developed by Gegenfeld 🡥 and codecope 🡥 in Berlin, Germany.

Who is this template for? This SEO Reporting workflow template is ideal for digital marketers, SEO consultants, content strategists, and founders who need to quickly gather, format, and store Google search result data. If you regularly audit SERPs, track keyword performance, or monitor competitors, this automation lets you generate polished SEO reports in seconds—ready to share or analyze further. What problem does this workflow solve? Scraping and formatting Google search results for SEO insights is often manual, repetitive, and error-prone or requires expensive software. Professionals frequently face challenges like: Collecting live, structured data from Google for multiple keywords Converting raw search results into readable reports for clients or stakeholders Logging changes in rankings or URLs across time for historical tracking Exporting SEO data into spreadsheets for deeper analysis High monthly software fees What this workflow does This n8n workflow scrapes the top organic Google search results for a given keyword and automatically creates a downloadable report while also logging the results in a table format for long-term storage or further processing. Here’s what it includes: A trigger form that accepts a search keyword from the user An automated API call to fetch Google’s SERP data Two output formats: a formatted HTML table for emails and a Markdown table for download (e.g., for Excel, Airtable or Google Sheets) Automatic CSV file generation for download Optional email delivery of the report Setup Getting started is simple: Enter your API key Add your API key to the “Scrape Google SERPs” HTTP Request node (Step-by-step guide inside the template) Replace the default query with your own custom Google search parameters if needed Set up delivery options Update your email in the “Mail SEO Report” node for report delivery Use the downloadable file output from the “Convert to File” node Optional: Add a Google Sheets (or similar) node which imports the file Test the workflow Use the built-in form to input a keyword Confirm that results appear in both your email and downloadable file Activate the workflow Turn on the trigger so your team or clients can submit keywords at any time How to customize this workflow This template is easy to extend for a variety of SEO automation needs: Add a loop to handle multiple keywords at once Connect to Airtable, Notion or Google Sheets Integrate with Slack or Discord for notifications Apply additional filtering to track only new or changed search results Schedule it to run daily or weekly with a cron trigger By combining live SERP scraping, report formatting, and spreadsheet integration, this workflow gives you a fast and flexible SEO reporting system you can use right away or scale up as needed.