✨ Get access to my workflows and learn how to create scalable no-code AI automations 👇
https://www.skool.com/ai-automation-community
🤖 Get the best SEO automations here:
https://marvomatic.com/products/
📩 Sign up for my newsletter to get more free workflows, automation tips, and tricks delivered straight to your inbox!
https://marvomatic.com/newsletter/
🛠️ Save time and money, and start building with n8n. (I get a kickback if you sign up – thank you)
https://marvomatic.com/go/n8n/
Business Inquiries:
📧 hello@marvomatic.com
Free & Premium n8n Tempplates:
https://marvomatic.com/products/
TIMESTAMPS:
00:00 Introduction & Report Overview
00:46 Using the Automation Form
02:37 Understanding the Google Sheet Integration
03:27 Workflow Pattern Explained
05:08 Working with the Google Slide API
07:00 Linking Charts Between Sheets and Slides
09:32 Adding Data to Google Sheets
11:10 Fetching Google Search Console Data
13:06 Fetching Google Analytics 4 Data
15:06 AI-Generated Insights with LLM
17:30 Final Report Review & Conclusion
Learn how to create stunning automated SEO reports using n8n workflows. This tutorial shows you how to pull data from Google Search Console and Google Analytics 4, generate AI-powered insights using LLMs, and present everything in beautiful Google Slides with dynamic charts. Simply fill out a form with your property details, and the automation handles everything—from data fetching to creating linked charts and generating intelligent analysis. Perfect for agencies and SEO professionals who want to save hours on reporting.
source