Social Media Stats Aggregator

Stop logging into five different dashboards. This workflow runs every 24 hours and pulls key performance indicators (KPIs) from your various social media accounts using their respective APIs. It then appends a new row to an Airtable base, allowing you to track growth trends over time in one place.

#Analytics

#Airtable

#Reporting

#Social Media

#Dashboard

Automation Logic

n8n JSON Blueprint

This workflow is pre-configured and ready for deployment. Simply import the JSON template into your n8n instance and configure your credentials.

This is an exclusive blueprint. Copy the JSON below to use it.

QUICK DEPLOY

1
Download the .json file
2
Open n8n & click "Import"
3
Configure your API keys

PRO TIP

Always test your workflow in a development environment before pushing to production.

JSON BLUEPRINT

n8n-workflow.json

{
  "nodes": [
    {
      "parameters": {
        "hour": 23
      },
      "name": "Daily Update",
      "type": "n8n-nodes-base.cron",
      "typeVersion": 1,
      "position": [250, 300]
    },
    {
      "parameters": {
        "resource": "user",
        "operation": "get"
      },
      "name": "Get Twitter Stats",
      "type": "n8n-nodes-base.twitter",
      "typeVersion": 1,
      "position": [450, 200]
    },
    {
      "parameters": {
        "resource": "channel",
        "operation": "get"
      },
      "name": "Get YouTube Stats",
      "type": "n8n-nodes-base.youtube",
      "typeVersion": 1,
      "position": [450, 400]
    },
    {
      "parameters": {
        "operation": "append",
        "baseId": "YOUR_AIRTABLE_BASE_ID",
        "table": "Engagement",
        "columns": {
          "mappingMode": "defineBelow",
          "value": [
            {
              "column": "Date",
              "value": "={{$now}}"
            },
            {
              "column": "Twitter Followers",
              "value": "={{$node[\"Get Twitter Stats\"].json[\"followers_count\"]}}"
            },
            {
              "column": "YouTube Subs",
              "value": "={{$node[\"Get YouTube Stats\"].json[\"subscriberCount\"]}}"
            }
          ]
        }
      },
      "name": "Save to Airtable",
      "type": "n8n-nodes-base.airtable",
      "typeVersion": 1,
      "position": [700, 300]
    }
  ],
  "connections": {
    "Daily Update": {
      "main": [
        [{"node": "Get Twitter Stats", "type": "main", "index": 0}],
        [{"node": "Get YouTube Stats", "type": "main", "index": 0}]
      ]
    },
    "Get Twitter Stats": {
      "main": [[{"node": "Save to Airtable", "type": "main", "index": 0}]]
    },
    "Get YouTube Stats": {
      "main": [[{"node": "Save to Airtable", "type": "main", "index": 0}]]
    }
  }
}

To use this, copy the JSON above and paste it directly onto your n8n canvas.

IMPLEMENTATION GUIDE

Required Nodes

Analytics Node
Airtable Node
Reporting Node
Social Media Node
Dashboard Node
Cron / Webhook Trigger

Core Benefits

100% Automated Execution
Reduces Manual Data Entry
Infinite Scalability

Need Help Building Your Private Cloud?

Join the elite marketers who have offloaded their entire backend to n8n. Get direct support and custom builds in our private forum.

EXPLORE PREMIUM PLANS PRIVATE FORUM