Automated Google Business reports with GPT insights to Slack & email
Created by: Peyton Leveillee
Last updated: October 2025
🧠 TL;DR
Marketing companies charge hundreds or even thousands per month for automated “Google Business Pulse” reports that show visibility, reviews, and engagement trends.
Now you can do it for free — right inside n8n.
This workflow pulls Google Business data, compares weekly and 12-week trends, runs it through an LLM for insight summaries, and sends out Slack updates and weekly email reports — automatically.
🔥 Name: Google Pulse Pro
Your AI marketing analyst that runs 24/7 — no subscription, no fluff.
🧩 Categories
- Business Intelligence
- Marketing Automation
- AI Summarization
- Multichannel Reporting
💬 Overview
Google Pulse Pro automates weekly Google Business reporting for multiple companies or locations.
It combines data collection, trend analysis, and AI commentary into a fully automated system — delivering updates through Slack and email.
Perfect for agencies or businesses that want client-ready, insight-driven updates without paying for SaaS dashboards.
⚙️ Good to Know
- Uses OpenAI Chat Models for summarization and insights
- Integrates Google Business API, Google Sheets, Slack, and Email (Gmail or SMTP)
- Compares this week vs last week and 12-week averages
- Outputs LLM-generated summaries formatted for Slack Blocks and email templates
- 100% no-code friendly — ready to deploy instantly
🧠 How It Works
-
Read Companies (Google Sheets)
Loads company info, Google Business IDs, Slack channels, and recipient emails. -
Pull Google Business Data
Queries the Google Business API for impressions, actions, CTR, and reviews across:- This week
- Last week
- 12-week average
-
Summarize & Compare
Code nodes calculate trends and append results back to Google Sheets. -
AI Summaries (OpenAI)
Three separate LLMs generate insight lines:- Impressions one-liner → Visibility & engagement shifts
- Reviews one-liner → Sentiment & reputation trends
- Overall one-liner → Combined marketing summary
-
Format & Distribute
All one-liners merge per company. Recipients are attached, and messages are formatted for output. -
Send Reports
- Slack: Beautifully formatted updates via Slack Blocks
- Email: Branded Weekly Google Business Pulse summaries
📈 Example Output
Slack Message:
Weekly Google Reviews & Impressions Number 1 Auto Repair Sept 22–28, 2025
• Impressions down 41% vs last week • CTR 3pp lower than 12-week avg • 2 new reviews, 100% positive sentiment
Email Pulse:
🧾 Requirements
- Google Business API credential (OAuth2)
- Google Sheets credential (OAuth2)
- Slack credential (OAuth2) —
chat:write,users:read,channels:read - Gmail or SMTP credential (for email pulse delivery)
- OpenAI credential (for summaries)
✏️ Customizing
- Add other KPIs (Google Ads, GA4, POS data)
- Adjust scheduling cadence (daily, bi-weekly, monthly)
- Send reports to Notion, Airtable, or HubSpot
- Update Slack + email branding for your agency
💡 Use Cases
- Agencies automating client reporting
- Multi-location businesses monitoring reputation
- Service centers tracking performance trends
- Anyone tired of paying for “Google Business Pulse” dashboards
🎯 Why It Matters
Most marketing firms hide behind “AI dashboards” to sell visibility reports.
Google Pulse Pro gives you that same power — automated, AI-enhanced, and free.
Unchain your reporting. Impress clients.
And keep your marketing dollars where they belong — in your business.
Automated Google Business Reports with GPT Insights to Slack & Email
This n8n workflow automates the process of generating comprehensive Google Business Profile reports, enriching them with AI-powered insights, and then distributing these reports to Slack and email. It simplifies the task of monitoring business performance and communicating key findings to stakeholders.
What it does
- Schedules Report Generation: Triggers daily at 9:00 AM to initiate the report generation process.
- Fetches Google Business Profile Data: Retrieves performance metrics and insights from your specified Google Business Profile.
- Generates AI-Powered Insights: Uses an OpenAI Chat Model and a Structured Output Parser to analyze the Google Business data and generate actionable insights and summaries.
- Formats Data for Reporting: Processes and structures the raw data and AI insights into a readable format.
- Logs Data to Google Sheets: Records the generated report data, including AI insights, into a Google Sheet for historical tracking and further analysis.
- Sends Slack Notification: Posts a summary of the report and AI insights to a designated Slack channel.
- Sends Email Report: Dispatches a detailed email report containing the Google Business data and AI insights to specified recipients.
Prerequisites/Requirements
- n8n Instance: A running n8n instance.
- Google Business Profile Account: Access to a Google Business Profile.
- Google OAuth2 Credentials: Configured Google OAuth2 credentials in n8n for Google Business Profile, Google Sheets, and Gmail.
- OpenAI API Key: An OpenAI API key with access to the Chat Model.
- Slack Account: A Slack workspace and an Incoming Webhook or Slack App credentials for posting messages.
- Google Sheet: A pre-existing Google Sheet to store the report data.
Setup/Usage
- Import the Workflow: Download the provided JSON and import it into your n8n instance.
- Configure Credentials:
- Google Business Profile: Set up your Google OAuth2 credentials.
- Google Sheets: Set up your Google OAuth2 credentials and specify the Spreadsheet ID and Sheet Name where the data should be logged.
- OpenAI Chat Model: Provide your OpenAI API Key.
- Slack: Configure your Slack credentials (e.g., OAuth or Webhook URL) and specify the channel ID.
- Gmail: Set up your Google OAuth2 credentials and specify the recipient email addresses.
- Customize the AI Agent: Review and adjust the prompt in the "AI Agent" node to tailor the AI insights to your specific needs.
- Adjust Schedule: Modify the "Schedule Trigger" node to change the frequency or time of the report generation if desired.
- Activate the Workflow: Once all credentials and configurations are set, activate the workflow.
Related Templates
Auto-create TikTok videos with VEED.io AI avatars, ElevenLabs & GPT-4
💥 Viral TikTok Video Machine: Auto-Create Videos with Your AI Avatar --- 🎯 Who is this for? This workflow is for content creators, marketers, and agencies who want to use Veed.io’s AI avatar technology to produce short, engaging TikTok videos automatically. It’s ideal for creators who want to appear on camera without recording themselves, and for teams managing multiple brands who need to generate videos at scale. --- ⚙️ What problem this workflow solves Manually creating videos for TikTok can take hours — finding trends, writing scripts, recording, and editing. By combining Veed.io, ElevenLabs, and GPT-4, this workflow transforms a simple Telegram input into a ready-to-post TikTok video featuring your AI avatar powered by Veed.io — speaking naturally with your cloned voice. --- 🚀 What this workflow does This automation links Veed.io’s video-generation API with multiple AI tools: Analyzes TikTok trends via Perplexity AI Writes a 10-second viral script using GPT-4 Generates your voiceover via ElevenLabs Uses Veed.io (Fabric 1.0 via FAL.ai) to animate your avatar and sync the lips to the voice Creates an engaging caption + hashtags for TikTok virality Publishes the video automatically via Blotato TikTok API Logs all results to Google Sheets for tracking --- 🧩 Setup Telegram Bot Create your bot via @BotFather Configure it as the trigger for sending your photo and theme Connect Veed.io Create an account on Veed.io Get your FAL.ai API key (Veed Fabric 1.0 model) Use HTTPS image/audio URLs compatible with Veed Fabric Other APIs Add Perplexity, ElevenLabs, and Blotato TikTok keys Connect your Google Sheet for logging results --- 🛠️ How to customize this workflow Change your Avatar: Upload a new image through Telegram, and Veed.io will generate a new talking version automatically. Modify the Script Style: Adjust the GPT prompt for tone (educational, funny, storytelling). Adjust Voice Tone: Tweak ElevenLabs stability and similarity settings. Expand Platforms: Add Instagram, YouTube Shorts, or X (Twitter) posting nodes. Track Performance: Customize your Google Sheet to measure your most successful Veed.io-based videos. --- 🧠 Expected Outcome In just a few seconds after sending your photo and theme, this workflow — powered by Veed.io — creates a fully automated TikTok video featuring your AI avatar with natural lip-sync and voice. The result is a continuous stream of viral short videos, made without cameras, editing, or effort. --- ✅ Import the JSON file in n8n, add your API keys (including Veed.io via FAL.ai), and start generating viral TikTok videos starring your AI avatar today! 🎥 Watch This Tutorial --- 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube
By Dr. FirasTrack competitor SEO keywords with Decodo + GPT-4.1-mini + Google Sheets
This workflow automates competitor keyword research using OpenAI LLM and Decodo for intelligent web scraping. Who this is for SEO specialists, content strategists, and growth marketers who want to automate keyword research and competitive intelligence. Marketing analysts managing multiple clients or websites who need consistent SEO tracking without manual data pulls. Agencies or automation engineers using Google Sheets as an SEO data dashboard for keyword monitoring and reporting. What problem this workflow solves Tracking competitor keywords manually is slow and inconsistent. Most SEO tools provide limited API access or lack contextual keyword analysis. This workflow solves that by: Automatically scraping any competitor’s webpage with Decodo. Using OpenAI GPT-4.1-mini to interpret keyword intent, density, and semantic focus. Storing structured keyword insights directly in Google Sheets for ongoing tracking and trend analysis. What this workflow does Trigger — Manually start the workflow or schedule it to run periodically. Input Setup — Define the website URL and target country (e.g., https://dev.to, france). Data Scraping (Decodo) — Fetch competitor web content and metadata. Keyword Analysis (OpenAI GPT-4.1-mini) Extract primary and secondary keywords. Identify focus topics and semantic entities. Generate a keyword density summary and SEO strength score. Recommend optimization and internal linking opportunities. Data Structuring — Clean and convert GPT output into JSON format. Data Storage (Google Sheets) — Append structured keyword data to a Google Sheet for long-term tracking. Setup Prerequisites If you are new to Decode, please signup on this link visit.decodo.com n8n account with workflow editor access Decodo API credentials OpenAI API key Google Sheets account connected via OAuth2 Make sure to install the Decodo Community node. Create a Google Sheet Add columns for: primarykeywords, seostrengthscore, keyworddensity_summary, etc. Share with your n8n Google account. Connect Credentials Add credentials for: Decodo API credentials - You need to register, login and obtain the Basic Authentication Token via Decodo Dashboard OpenAI API (for GPT-4o-mini) Google Sheets OAuth2 Configure Input Fields Edit the “Set Input Fields” node to set your target site and region. Run the Workflow Click Execute Workflow in n8n. View structured results in your connected Google Sheet. How to customize this workflow Track Multiple Competitors → Use a Google Sheet or CSV list of URLs; loop through them using the Split In Batches node. Add Language Detection → Add a Gemini or GPT node before keyword analysis to detect content language and adjust prompts. Enhance the SEO Report → Expand the GPT prompt to include backlink insights, metadata optimization, or readability checks. Integrate Visualization → Connect your Google Sheet to Looker Studio for SEO performance dashboards. Schedule Auto-Runs → Use the Cron Node to run weekly or monthly for competitor keyword refreshes. Summary This workflow automates competitor keyword research using: Decodo for intelligent web scraping OpenAI GPT-4.1-mini for keyword and SEO analysis Google Sheets for live tracking and reporting It’s a complete AI-powered SEO intelligence pipeline ideal for teams that want actionable insights on keyword gaps, optimization opportunities, and content focus trends, without relying on expensive SEO SaaS tools.
By Ranjan DailataGenerate song lyrics and music from text prompts using OpenAI and Fal.ai Minimax
Spark your creativity instantly in any chat—turn a simple prompt like "heartbreak ballad" into original, full-length lyrics and a professional AI-generated music track, all without leaving your conversation. 📋 What This Template Does This chat-triggered workflow harnesses AI to generate detailed, genre-matched song lyrics (at least 600 characters) from user messages, then queues them for music synthesis via Fal.ai's minimax-music model. It polls asynchronously until the track is ready, delivering lyrics and audio URL back in chat. Crafts original, structured lyrics with verses, choruses, and bridges using OpenAI Submits to Fal.ai for melody, instrumentation, and vocals aligned to the style Handles long-running generations with smart looping and status checks Returns complete song package (lyrics + audio link) for seamless sharing 🔧 Prerequisites n8n account (self-hosted or cloud with chat integration enabled) OpenAI account with API access for GPT models Fal.ai account for AI music generation 🔑 Required Credentials OpenAI API Setup Go to platform.openai.com → API keys (sidebar) Click "Create new secret key" → Name it (e.g., "n8n Songwriter") Copy the key and add to n8n as "OpenAI API" credential type Test by sending a simple chat completion request Fal.ai HTTP Header Auth Setup Sign up at fal.ai → Dashboard → API Keys Generate a new API key → Copy it In n8n, create "HTTP Header Auth" credential: Name="Fal.ai", Header Name="Authorization", Header Value="Key [Your API Key]" Test with a simple GET to their queue endpoint (e.g., /status) ⚙️ Configuration Steps Import the workflow JSON into your n8n instance Assign OpenAI API credentials to the "OpenAI Chat Model" node Assign Fal.ai HTTP Header Auth to the "Generate Music Track", "Check Generation Status", and "Fetch Final Result" nodes Activate the workflow—chat trigger will appear in your n8n chat interface Test by messaging: "Create an upbeat pop song about road trips" 🎯 Use Cases Content Creators: YouTubers generating custom jingles for videos on the fly, streamlining production from idea to audio export Educators: Music teachers using chat prompts to create era-specific folk tunes for classroom discussions, fostering interactive learning Gift Personalization: Friends crafting anniversary R&B tracks from shared memories via quick chats, delivering emotional audio surprises Artist Brainstorming: Songwriters prototyping hip-hop beats in real-time during sessions, accelerating collaboration and iteration ⚠️ Troubleshooting Invalid JSON from AI Agent: Ensure the system prompt stresses valid JSON; test the agent standalone with a sample query Music Generation Fails (401/403): Verify Fal.ai API key has minimax-music access; check usage quotas in dashboard Status Polling Loops Indefinitely: Bump wait time to 45-60s for complex tracks; inspect fal.ai queue logs for bottlenecks Lyrics Under 600 Characters: Tweak agent prompt to enforce fuller structures like [V1][C][V2][B][C]; verify output length in executions
By Daniel Nkencho