Shata Solutions
← Back to marketplace
Social Media Automation

Competitor Content Tracker

Digest competitor posts, engagement deltas, and content themes every morning.

Automation overview

What this automation does

This automation starts when scheduled daily — 8 AM local time. It tiktok pulls, google sheets pulls, and notion process via notion, then and emails a Notion-linked summary highlighting three content angles you should counter or adapt this week.

Trigger
Scheduled daily — 8 AM local time
Main actions
TikTok pulls → Google Sheets pulls …
Final outcome
and emails a Notion-linked summary highlighting three content angles you should …
Execution time
30–90 seconds
Apps used
4 integrations
AI-powered
No
Difficulty
Beginner
Beginner
Workflow diagram

End-to-end scenario flow

Read-only visualization of how data moves from trigger to final result.

Trigger
Meta Insights
Scheduled run
Step 1
TikTok
Pulls
Step 2
Google Sheets
Pulls
Step 3
Notion
Process via Notion
Result
Notion
Workflow complete
Step-by-step

How each step runs

  1. 1
    Meta InsightsTrigger
    Scheduled run

    Scheduled daily — 8 AM local time

  2. 2
    TikTok
    Pulls

    Daily at 8 AM, the workflow pulls last 24 hours of posts from competitor Instagram and TikTok accounts via API, stores metrics in Google Sheets, compares engage

  3. 3
    Google Sheets
    Pulls

    Daily at 8 AM, the workflow pulls last 24 hours of posts from competitor Instagram and TikTok accounts via API, stores metrics in Google Sheets, compares engage

  4. 4
    Notion
    Process via Notion

    and emails a Notion-linked summary highlighting three content angles you should counter or adapt this week.

  5. 5
    Notion
    Workflow complete

    and emails a Notion-linked summary highlighting three content angles you should counter or adapt this week.

Apps used

Connected applications

Meta Insights

Pulls

TikTok

Pulls

Google Sheets

Pulls

Notion

Process via Notion

Summary

Automation summary

Trigger
Scheduled daily — 8 AM local time
Inputs
Scheduled daily — 8 AM local time, Business Name, Notification Email, Timezone
Outputs
and emails a Notion-linked summary highlighting three content angles you should counter or adapt this week., Google Sheets pulls, Notion process via Notion
Business goal
Automate competitor content tracker end-to-end with accurate app routing.
Execution frequency
Daily
Estimated runtime
30–90 seconds
Error handling
Failed steps retry up to 3 times with exponential backoff; persistent failures notify your configured channel and log to the run history.
Dependencies
Meta Insights, TikTok, Google Sheets
Benefits

Why use this automation?

Save ~8 hours/week

Remove repetitive steps from Competitor Content Tracker so your team focuses on high-value work.

Reduce manual work

Connected apps sync data automatically instead of copy-paste between dashboards.

Prevent human errors

Standardized logic runs the same way every time, with retries on failure.

Requirements

What you need to get started

Required apps

  • Meta Insights
  • TikTok
  • Google Sheets

Required accounts

  • Active Meta Insights workspace with API access
  • Active TikTok workspace with API access
  • Active Google Sheets workspace with API access
  • Shata Automation workspace (free tier supported)

Required API keys

  • OAuth tokens for each connected integration

Permissions

  • Read access on trigger sources (forms, sheets, webhooks, or CRM objects)
  • Write access on destination apps (email, chat, CRM, or storage)

Estimated setup time

  • 10 min including app authorization and test run
  • Difficulty: Beginner

Optional apps

  • Notion (optional)

Automation runtime

Activate this template

PartialSome steps run in preview until their integrations go live.

Connect required apps via OAuth or API keys. Credentials are encrypted server-side. Dev test runs mock external actions when connections are missing.

Draft
0%
Activation readiness

Est. setup time: ~11 min

Required connections

  • Meta (Facebook & Instagram)(required)
    PreviewMeta (Facebook & Instagram): workflow actions run in preview
    ⚠ Missing
  • tiktok(required)
    Previewtiktok: workflow actions run in preview
    ⚠ Missing
  • Google Sheets(required)
    ⚠ Missing
  • • Missing connection: Meta (Facebook & Instagram)
  • • Missing connection: tiktok
  • • Missing connection: Google Sheets
Manage all connections →View all installations →

Workflow summary

Trigger
Scheduled daily — 8 AM local time
Steps
5 nodes
Required apps
3
Optional apps
1

Trigger

Schedule trigger

Activate this workflow to provision the trigger endpoint.

Run history

No runs yet. Install the template and run a test, or activate to receive webhook/schedule runs.

FeaturedFreeBeginnerPartial10 min setup★3.87.2k installs · 402 reviews
Customize for My Business
Analytics

Template performance

29.8k
Views
7.2k
Installs
534
Favorites
3.8
Avg rating
24.1%
Conversion
10 min
Setup time
93%
Success rate
106
Trending score
Most used integrations
Meta (Facebook & Instagram)TikTokGoogle Sheets

Daily at 8 AM, the workflow pulls last 24 hours of posts from competitor Instagram and TikTok accounts via API, stores metrics in Google Sheets, compares engagement rate vs. their 30-day baseline, identifies top-performing format—carousel vs. reel—and emails a Notion-linked summary highlighting three content angles you should counter or adapt this week.

Some steps run in preview until their integrations go live.

Required apps
Meta (Facebook & Instagram)PreviewTikTokPreviewGoogle SheetsLive
Optional apps
NotionPreview
All integrations
Meta (Facebook & Instagram)TikTokGoogle SheetsNotion
Workflow preview

How Competitor Content Tracker runs

1
Trigger
Connect social APIs
2
Process
Rule engine
3
Action
meta-facebook-instagram
4
Notify
Alert & log
Meta Facebook InstagramTiktokGoogle SheetsNotion
Setup steps

Get started in 5 steps

  1. 1
    List competitor accounts

    Add Instagram and TikTok handles to Airtable with industry tag and priority tier.

  2. 2
    Connect social APIs

    Authorize Meta Graph API for competitor public data and TikTok research API where available.

  3. 3
    Define baseline window

    30-day rolling engagement rate per competitor for delta comparison.

  4. 4
    Configure digest format

    Email via Gmail API with top posts, format breakdown, and suggested response angles from GPT-4o.

  5. 5
    Validate first digest

    Confirm metrics match native analytics for sample posts manually.

Variables

Configurable settings

VariableTypeDefaultRequired
Business NametextYour BusinessYes
Notification Emailemail—Yes
Timezoneselect—Yes
Google Sheet IDtextNo
Sheet RangetextSheet1!A:ZNo
FAQ

Frequently asked questions

Private competitor accounts?

Only public post data accessible via API; private accounts cannot be tracked.

How many competitors?

Default cap 20 accounts per run to stay within API quotas.

Historical archive?

Sheets append daily; pivot charts show trend over time.

Content theft alerts?

Optional similarity check flags posts that closely match your recent captions.

Get started

Customize Competitor Content Tracker for your business

Our team can adapt this template to your exact workflow, apps, and brand requirements.

Request custom automation →Talk to an expert