Weekly Competitor Blog Analysis
Apps
Creator
Kirill Zheleznov
Overview
💡 What It Does
Automatically monitors your competitors' blogs for new content each week and delivers an AI-powered summary straight to your Slack DMs.
📥 What You Provide
| Input | What to enter |
|---|---|
| google_sheet_url | Google Sheets URL containing your competitor list with "Name" and "Blog" columns |
| slack_user_name | Your Slack username (e.g., "username123") |
| days_lookback | How many days to look back for articles (optional, defaults to 7 days) |
⚡ What Happens
Actions:
- Sends message to Slack, updates Google Sheets
Returns:
- AI-generated summary of competitor blog articles and analysis statistics
How:
- Read competitor list → Search for new articles → Analyze with AI → Send Slack summary → Save to spreadsheet
📤 What You Get Back
| Output | Description |
|---|---|
| summary | AI-generated overview of all new competitor content found |
| articles_found | Total number of new articles discovered |
| competitors_analyzed | How many competitor blogs were checked |
| slack_message_sent | Whether your Slack notification was delivered |
| sheet_updated | Whether results were saved to your spreadsheet |
🔌 Connections Required
| App | Why |
|---|---|
| Google Sheets | Read competitor list and save analysis results |
| Perplexity AI | Generate intelligent summaries of competitor content |
| Slack | Send you the weekly summary via direct message |
📋 Good to Know
Best for:
- Marketing teams tracking competitor content strategy
Tip:
- Keep your competitor list updated in the Google Sheet for best coverage
Limit:
- Requires competitor blogs to be publicly accessible
Built with ❤️ by Rube • All recipes can be scheduled to run automatically