Automate Daily Keyword Research: Google Sheets, Suggest & Custom Search
Automates daily keyword discovery by rotating through a Google Sheets list, fetching Google Suggest autocompletes, and pulling top Custom Search results into structured JSON for SEO and content creation.
This workflow streamlines keyword research for SEO specialists, marketers, bloggers, and content creators. It rotates through a list of seed keywords in Google Sheets, selecting one per day based on a configurable start date (default July 4, 2025). For the chosen keyword, it queries the Google Suggest API to retrieve autocomplete suggestions, then uses the Google Custom Search API to fetch top search results including titles, links, and snippets, outputting everything in clean JSON format.
Key
Platform
n8n
Category
Customer Support
Price
$14.99
Creator
Jose Maurino
SEO
Keyword Research
Google Sheets
Google Suggest
Custom Search API
Marketing Automation
Content Creation
Daily Automation
JSON Output
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.