Workflow - a Gegenfeld project - n8n workflow automation

Category: Marketing

  • Google SERPs Keyword Ranking Checker – n8n Workflow Template

    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.

    Get the template

    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:

    1. Connect your ScrapingBee account
    • 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
    1. 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 Sheet (or similar) node which imports the file
    1. Test the workflow
    • Use the built-in form to input a keyword
    • Confirm that results appear in both your email and downloadable file
    1. 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.

  • AI Keyword Generator

    This AI Keyword Generator workflow template is designed for marketers, SEO specialists, and content creators who need to quickly generate high-quality keyword lists for their content strategy. Instead of spending hours researching keywords manually, this AI-powered tool delivers targeted keyword suggestions based on your specific criteria.

    Get the template

    What problem does this workflow solve?

    Keyword research is a time-consuming but essential part of SEO and content marketing. Many professionals struggle with:

    • Finding relevant keywords that match specific search intents
    • Balancing between short-tail and long-tail keywords
    • Generating comprehensive keyword lists that cover different aspects of a topic
    • Consistently identifying high-potential keywords for content creation

    What this workflow does

    This n8n workflow leverages AI to automatically generate a customized list of 15-20 high-potential keywords based on three simple inputs:

    • Topic – The main subject area you want keywords for
    • Search Intent – Choose between Navigational, Informational, Commercial, or Transactional
    • Keyword Type – Select Short-Tail or Long-Tail keywords

    The workflow processes your input through an AI language model that follows SEO best practices to generate relevant keywords. It then formats the results and delivers them directly to your email inbox, ready for use in your SEO strategy.

    Setup

    Setting up this workflow is straightforward:

    1. Add your credentials for the AI language model in the “Select your Chat Model” node
    • Click on the node and connect your Groq account (and choose any LLM you want, like: OpenAI, Claude AI or Llama) or replace with another LLM provider
    1. Configure email delivery in the “Send Result” node
    • Update the “sendTo” parameter with your email address
    • Add your Gmail credentials or replace with your preferred email service
    1. Test your workflow by clicking the “Test Workflow” button
    • Use the form to enter your topic, search intent, and keyword type
    • Check your email for the generated keyword report
    1. Activate the workflow once testing is complete

    How to customize this workflow

    The template is highly adaptable to fit your specific needs:

    • Replace the email node with a database or spreadsheet node to store keywords
    • Modify the AI prompts in the “AI Keyword Agent” to adjust the keyword generation strategy
    • Add additional filtering nodes to further refine keywords based on custom criteria
    • Integrate with other SEO tools to analyze competition or search volume for generated keywords

    This workflow serves as a powerful starting point for automating your keyword research process, saving you valuable time while delivering consistent, high-quality results.