Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato
Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato > ⚠️ Disclaimer: This workflow uses Community Nodes and must be run on a self-hosted instance of n8n. Who is this for? This template is perfect for social media managers, content creators, AI enthusiasts, and automation pros who want to generate short-form videos (Reels) from a simple Telegram message, then publish them across multiple platforms—all without video editing or manual uploads. What problem is this workflow solving? Creating content is only half the job. The real bottleneck comes in: Rendering the video, Adding voice or music, Writing captions and titles, Publishing to multiple platforms. This workflow automates all of that using AI. It saves hours every week and guarantees consistent output. What this workflow does This end-to-end automation handles everything from AI video generation to social publishing: Starts with a Telegram message (text or image prompt) Generates video using Kling or Blotato, based on the input Creates music with Piapi and merges it with the video Generates text overlays and captions with GPT-4 Builds a stylized video using JSON2Video Logs results to Google Sheets Sends final output back to Telegram Auto-posts the video to 9 platforms via Blotato (Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Twitter/X, Pinterest, Bluesky) Setup Connect your Telegram bot to the trigger node. Add your OpenAI API key for all GPT nodes. Set up Kling and Piapi API access (for video and music generation). Connect your Cloudinary account to upload images. Link a Google Sheet with columns: Title, Caption, URL. Set your Blotato API key and fill in the platform-specific account IDs. How to customize this workflow to your needs Change prompt formatting to control GPT responses and video tone. Edit text styling in JSON2Video to match your brand. Add a Telegram approval step before publishing, if needed. Disable platforms you don’t use by deleting their HTTP Request nodes. Use a Google Sheet filter to only process new rows or drafts. 📄 Documentation: Notion Guide
By Dr. FirasDaily stock market report with Twelve Data API sent via WhatsApp and email
This workflow automates the generation of a daily stock market report, identifying the top gainers and losers among the top 100 stocks. It fetches real-time stock data, processes it to highlight significant price movements, and delivers formatted alerts via WhatsApp and email. Quick Notes Ensure the Twelve Data API key and stock symbols are correctly configured. Verify recipient lists for WhatsApp and email alerts are up-to-date. Confirm the workflow triggers at 5:00 PM (IST) from Monday to Friday. Process Flow Trigger the workflow daily at 5:00 PM (IST) with the Daily Market Change Trigger node. Configure API key, stock symbols, and alert recipients using the Configuration Variables node. Fetch stock data from Twelve Data API with the Fetch Stock Data from Twelve Data node. Process stock data to identify top gainers and losers with the Process Stock Movements node. Format WhatsApp messages with the Format WhatsApp Message node. Send WhatsApp alerts with the Send WhatsApp Alert node. Format email content with the Format Email Content node. Send email alerts with the Send Email Alert node. Output Getting Started Import the workflow into n8n and configure Twelve Data API credentials. Set up WhatsApp and email service integrations. Run a test execution to ensure data fetching and alert delivery work as expected. Tailored Adjustments Adjust the Process Stock Movements node to change the number of top gainers/losers. Modify the Configuration Variables node to include additional stock symbols or recipient lists.
By Oneclick AI SquadEmail reports on expiring Microsoft Entra ID app secrets and certificates with Microsoft Graph
Monitor expiring EntraID application secrets and notify responsible Stay ahead of credential expirations by automatically detecting Entra ID application client secrets and certificates that are about to expire, and sending a neatly formatted email report. What this workflow solves Expired client secrets and certificates are a common cause of unexpected outages and failed integrations. Manually checking expiration dates across many Entra ID applications is tedious and easy to miss. This workflow automates the discovery and reporting of credentials that will expire within a configurable time window. Key features Fetches all Microsoft Entra ID applications along with: Client secrets (passwordCredentials) Certificates (keyCredentials) Splits credentials into individual entries for easier processing Filters credentials expiring within the next N days (configurable) Normalizes results into a consistent structure including: Application name App ID Credential type (Client Secret / Certificate) Credential name + ID Days remaining until expiration Generates an HTML table report, sorted by application name Sends an email only when expiring items are found (otherwise does nothing) How it works Fetches all Entra ID applications and their credential metadata via Microsoft Graph Separates client secrets and certificates into individual entries Filters entries that expire within the configured time window Builds a normalized list of expiring items with days remaining Emails an HTML table report (only if results exist) Setup requirements Microsoft Entra ID app registration with Microsoft Graph Application permissions: Application.Read.All In n8n: Create Microsoft Graph OAuth2 credentials (Client Credentials flow recommended) Assign those credentials to the Get EntraID Applications and Secrets HTTP Request node Update the Set Variables node: notificationEmail: where to send the report daysBeforeExpiry: alert window in days (e.g., 14) Notes The email table highlights soon-to-expire credentials more prominently (based on remaining days). For automation, replace the manual trigger with a Schedule Trigger (e.g., daily/weekly). The workflow accesses metadata only (names/IDs/expiry), not secret values.
By Alexander Schnabl