I need to create an automated SEO system based on n8n that will collect data from various services, combine it, and send it to ChatGPT for analysis.
It is necessary to connect
- Ahrefs
- Google Search Console
- Google Analytics 4
- Google Ads
The first stage is a minimum viable version
- Connect Google Search Console.
- Connect GA4.
- Connect Ahrefs, if my plan and API allow it.
- Store daily data.
- Send it to ChatGPT.
- Send one daily report to Telegram or email.
- Set up analysis for the site
viarcanvas.com and the competitor picturehappy.lv. After verifying the functionality, add Google Ads, additional countries, competitors, and extended reports.
What needs to be obtained from Ahrefs
For the site viarcanvas.com and selected competitors:
- organic keywords;
- current positions;
- position changes;
- search volume of queries;
- estimated traffic;
- pages that receive organic traffic;
- new and lost keywords;
- new and lost backlinks;
- competitor pages that have increased traffic;
- new competitor keywords;
- Content Gap between our site and competitors.
The list of competitors should be editable without changing the n8n script itself.
What needs to be obtained from Google Search Console
- clicks;
- impressions;
- CTR;
- average position;
- queries;
- pages;
- countries;
- devices;
- changes in metrics by days and periods.
It is important that the data can be analyzed separately for each language version:
A separate analysis of specific pages is also needed, for example:
https://viarcanvas.com/lv/new/canvas
What needs to be obtained from Google Analytics 4
- users;
- sessions;
- organic traffic;
- landing pages;
- purchases;
- leads;
- revenue;
- conversion rate;
- engagement;
- countries and devices.
It is necessary to link SEO traffic not only to visits but also to leads, orders, and revenue.
What needs to be obtained from Google Ads
- spending;
- clicks;
- impressions;
- CTR;
- CPC;
- conversions;
- cost per conversion;
- revenue;
- ROAS;
- search queries;
- data on campaigns and countries.
Google Ads should be analyzed separately from organic SEO but included in the overall marketing report.
What ChatGPT should analyze
ChatGPT should automatically determine:
- which keywords have increased;
- which keywords have decreased;
- which pages have lost traffic;
- which pages have started to grow;
- where impressions have decreased;
- where CTR has decreased;
- where the average position has worsened;
- which pages are in positions 4–15 and have the potential to reach the TOP;
- which keywords have impressions but few clicks;
- which competitor pages are growing faster than ours;
- which queries competitors have that we do not;
- which articles should be written;
- which existing pages should be updated;
- where query cannibalization is possible;
- where internal linking is needed;
- which pages should be strengthened with external links;
- which changes require urgent attention.
ChatGPT should not just list numbers. It should explain the likely reasons for changes and provide a specific action plan.