Overview
The SEO Keyword Generator workflow turns customer profiles into actionable SEO keywords. By describing your ideal customer, the workflow uses an LLM to generate 15–20 relevant seed keywords and automatically writes them, one per row, into a Google Sheet—creating a centralized keyword database for SEO and content planning.
Who This Is For
- SEO specialists: Rapidly generate seed keyword sets for different personas, products, or segments.
- Content marketing teams: Build and maintain a shared keyword backlog that directly reflects real customer needs.
- Growth and demand gen teams: Quickly surface potential search terms for campaigns and landing pages across markets.
- Agencies and consultants: Standardize how you turn client discovery insights into structured keyword lists.
How It Works
- Collect the customer profile
- The Start node gathers all startup parameters, including product, painpoints, goals, currentsolutions, and expertiselevel.
- Generate seed keywords with LLM
- The LLM node receives the full profile and, based on the system prompt, returns a plain-text list of 15–20 seed SEO keywords tailored to that audience.
- Iterate through each keyword
- The Iteration node splits the plain-text list into individual keywords and loops through them one by one.
- Write keywords to Google Sheets
- Inside the loop, a “Write Keyword to Sheet” (Append Row) node adds each keyword as a new row at the end of your specified spreadsheet, creating a clean, structured keyword list ready for further SEO work.
What You'll Need
- A Google account with access to Google Sheets
- A target Google Sheet to store generated keywords
- The SpreadsheetId and the SheetName
- A complete customer profile, including:
- product
- painpoints
- goals
- currentsolutions
- expertiselevel
How to Use
- Step 1.Configure Google Sheets credentials
- Open the “Write Keyword to Sheet” node inside the loop and connect your Google account. Grant permission so the workflow can append rows to your Google Sheet.
- Step 2.Prepare your Google Sheet
- Create a new Google Sheet (or choose an existing one).
- Copy the file’s ID from the URL (the long string between /d/ and /edit).
- Note the worksheet name you want to write to (for example, Sheet1).
- Enter these values into the workflow’s SpreadsheetId and SheetName startup parameters.
- Step 3.Fill in startup parameters
- Provide all customer profile fields at the Start node. For example:
- Run the workflow. It will generate a seed keyword list based on this profile and automatically append each keyword as a new row in your Google Sheet.
"product": "An all-in-one project management and collaboration platform designed for remote marketing teams.", "painpoints": "Scattered communication, chaotic approvals, and no unified view of campaign status.", "goals": "Streamline content workflows, improve collaboration, and gain clear visibility into all marketing activities.", "currentsolutions": "A mix of Trello, Google Sheets, Slack, and email, causing version issues and manual updates.", "expertiselevel": "An experienced marketer who wants a professional, intuitive tool without complex setup."
FAQs
How many keywords are generated each time?
By default, the LLM is instructed to produce 15–20 seed keywords. You can adjust this by editing the system prompt in the LLM node if you need more or fewer keywords.
Do I need SEO expertise to use this template?
No. As long as you can clearly describe your customer and their context, the workflow will generate relevant keyword ideas for you. SEO specialists can then refine, expand, or group them as needed.
Can I avoid duplicate keywords across runs?
The base template doesn’t deduplicate keywords. However, you can extend the workflow by adding a lookup or filtering step before appending rows to check if a keyword already exists in the sheet.
Can I run this workflow for multiple products or customer segments?
Yes. You can rerun the workflow with different startup parameters for each product or persona. All generated keywords can be written to the same sheet (or different sheets) depending on how you want to organize them.
