Generate SEO Keywords
Generate SEO seed keywords from your ICP stored in Notion. The workflow fetches your ICP page from Notion, uses AI to produce 30 keyword clusters with intent, stage, priority, difficulty, and content angle, then writes results to Google Sheets for planning.
Key Takeaways
- 30 keyword clusters generated - AI produces exactly 30 seed keywords with intent labels, funnel stage, priority, and content angles
- ICP-driven - Fetches your Ideal Customer Profile from Notion to tailor keywords to your audience
- Structured output - Results include topic, keyword cluster, intent label, stage, priority, difficulty, and content angle
- Exports to Google Sheets - Writes all keyword rows directly to your spreadsheet for content planning
- Customizable intent mix - Default split: 40% informational, 30% commercial, 20% transactional, 10% navigational
What This Workflow Does
This workflow generates SEO seed keywords based on your Ideal Customer Profile stored in Notion. It fetches your ICP page, sends it to an AI model that produces 30 keyword clusters with intent labels and content angles, then writes the results to Google Sheets. You get a ready-to-use keyword plan for content strategy.
Use cases:
- Kickstart content planning with targeted keyword clusters
- Generate keyword ideas aligned to your ICP and funnel stages
- Build a prioritized keyword list for blog posts, landing pages, or ads
How It Works
| Step | What Happens |
|---|---|
| 1. Manual trigger | You enter a topic or seed keyword |
| 2. Fetch ICP | Notion connector retrieves your Ideal Customer Profile page |
| 3. AI keyword generation | GPT analyzes the ICP and generates 30 keyword clusters as JSON |
| 4. Parse JSON | Transform node cleans and parses the AI output |
| 5. Write to Sheets | Google Sheets connector saves all rows to your spreadsheet |
Setup Instructions
- Click "Use template" on this page
- Connect your Notion connector and update the Notion node with your ICP page URL
- Connect your Google Sheets connector and update the sheet URL in the Google Sheets node
- Enter a topic or seed keyword in the Manual Trigger
- Run the workflow
- Check your Google Sheet for the generated keyword plan
Customization
| What You Can Change | How |
|---|---|
| ICP source | Update the Notion node to point to a different ICP page |
| Number of keywords | Edit the AI prompt to generate more or fewer than 30 clusters |
| Intent mix | Adjust the percentage breakdown in the AI prompt |
| AI model | Swap the model in the AI node (e.g. Claude, Gemini) |
| Output columns | Modify the AI prompt and Google Sheets node to add or remove fields |
FAQ
Q: Do I need an ICP in Notion? A: The template is designed to pull your ICP from Notion. If you don't have one, you can replace the Notion node with a manual input describing your target audience.
Q: What format does the output use? A: Each row includes: Topic, Keyword Cluster, Intent Label, Stage (TOFU/MOFU/BOFU), Priority (1-5), Difficulty (Low/Medium/High), and Content Angle.
Q: Can I use this without Google Sheets? A: Yes, you can remove the Sheets node and use the JSON output directly from the AI node.
Q: How accurate are the difficulty ratings? A: The difficulty ratings are AI-generated heuristics, not based on live search data. Use them as a starting point and validate with your preferred SEO tool.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.