Need help with keyword research (automation)

Discussion & Solutions
1

Description
=Hey everyone,

I’m working on automating my keyword research process using free tools, APIs, Zapier, and Google Sheets—ideally to reduce manual work and speed up content planning for my eCommerce store.

So far, I’ve figured out how to pull keyword suggestions from free sources like Google Autocomplete using Zapier Webhooks and log them into Google Sheets. But I want to take it further.

What I need help with:

  1. Automating keyword research from seed keywords based on my product catalog.

  2. Using those keywords to generate SEO-rich blog topic ideas that are data-driven and aligned with my product features.

  3. Building a system to generate around 50 blog post ideas/month, so I can scale traffic to 10K/month in 2–3 months.

Bonus: If anyone has done this using ChatGPT API + Google Sheets (or a low-code solution) to auto-generate blog topics or outlines, I’d love to see examples.

Thanks in advance! Happy to share what I’ve built so far too.

5 Likes
2

my suggestion use grok or something. tell it your dilema and ask for a github repo that addresses it. it’ll definitely help alot

1 Like
3

I am working on something similar for my shopify store, automated keyword research based product listing where you just have to share images and brief description about product on telegram channel.
I am using N8N for now but I am also limited by my technical knowledge

4

I tried GitHub, but mostly not working.

Uipath seems another solution for it. But yet to try

5

Please come back and update us if you succeed