Track Social Media Growth and Weekly Reports with X API, YouTube API, and Gmail

Monitor and record your personal or competitors’ social media growth with this scalable n8n automation template.
Using official APIs from X (formerly Twitter) and YouTube, the workflow fetches daily follower and subscriber counts, stores them in a structured n8n Data Table, and now sends automated weekly summary emails via Gmail.

Built with extensibility in mind, this workflow is ready for future updates to support additional platforms like Instagram, TikTok, LinkedIn, and more.

Features

📈 Daily Social Media Tracking
Automatically collects X follower counts and YouTube subscriber numbers based on usernames, not channel IDs.

📦 Data Table Logging
Cleanly stores daily metrics in a dedicated n8n Data Table with timestamps.

📧 Weekly Email Reports (New)
Sends a concise weekly summary of growth trends using the Gmail node.

🔁 Easy Customization
Swap out usernames in a couple of fields — no deep edits required.

🛠️ Extensible Design
Structure is ready to support more platforms (e.g., TikTok, Instagram, LinkedIn).

🧩 API-Based Accuracy
Uses official APIs from X and YouTube for real-time, reliable data.

Setup Instructions

1. Get API Credentials

X API (Bearer Token)** → developer.x.com
YouTube API Key** → Google Cloud Console
Gmail Credentials* → Enable the Gmail API* in your Google Cloud project and configure OAuth2 credentials for use in n8n.

2. Configure in n8n

Import the template
In the HTTP Request nodes: Add Bearer Auth (for X API)
Add Query Auth with your YouTube API Key (?key=<your_api_key>)
In the Gmail node: Connect your Gmail account via OAuth2 credentials
Customize recipient email(s) and message format
Edit these fields to track your accounts: xUsername → your X / Twitter handle
ytChannelUsername → your YouTube channel’s username

3. Create the Data Table

Inside the n8n dashboard, create a table with the following fields:

| Field Name | Type | | ------------------- | -------- | | date | DateTime | | xFollowersCount | Number | | ytSubscriberCount | Number |

How It Works

Trigger: Daily cron node starts the workflow.
Fetch X Followers: Grabs follower count using the X API.
Fetch YouTube Subscribers: Retrieves sub count using the YouTube API.
Store Data: Logs all values into your Data Table with a timestamp.
Weekly Email Summary: Once a week, the Gmail node compiles recent data and emails a growth report.
Future Expansion: The structure is ready to include more platforms.

Use Cases

Track your brand or competitor’s social growth daily
Receive weekly email reports on follower/subscriber changes
Build custom dashboards or growth charts
Compare performance across platforms
Generate automated growth reports

Requirements

X API Bearer Token
YouTube API Key
Gmail API Credentials
Access to n8n (cloud or self-hosted)

Delivery Options

You can extend this template to:

Post daily growth summaries to Slack or Telegram
Auto-update a Google Sheet or Notion database
Send more detailed weekly reports
Add new platforms (Instagram, TikTok, LinkedIn, etc.)

Details

| Node | Function | | ------------ | ----------------------------------- | | HTTP Request | Pull data from APIs | | Cron | Trigger workflow daily | | Data Table | Store historical growth data | | Gmail | Send weekly email reports | | Set | Define usernames and settings |