Auto-caption videos for Instagram/TikTok with Google Drive and Submagic
🎥 Auto-Caption Videos for Instagram with Google Drive + Submagic Description Save hours on video editing with this workflow! Whenever you upload a video to a specific Google Drive folder, it’s automatically sent to Submagic to generate engaging captions (using your chosen template). Once the captioned video is ready, it’s pulled back, downloaded, and uploaded into your Google Drive—fully captioned and Instagram-ready. Watch build along videos for workflows like these on: www.youtube.com/@automatewithmarc How It Works Google Drive Trigger – Listens for new video uploads in your chosen folder. Post to Submagic – Sends the video URL to Submagic’s API with your caption style (e.g. Hormozi). Wait Loop + Status Check – Polls Submagic until the captioning job is complete. Download Captioned Video – Retrieves the finished captioned video file. Upload to Google Drive – Saves the captioned version back into Drive, ready for Instagram posting. Why You’ll Love It 🎯 Zero manual steps — captioning happens automatically. ⚡ Faster IG content pipeline — ready-to-post reels in minutes. 🎨 Consistent style — apply your favorite Submagic caption templates every time. ☁️ Cloud-first — works entirely with Google Drive + Submagic, no local processing needed. Requirements Google Drive account (with OAuth credentials) Submagic API key n8n (Cloud or self-hosted)
By Automate With MarcTrack website SEO metrics with Moz API and Google Sheets integration
Automated DA PA Checker Workflow for SEO Analysis Description This n8n workflow collects a website URL via form submission, retrieves SEO metrics like Domain Authority (DA) and Page Authority (PA) using the Moz DA PA Checker API, and stores the results in Google Sheets for easy tracking and analysis. --- Node-by-Node Explanation On form submission – Captures the website input from the user to pass to the Moz DA PA Checker API. DA PA API Request – Sends the website to the Moz DA PA Checker API via RapidAPI to fetch DA, PA, spam score, DR, and organic traffic. If – Checks if the API request to the Moz DA PA Checker API returned a successful response. Clean Output – Extracts only the useful data from the Moz DA PA Checker API response for saving. Google Sheets – Appends the cleaned SEO metrics to a Google Sheet for record-keeping. --- Use Cases SEO Analysis – Quickly evaluate a website’s DA/PA metrics for optimization strategies. Competitor Research – Compare domain authority and organic traffic with competitors. Link Building – Identify high-authority domains for guest posting and backlinks. Domain Purchase Decisions – Check metrics before buying expired or auctioned domains. --- Benefits Automated Workflow – From input to Google Sheets without manual intervention. Accurate Metrics – Uses the trusted Moz DA PA Checker API for DA, PA, spam score, DR, and traffic. Instant Insights – Get SEO scores in seconds for faster decision-making. Easy Integration – Seamless connection between RapidAPI and Google Sheets for data storage.
By Sk developer Generate structured article summaries with Telegram, Claude AI & Jina Reader
Article summarizer bot Send any URL to your Telegram bot and get an AI summary instantly. What it does Receives URLs via Telegram Fetches clean article content (removes ads, navbars) Generates AI summary Sends formatted summary back to Telegram How to set up Create Telegram bot Message @BotFather on Telegram Run /newbot and follow prompts Copy your bot token Add credentials to n8n Get API keys (optional but recommended) Jina AI: Sign up at jina.ai/reader Add keys to nodes Configure AI model and output parser format Requirements Telegram bot token OpenRouter API key or any other LLM you have How to customize Change summary format: Edit prompt in "Summarize Article" node Update Output Parser schema (title, tags, etc) Save to database: Enable Google Sheets node or add Notion/Airtable Different language: Modify prompt to force specific language
By DahianaMonitor SSL certificate expiry with Google Sheets and SMTP email alerts
Who is this for? DevOps engineers, sysadmins, and website owners who manage multiple domains and need proactive SSL certificate expiration monitoring without manual checks. What it does Automatically monitors SSL certificates across multiple domains, tracks expiration status in a Google Sheet dashboard, and sends beautifully formatted HTML email alerts before certificates expire. ✅ No API rate limits — Uses direct OpenSSL commands, so you can scan unlimited domains with zero API costs or restrictions. How it works Triggers on schedule (every 3 days at 10AM) Reads domain list from your Google Sheet Checks each domain's SSL certificate using OpenSSL commands Parses expiration dates, issuer info, and calculates days remaining Updates Google Sheet with current status for all domains Sends styled email alerts only when certificates are expiring soon Set up steps Connect your Google Sheets OAuth2 credentials Create a Google Sheet with these columns: Domain, Expiry Date, Days Left, Status, Issuer, Last Checked (the workflow matches on the Domain column to update results) Add your domains to scan in the Domain column Update the Sheet ID in the Read Domain List from Google Sheets and Update Google Sheet with Results nodes Connect SMTP credentials in the Send Alert Email via SMTP node Optionally adjust ALERTTHRESHOLDDAYS in two nodes: Prepare Domain List and Set Threshold and Parse SSL Results and Identify Expiring Certs (default: 20 days) Setup time: ~10 minutes
By M Ayoub