[[{“value”:”
Hi everyone π Luis & Rui here with an AI-powered SEO deep dive.
Want to build a bulletproof keyword research pipeline with the help of AI?
In this issue, weβll show you how to leverage Perplexity AI combined with ChatGPT to generate rich, intent-driven keyword lists in minutes and export them into a ready-to-upload CSV for Google Sheets.
Letβs go!
π§° What You Need
-
Perplexity account (free tier is enough)
-
ChatGPT account (for CSV generation)
-
Google Sheets (or Excel)
Hereβs the workflow youβll follow before diving into each prompt:
-
Run each prompt in the same Perplexity conversation to pull rich data for primary, long-tail, voice-style, FAQ, and semantic terms.
-
Copy all outputs from Perplexity once youβve completed prompts 1β5.
-
Paste everything into ChatGPT with our CSV wrapper prompt to automatically generate a structured download.
-
Import the CSV into Google Sheets or Excel for filtering, sorting, and review.
-
Pick any high-value term and re-run prompts 2β5 in Perplexity for deeper cluster expansion.
1. Main Topic Keywords π
Prompt:
Generate a prioritized list of the 25β30 highest-volume primary keywords for INSERT_TOPIC, including for each entry:
Estimated monthly search volume (globally and by major English-speaking region)
Average cost per click (CPC) on Google Ads
Broad competition score (Low/Med/High)
Primary user intent (Informational/Transactional/Navigational)
Suggested URL or content type that typically ranks in position 1
Sort by descending search volume and highlight any keywords with CPC above $2.00.
2. Long-Tail & Modifier Keywords π
Prompt:
Identify 30β50 long-tail keyword phrases (4+ words) closely tied to INSERT_TOPIC, and for each:
Monthly search volume
Modifier type (e.g., βhow to,β βbest,β location-based, problem-solution)
Difficulty estimate (Low/Med/High)
Geographic or seasonal modifiers (e.g., β2025,β city names)
Cluster label by modifier type (e.g., βHow toβ¦β vs βBest β¦β)
3. Conversational (NLP) Queries π¬
“}]] Read MoreΒ in Β The AI BreakΒ