Generate SEO Keywords from Market Trends
Automatically analyze competitors and market trends to generate SEO-optimized keywords and intent-based search queries for your workflows, ensuring maximum discoverability and organic growth.
Last updated
October 2, 2025
Connectors used
Tags
Key Takeaways
- Automated keyword research from real search data - The workflow searches the web for each item in your spreadsheet and uses AI to extract the most relevant keywords from actual search results.
- Intent-based query discovery - Beyond keywords, the AI generates the exact phrases people type when looking for solutions like yours.
- Google Sheets in, Google Sheets out - You provide your list of workflows or products in a spreadsheet, and the results are written back to the same sheet.
- Structured AI output - The AI node uses a defined output schema, returning clean arrays of keywords and queries that can be used directly.
What This Workflow Does
This workflow takes a list of your workflows, products, or content topics from Google Sheets, searches the web for each one, and uses AI to generate the top keywords and intent-based search queries people use to find similar solutions. The results are written back to your spreadsheet so you can use them for SEO planning, content creation, or landing page optimization. It turns manual keyword research into an automated, data-driven process.
Use cases:
- Generating SEO keywords for product pages or workflow templates
- Discovering how users search for solutions in your market
- Building a keyword database for content marketing and landing page optimization
How It Works
| Step | What Happens |
|---|---|
| 1. Manual trigger | You start the workflow when ready. |
| 2. Fetch spreadsheet data | Reads all rows from your Google Sheets document containing your workflows or products. |
| 3. Parse rows | A code node converts the raw spreadsheet data into structured objects using the header row. |
| 4. Web search | Needle's web search queries Google for each item based on its name and category. |
| 5. AI keyword analysis | GPT-4.1 analyzes the search results and generates a structured output with the top 10 keywords and top 5 intent-based search queries for each item. |
| 6. Transform results | The AI output is wrapped into a structured format for merging. |
| 7. Merge with original data | The AI-generated keywords and queries are combined with the original spreadsheet data. |
| 8. Update spreadsheet | The keywords and intent queries are written back to your Google Sheets document. |
Workflow Nodes
| Node | Role |
|---|---|
| Manual Trigger | Starts the workflow on demand |
| Google Sheets - Get Values in Range | Fetches all rows from your spreadsheet |
| Code - Parse Rows | Maps raw row arrays into structured objects using column headers |
| Needle Web Search | Searches Google for each workflow or product |
| AI Node (GPT-4.1) | Generates top 10 keywords and top 5 intent search queries (structured output) |
| Transform | Wraps the AI results for merging |
| Merge | Combines original row data with AI-generated insights |
| Google Sheets - Update Multiple Rows | Writes the keywords and queries back to the spreadsheet |
Setup Instructions
- Add the "Generate SEO Keywords from Market Trends" template to your Needle workspace.
- Create a Google Sheets spreadsheet with these columns: Rank, Template Name, Repo Category, Why this is top-tier, Primary Output(s), top_10_keywords, top_5_queries.
- Fill in the first five columns with your workflow or product data. Leave the last two columns empty for the workflow to fill.
- Connect your Google Sheets account in Needle and update the nodes with your spreadsheet URL.
- Run the workflow manually to generate keywords for all rows.
Customization
| What You Can Change | How |
|---|---|
| Number of keywords | Edit the AI prompt to request more or fewer keywords (default is top 10 keywords and top 5 intent queries) |
| Keyword focus | Adjust the AI prompt to emphasize specific aspects like long-tail keywords, question-based queries, or competitor terms |
| Spreadsheet columns | Update the column references in the Google Sheets update node if your sheet layout differs |
| Search scope | Modify the Web Search node instructions to narrow or broaden what gets searched |
| AI model | Change the model in the AI node if you want to use a different one |
FAQ
Q: What columns does the workflow write to in Google Sheets? A: It writes to the top_10_keywords and top_5_queries columns (columns F and G by default). It does not modify any other columns.
Q: How many items can I process in one run? A: The batch update node handles up to 50 rows at a time. For larger lists, you can use the row-by-row upsert node included in the workflow as an alternative.
Q: What does "intent-based search queries" mean? A: These are the actual phrases someone would type into Google when looking for a solution. For example, instead of just the keyword "email automation," an intent query might be "how to automate outreach emails from a spreadsheet."
Q: Can I use this for things other than workflows? A: Yes. Any product, service, or content topic you list in the spreadsheet can be analyzed. The workflow searches the web and generates keywords based on whatever data you provide.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
