Bilibili video downloader with Google Drive upload & email notification
Bilibili Video Downloader with Google Drive Upload & Email Notification Automate downloading of Bilibili videos via the Bilibili Video Downloader API (RapidAPI), upload them to Google Drive, and notify users by email — all using n8n workflow automation. --- 🧠 Workflow Overview This n8n automation allows users to: Submit a Bilibili video URL. Fetch download info from the Bilibili Video Downloader API (RapidAPI). Automatically download and upload the video to Google Drive. Share the file and send an email notification to the user. --- ⚙️ Node-by-Node Explanation | Node | Function | | ---------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | | On form submission | Triggers when a user submits the Bilibili video URL through the form. | | Fetch Bilibili Video Info from API | Sends the video URL to the Bilibili Video Downloader API (RapidAPI) to retrieve download info. | | Check API Response Status | Validates that the API returned a 200 success status before proceeding. | | Download Video File | Downloads the actual video from the provided resource URL. | | Upload Video to Google Drive | Uploads the downloaded video file to the user’s connected Google Drive. | | Google Drive Set Permission | Sets sharing permissions to make the uploaded video publicly accessible. | | Success Notification Email with Drive Link | Sends the Google Drive link to the user via email upon successful upload. | | Processing Delay | Adds a delay before executing error handling if something fails. | | Failure Notification Email | Sends an error notification to the user if download/upload fails. | --- 🧩 How to Configure Google Drive in n8n In n8n, open Credentials → New → Google Drive. Choose OAuth2 authentication. Follow the on-screen instructions to connect your Google account. Use the newly created credential in both Upload Video and Set Permission nodes. Test the connection to ensure access to your Drive. --- 🔑 How to Obtain Your RapidAPI Key To use the Bilibili Video Downloader API (RapidAPI): Visit bilibili videodownloade. Click Subscribe to Test (you can choose free or paid plans). Copy your x-rapidapi-key from the “Endpoints” section. Paste the key into your n8n Fetch Bilibili Video Info from API node header. Example header: json { "x-rapidapi-host": "bilibili-video-downloader.p.rapidapi.com", "x-rapidapi-key": "your-rapidapi-key-here" } --- 💡 Use Case This automation is ideal for: Content creators archiving Bilibili videos. Researchers collecting media resources. Teams that need centralized video storage in Google Drive. Automated content management workflows. --- 🚀 Benefits ✅ No manual downloads – fully automated. ✅ Secure cloud storage via Google Drive. ✅ Instant user notification on success or failure. ✅ Scalable for multiple users or URLs. ✅ Powered by the reliable Bilibili Video Downloader API (RapidAPI). --- 👥 Who Is This For n8n developers wanting to explore advanced workflow automations. Content managers handling large volumes of Bilibili content. Digital archivists storing video data in Google Drive. Educators sharing Bilibili educational videos securely. --- 🏁 Summary With this n8n workflow, you can seamlessly integrate the Bilibili Video Downloader API (RapidAPI) into your automation stack — enabling effortless video downloading, Google Drive uploading, and user notifications in one unified system.
By Sk developer Automate LinkedIn content using viral post analysis with Gemini AI & Flux image generation
LinkedIn Viral Post Scraper + AI Content Generator with Auto Publishing Who's it for Content creators, social media managers, marketing agencies, and LinkedIn growth hackers who want to automate their content strategy by analyzing viral posts and generating original, high-engagement content at scale. What it does This comprehensive automation pipeline combines LinkedIn data intelligence with AI-powered content creation to build a complete content marketing system: Data Collection Phase: Automatically scrapes high-engagement posts from target LinkedIn profiles Filters content based on viral metrics (20+ likes, comments, or reposts) Stores trending content data in Google Sheets for analysis Runs on a 12-hour schedule with built-in rate limiting Content Generation Phase: AI analyzes trending patterns and engagement triggers from collected data Generates original LinkedIn posts using Google Gemini's advanced language model Creates custom visuals using AI image generation (HuggingFace Flux model) Automatically publishes complete posts with images to your LinkedIn company page Tracks processed content to prevent duplicate analysis How it works The workflow operates in two connected phases. The scraping phase monitors specified LinkedIn profiles, collecting high-performing posts into a centralized database. When new viral content is detected, the AI analysis phase triggers automatically, identifying trending topics and creating original content that leverages proven engagement patterns while maintaining authenticity. Requirements APIs and Credentials: Google Sheets API (for data storage and profile management) Apify API key (for LinkedIn post scraping) Google Gemini API access (for content generation) HuggingFace API token (for image generation) LinkedIn API access (for publishing) Setup Prerequisites: Google Sheets document with LinkedIn profile URLs LinkedIn company page for publishing Self-hosted n8n instance (uses community nodes) How to set up Configure Data Sources: Create a Google Sheet with two tabs - one for target LinkedIn profile URLs and another for storing scraped data API Integration: Add all required API credentials to n8n credential manager Customize Filters: Adjust engagement thresholds (currently 20+ for each metric) based on your niche AI Prompt Tuning: Modify the content generation prompt to match your brand voice and industry focus Publishing Settings: Configure your LinkedIn organization ID and posting preferences Schedule Optimization: Set scraping frequency based on your content needs and API limits How to customize the workflow Content Targeting: Modify the profile list in Google Sheets to focus on specific industries, thought leaders, or competitors in your niche. Engagement Thresholds: Adjust the filter conditions to be more or less selective about which posts qualify as "viral" content. AI Voice Customization: Edit the comprehensive system prompt in the LinkedIn Content Strategy AI node to match your brand personality, industry terminology, and content style preferences. Visual Branding: Customize image generation prompts to include your brand colors, logo elements, or specific visual styles. Publishing Schedule: Modify the trigger frequency and add conditional logic to publish at optimal times for your audience. Data Retention: Add cleanup nodes to manage historical data and prevent Google Sheets from becoming unwieldy over time.
By Roshan Ramani