# Need help with keyword research (automation)

**URL:** <https://onehack.st/t/need-help-with-keyword-research-automation/303539>\
**Category:** Discussion & Solutions\
**Tags:** solved\
**Created:** [April 11, 2025, 5:14pm UTC](https://onehack.st/t/need-help-with-keyword-research-automation/303539 "2025-04-11T17:14:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sir\_dean](https://onehack.st/user_avatar/onehack.st/sir_dean/32/153935_2.png) [@sir\_dean](https://onehack.st/u/sir_dean)\
**Post date:** [April 11, 2025, 5:14pm UTC](https://onehack.st/t/need-help-with-keyword-research-automation/303539/1 "2025-04-11T17:14:11Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Mr419](https://onehack.st/user_avatar/onehack.st/mr419/32/149184_2.png) [@Mr419](https://onehack.st/u/Mr419)\
**Post date:** [April 11, 2025, 10:53pm UTC](https://onehack.st/t/need-help-with-keyword-research-automation/303539/2 "2025-04-11T22:53:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![CodeZera](https://onehack.st/user_avatar/onehack.st/codezera/32/123536_2.png) [@CodeZera](https://onehack.st/u/CodeZera)\
**Post date:** [April 13, 2025, 12:36pm UTC](https://onehack.st/t/need-help-with-keyword-research-automation/303539/3 "2025-04-13T12:36:12Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sir\_dean](https://onehack.st/user_avatar/onehack.st/sir_dean/32/153935_2.png) [@sir\_dean](https://onehack.st/u/sir_dean)\
**Post date:** [April 13, 2025, 7:25pm UTC](https://onehack.st/t/need-help-with-keyword-research-automation/303539/4 "2025-04-13T19:25:12Z")

</div>

I tried GitHub, but mostly not working.

Uipath seems another solution for it. But yet to try

---

<div class="post-metadata">

**Author:** ![Tje](https://onehack.st/user_avatar/onehack.st/tje/32/133717_2.png) [@Tje](https://onehack.st/u/Tje)\
**Post date:** [April 17, 2025, 1:49pm UTC](https://onehack.st/t/need-help-with-keyword-research-automation/303539/5 "2025-04-17T13:49:05Z")

</div>

Please come back and update us if you succeed