Shata Solutions
← Back to marketplace
Social Media Automation

Weekly Analytics Report

Deliver a PDF and Slack summary of cross-platform metrics, growth deltas, and next-week recommendations.

Automation overview

What this automation does

This automation starts when scheduled weekly — Monday 7 AM local time. It linkedin posts, x (twitter) posts, google sheets posts, openai posts, and slack posts, then monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spend efficiency from Meta, TikTok, LinkedIn, X, and Sprout Social into Google Sheet.

Trigger
Scheduled weekly — Monday 7 AM local time
Main actions
LinkedIn posts → X (Twitter) posts …
Final outcome
Monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spen…
Execution time
1–3 minutes
Apps used
6 integrations
AI-powered
No
Difficulty
Advanced
Advanced
Workflow diagram

End-to-end scenario flow

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

Trigger
TikTok
Scheduled run
Step 1
LinkedIn
Posts
Step 2
X (Twitter)
Posts
Step 3
Google Sheets
Posts
AI
OpenAI
Posts
Step 5
Slack
Posts
Result
Slack
Workflow complete
Step-by-step

How each step runs

  1. 1
    TikTokTrigger
    Scheduled run

    Scheduled weekly — Monday 7 AM local time

  2. 2
    LinkedIn
    Posts

    Monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spend efficiency from Meta, TikTok, LinkedIn, X, and Sprout Social into Google Sheet

  3. 3
    X (Twitter)
    Posts

    Monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spend efficiency from Meta, TikTok, LinkedIn, X, and Sprout Social into Google Sheet

  4. 4
    Google Sheets
    Posts

    Monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spend efficiency from Meta, TikTok, LinkedIn, X, and Sprout Social into Google Sheet

  5. 5
    OpenAI
    Posts

    Monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spend efficiency from Meta, TikTok, LinkedIn, X, and Sprout Social into Google Sheet

  6. 6
    Slack
    Posts

    Monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spend efficiency from Meta, TikTok, LinkedIn, X, and Sprout Social into Google Sheet

  7. 7
    Slack
    Workflow complete

    Monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spend efficiency from Meta, TikTok, LinkedIn, X, and Sprout Social into Google Sheet

Apps used

Connected applications

TikTok

Posts

LinkedIn

Posts

X (Twitter)

Posts

Google Sheets

Posts

OpenAI

Posts

Slack

Posts

Summary

Automation summary

Trigger
Scheduled weekly — Monday 7 AM local time
Inputs
Scheduled weekly — Monday 7 AM local time, Business Name, Notification Email, Timezone
Outputs
Monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spend efficiency from Meta, TikTok, LinkedIn, X, and Sprout Social into Google Sheet, OpenAI posts, Slack posts
Business goal
Automate weekly analytics report end-to-end with accurate app routing.
Execution frequency
Weekly
Estimated runtime
1–3 minutes
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
TikTok, LinkedIn, X (Twitter)
Benefits

Why use this automation?

Save ~11 hours/week

Remove repetitive steps from Weekly Analytics Report 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.

Faster response times

Events trigger immediate actions instead of waiting for someone to check a queue.

Requirements

What you need to get started

Required apps

  • TikTok
  • LinkedIn
  • X (Twitter)

Required accounts

  • Active TikTok workspace with API access
  • Active LinkedIn workspace with API access
  • Active X (Twitter) 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

  • 30 min including app authorization and test run
  • Difficulty: Advanced

Optional apps

  • Google Sheets (optional)
  • OpenAI (optional)
  • Slack (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: ~12 min

Required connections

  • tiktok(required)
    Previewtiktok: workflow actions run in preview
    ⚠ Missing
  • linkedin(required)
    Previewlinkedin: workflow actions run in preview
    ⚠ Missing
  • x(required)
    Previewx: workflow actions run in preview
    ⚠ Missing
  • Google Sheets(required)
    ⚠ Missing
  • • Missing connection: tiktok
  • • Missing connection: linkedin
  • • Missing connection: x
  • • Missing connection: Google Sheets
Manage all connections →View all installations →

Workflow summary

Trigger
Scheduled weekly — Monday 7 AM local time
Steps
7 nodes
Required apps
4
Optional apps
2

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.

FreeAdvancedPartial30 min setup★4.33.3k installs · 431 reviews
Customize for My Business
Analytics

Template performance

20.0k
Views
3.3k
Installs
733
Favorites
4.3
Avg rating
16.6%
Conversion
30 min
Setup time
94%
Success rate
84
Trending score
Most used integrations
TikTokLinkedInX (Twitter)

Monday 7 AM aggregates followers, reach, engagement rate, top posts, and ad spend efficiency from Meta, TikTok, LinkedIn, X, and Sprout Social into Google Sheets pivot; GPT-4o writes executive summary with three actionable recommendations; Google Slides PDF exports to Drive and links post to Slack #social-metrics with week-over-week delta highlights.

Some steps run in preview until their integrations go live.

Required apps
TikTokPreviewLinkedInPreviewX (Twitter)PreviewGoogle SheetsLive
Optional apps
OpenAILiveSlackLive
All integrations
TikTokLinkedInX (Twitter)Google SheetsOpenAISlack
Workflow preview

How Weekly Analytics Report runs

1
Trigger
Build metric normalization
2
Process
Rule engine
3
Action
tiktok
4
Notify
Alert & log
TiktokLinkedinXGoogle SheetsOpenaiSlack
Setup steps

Get started in 5 steps

  1. 1
    Connect analytics sources

    Meta Insights, TikTok Analytics, LinkedIn, X, Sprout Social, Google Sheets, Slides, Slack.

  2. 2
    Build metric normalization

    Common schema—reach, ER, followers, clicks—across platforms in Sheets.

  3. 3
    Configure comparison windows

    Week vs. previous week and vs. same week last year toggles.

  4. 4
    Set recommendation prompt

    Feed GPT top/bottom posts and campaign calendar for contextual advice.

  5. 5
    Validate first PDF

    Cross-check PDF numbers against native dashboards for one platform.

Variables

Configurable settings

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

Frequently asked questions

Client-facing white label?

Slides template swap for agency logo and client name per Airtable account row.

Ad spend included?

Meta and TikTok ads API optional module adds ROAS section.

Custom metrics?

Add columns to Sheets schema—save rate, DM count—and they appear in report.

Distribution list?

Email PDF via Gmail to stakeholder list beyond Slack link.

Get started

Customize Weekly Analytics Report for your business

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

Request custom automation →Talk to an expert