This workflow is perfect for SEO specialists, marketers, bloggers, and content creators who want to automate keyword research using Google Sheets, Google Suggest, and Google Custom Search. Ideal for those building content pipelines, researching trends, or powering AI content generation with fresh search data.
This workflow automates the process of discovering a new keyword daily. It:
Rotates through a keyword list in Google Sheets
Selects one keyword per day
Fetches autocomplete suggestions from Google Suggest
Queries the Google Custom Search API for top results
Returns structured JSON containing titles, links, and snippets
Manual Trigger – Initiates workflow manually
Google Sheets – Reads keywords from a sheet (column: Title or Keyword)
Code Node – Selects a daily keyword based on the number of days since July 4, 2025
Set Node – Saves the selected keyword as seed_keyword
HTTP Request – Fetches autocomplete suggestions from Google Suggest API
Function Node – Parses suggestions into usable items
HTTP Request – Calls Google Custom Search API for each suggestion
Code Node – Formats the search results into JSON
Connect your Google Sheets OAuth2 credentials in n8n
Use credential variables for Google Custom Search (⚠️ do not hardcode your key and cx)
Replace the sample sheet ID with your own
Run the workflow manually or schedule it daily
Google account
Enabled Custom Search JSON API on Google Cloud
Google Sheet with a column labeled Title or Keyword
n8n instance (cloud or self-hosted)
Change the start date to control the keyword rotation cycle
Randomize keyword selection instead of rotating
Enrich results using tools like Ahrefs or SEMrush
Push final output to Telegram, Notion, Slack, or Airtable
Add filtering logic based on CPC, volume, or duplicates
📄 Click Here to access the example Google Sheet
Sheet must contain a column Title or Keyword in the first row:
Title
teknologi AI
berita viral
tren startup