Shata Solutions
← Back to marketplace
Social Media Automation

Newsletter from Posts

Compile top weekly social posts into an email newsletter draft with commentary and links.

Automation overview

What this automation does

This automation starts when scheduled weekly — Friday 4 PM local time. It linkedin pulls, x (twitter) pulls, openai pulls, klaviyo pulls, and gmail pulls, then friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X via native APIs, GPT-4o writes intro paragraph and per-post commentary, assemble.

Trigger
Scheduled weekly — Friday 4 PM local time
Main actions
LinkedIn pulls → X (Twitter) pulls …
Final outcome
Friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X …
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
Meta Insights
Scheduled run
Step 1
LinkedIn
Pulls
Step 2
X (Twitter)
Pulls
AI
OpenAI
Pulls
Step 4
Klaviyo
Pulls
Step 5
Gmail
Pulls
Result
Gmail
Workflow complete
Step-by-step

How each step runs

  1. 1
    Meta InsightsTrigger
    Scheduled run

    Scheduled weekly — Friday 4 PM local time

  2. 2
    LinkedIn
    Pulls

    Friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X via native APIs, GPT-4o writes intro paragraph and per-post commentary, assemble

  3. 3
    X (Twitter)
    Pulls

    Friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X via native APIs, GPT-4o writes intro paragraph and per-post commentary, assemble

  4. 4
    OpenAI
    Pulls

    Friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X via native APIs, GPT-4o writes intro paragraph and per-post commentary, assemble

  5. 5
    Klaviyo
    Pulls

    Friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X via native APIs, GPT-4o writes intro paragraph and per-post commentary, assemble

  6. 6
    Gmail
    Pulls

    Friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X via native APIs, GPT-4o writes intro paragraph and per-post commentary, assemble

  7. 7
    Gmail
    Workflow complete

    Friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X via native APIs, GPT-4o writes intro paragraph and per-post commentary, assemble

Apps used

Connected applications

Meta Insights

Pulls

LinkedIn

Pulls

X (Twitter)

Pulls

OpenAI

Pulls

Klaviyo

Pulls

Gmail

Pulls

Summary

Automation summary

Trigger
Scheduled weekly — Friday 4 PM local time
Inputs
Scheduled weekly — Friday 4 PM local time, Business Name, Notification Email, Timezone
Outputs
Friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X via native APIs, GPT-4o writes intro paragraph and per-post commentary, assemble, Klaviyo pulls, Gmail pulls
Business goal
Automate newsletter from posts 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
Meta Insights, LinkedIn, X (Twitter)
Benefits

Why use this automation?

Save ~13 hours/week

Remove repetitive steps from Newsletter from Posts 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

  • Meta Insights
  • LinkedIn
  • X (Twitter)

Required accounts

  • Active Meta Insights 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

  • OpenAI (optional)
  • Klaviyo (optional)
  • Gmail (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: ~13 min

Required connections

  • Meta (Facebook & Instagram)(required)
    PreviewMeta (Facebook & Instagram): workflow actions run in preview
    Missing
  • linkedin(required)
    Previewlinkedin: workflow actions run in preview
    Missing
  • x(required)
    Previewx: workflow actions run in preview
    Missing
  • OpenAI(required)
    Missing
  • Missing connection: Meta (Facebook & Instagram)
  • Missing connection: linkedin
  • Missing connection: x
  • Missing connection: OpenAI
Manage all connections →View all installations →

Workflow summary

Trigger
Scheduled weekly — Friday 4 PM 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 setup4.33.7k installs · 267 reviews
Customize for My Business
Analytics

Template performance

45.1k
Views
3.7k
Installs
251
Favorites
4.3
Avg rating
8.1%
Conversion
30 min
Setup time
94%
Success rate
68
Trending score
Most used integrations
Meta (Facebook & Instagram)LinkedInX (Twitter)

Friday 4 PM run pulls top 5 posts by engagement from Instagram, LinkedIn, and X via native APIs, GPT-4o writes intro paragraph and per-post commentary, assembles Mailchimp campaign draft with UTM-tagged links, embeds thumbnail images from CDN, and sends preview to editor Gmail before Monday morning schedule slot.

Some steps run in preview until their integrations go live.

Required apps
Meta (Facebook & Instagram)PreviewLinkedInPreviewX (Twitter)PreviewOpenAILive
Optional apps
MailchimpPreviewGmailLive
All integrations
Meta (Facebook & Instagram)LinkedInX (Twitter)OpenAIMailchimpGmail
Workflow preview

How Newsletter from Posts runs

1
Trigger
Define top post criteria
2
Process
Rule engine
3
Action
meta-facebook-instagram
4
Notify
Alert & log
Meta Facebook InstagramLinkedinXOpenaiMailchimpGmail
Setup steps

Get started in 5 steps

  1. 1
    Connect social analytics APIs

    Meta Insights, LinkedIn analytics, X analytics, OpenAI, Mailchimp, Gmail.

  2. 2
    Define top post criteria

    Rank by engagement rate not raw likes; exclude boosted ad posts if flagged.

  3. 3
    Configure newsletter template

    Mailchimp template ID with sections—intro, post grid, CTA footer.

  4. 4
    Set editor preview flow

    Preview email to editor list; require Mailchimp approve tag before Monday send.

  5. 5
    Run first weekly draft

    Verify five posts, images load, UTMs correct in preview.

Variables

Configurable settings

VariableTypeDefaultRequired
Business NametextYour BusinessYes
Notification EmailemailYes
TimezoneselectYes
Gmail Search Querytextis:unreadNo
FAQ

Frequently asked questions

Subscriber segmentation?

Optional branch—newsletter variant for customers vs. prospects from Mailchimp segments.

Missing platform data?

Newsletter proceeds with available platforms; section omitted if API fails.

Custom intro tone?

Editor style examples in Notion steer GPT commentary voice.

Auto-send without review?

Disable for first 8 weeks; enable after editor trust established.

Get started

Customize Newsletter from Posts for your business

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