Automate Daily Instagram Stats Reporting to Mattermost
detail.loadingPreview
This n8n workflow automates the daily reporting of your Instagram statistics to your Mattermost channel. Get real-time updates on your follower count and post performance without manual intervention.
About This Workflow
Streamline your social media monitoring with this powerful n8n workflow. It's designed to fetch your Instagram statistics daily and deliver them directly to your Mattermost workspace. The workflow begins by triggering at a set time each morning (8 AM by default). It then captures the current date and day of the week, formats it for easy reading, and pulls your Instagram account's follower count and the number of posts from a Google Sheet. Finally, it compiles this information into a concise, readable message and sends it to a specified Mattermost channel, keeping your team informed and engaged with your social media performance.
Key Features
- Scheduled Reporting: Automatically sends Instagram stats every day at a predetermined time.
- Data Integration: Pulls data directly from a Google Sheet.
- Real-time Notifications: Delivers updates to your team via Mattermost.
- Customizable Messaging: Easily adapt the message content and formatting.
- Dynamic Date Formatting: Includes the current day and date in a user-friendly format.
How To Use
- Set up Cron Trigger: Configure the 'Cron' node to set the desired daily trigger time (e.g., 8 AM).
- Get Current Date: The 'Get the date today' node will automatically capture the current date and day of the week.
- Format Date: Use the 'Date & Time' node to format the date into your preferred display (e.g., DD-MM-YYYY).
- Connect Google Sheets: Configure the 'Read data on Google Sheets' node with your Sheet ID and the range containing your Instagram data (e.g., follower count, number of posts). Ensure proper OAuth2 authentication is set up.
- Configure Mattermost: Set up the 'Mattermost' node with your Mattermost API credentials and the target channel ID. Customize the message content using expressions that reference the data from your Google Sheet and the date nodes. Ensure your Google Sheet node outputs JSON fields named 'Compte' and 'Followers', and 'Posts' for the Mattermost node to utilize.
Apps Used
Workflow JSON
{
"id": "74120224-6841-4dfa-8d1e-86ce7f1a6d0e",
"name": "Automate Daily Instagram Stats Reporting to Mattermost",
"nodes": 25,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 74120224-6841...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.