Automated Daily Keyword Research Workflow

This n8n workflow streamlines the process of daily keyword research by integrating Google Sheets, Google Suggest API, and Google Custom Search. It helps SEO specialists, marketers, and content creators discover relevant keywords, generate autocomplete suggestions, and analyze top search results automatically. The workflow begins with a manual trigger, fetches a list of keywords from a Google Sheet, and selects a keyword based on the number of days since a specific start date to ensure daily variation. It then retrieves autocomplete suggestions for the selected keyword using Google’s Suggest API, searches Google for each suggestion via the Custom Search API, and formats the results into a structured JSON with titles, links, and snippets. This automation enables efficient content planning, trend analysis, and SEO optimization without manual effort, making it ideal for building content pipelines or conducting ongoing keyword research.