👉 Get all of our make.com templates here (including this one): https://www.theaiautomators.com/?utm_source=youtube&utm_medium=video&utm_campaign=tutorial&utm_content=slides_automation
UPDATE: Check out this video here on how to use the "Create a Presentation from a Template" module - https://www.youtube.com/watch?v=UY7jvdtfRHU
🚀 In this video, I’ll show you step-by-step how to build an automated system that generates fully customized, data-rich reports directly on Google Slides. In this example I create a comprehensive Monthly SEO Report but this will work in any industry where a data heavy report needs to be created.
Using Make.com, Airtable, and other tools, I’ve created a workflow that pulls data from sources like Google Analytics, Data for SEO, and WordPress, turning it into professional, client-ready presentations in just minutes.
✨ What you'll learn:
1️⃣ How to integrate data from Google Analytics, Data for SEO, and WordPress
2️⃣ How to set up dynamic placeholders in Google Slides for automation
3️⃣ How to streamline your reporting process to save hours every month
4️⃣ Tips for creating client-ready, branded reports with ease
Whether you're an SEO professional, marketer, or business owner, this tutorial will help you maximize efficiency and impress your clients with automated reports.
🛠️ Tools & Platforms Used:
Make: https://www.make.com/en/register?pc=aiauto
Airtable: https://airtable.com/
Google Slides: https://docs.google.com/presentation/create
Google Analytics: https://marketingplatform.google.com/about/analytics/
DataForSEO: https://dataforseo.com/
SlidesGo: https://slidesgo.com/
👋 Connect with Us: Have any questions or want to discuss more about AI automation? Drop your thoughts in the comments below or join our community to collaborate with other automation enthusiasts!
Chapters
00:00 Intro
02:12 High Level Overview
04:47 Creating the Google Slides Boilerplate
07:57 Extracting Google Analytics Data
13:38 Duplicating Boilerplate Deck
18:51 Populating Google Slides Placeholders
30:00 Extracting DataForSEO Data
37:41 Extracting Wordpress Data
45:30 Generating Insights and Summaries