Joseph
Automation expert specializing in building smart, scalable workflows using tools like n8n, Make, and Airtable. I help businesses save time, reduce manual work, and grow faster with tailored automation solutions. Feel free to reach out at joseph@uppfy.com to discuss your project. I am also on x.com/juppfy
Categories
Templates by Joseph
Generate & enrich LinkedIn leads with Apollo.io, LinkedIn API, Mail.so & GPT-3.5
Note: Now includes an Apify alternative for Rapid API (Some users can't create new accounts on Rapid API, so I have added an alternative for you. But immediately you are able to get access to Rapid API, please use that option, it returns more detailed data). Scroll to bottom for APify setup guide This n8n workflow automates LinkedIn lead generation, enrichment, and activity analysis using Apollo.io, RapidAPI, Google Sheets and Mail.so. Perfect for sales teams, founders, B2B marketers, and cold outreach pros who want personalized lead insights to drive better conversion rates. --- ⚙️ How This Workflow Works The workflow is broken down into several key steps, each designed to help you build and enrich a valuable list of LinkedIn leads: 🔑 Lead Discovery (Keyword Search via Apollo) Pulls leads using Apollo.io's API based on keywords, industries, or job titles. Saves lead name, title, company, and LinkedIn URL to your Google Sheet. You can replace the trigger node from the form node to a webhook, whatsapp, telegram, etc, any way for you to send over your query variables over to initiate the workflow. 🧠 Username Extraction (from LinkedIn URL) Extracts the LinkedIn username from profile URLs using a simple script node. This is required for further enrichment via RapidAPI. ✉️ Email Lookup (via Apollo User ID) Uses the Apollo User ID to retrieve the lead’s verified work email. Ensures high-quality leads with reliable contact info. To double check that the email is currently valid, we use the mail.so api and filter out emails that fail deliverability and mx-record check. We don't wanna risk sending emails to no longer existent addresses, right? 🧾 Profile Summary Enrichment (via RapidAPI) Queries the LinkedIn Data API to fetch a lead’s profile summary/bio. Gives you a deeper understanding of their background and expertise. 📰 Recent Activity Collection (Posts & Reposts) Retrieves recent posts or reposts from each lead’s profile. Great for tailoring outreach with reference to what they’re currently talking about. 🗂️ Leads Database Update All enriched data is written to the same Google Sheet. New columns are filled in without overwriting existing data. --- ✅ Smart Retry & Row Status Logic Every subworkflow includes a fail-safe mechanism to ensure: ✅ Each row has status columns (e.g., done, failed, pending). 🕒 A scheduled retry workflow resets failed rows to pending after 2 weeks (customizable). 💬 This gives failed enrichments another chance to be processed later, reducing data loss. --- 📋 Google Sheets Setup Template 1: Apollo Leads Scraping & Enrichment Template 2: Enriched Leads Database Make a copy to your Drive and use. Columns will be filled as each subworkflow runs (email, summary, interests, etc.) --- 🔐 Required API Keys To use this workflow, you’ll need the following credentials: 🧩 Apollo.io Sign up and get your key here: Apollo.io API Keys ⚠️ Important: Toggle the “Master API Key” option to ON when generating your key. This ensures the same key can be used for all Apollo endpoints in this workflow. 🌐 RapidAPI (LinkedIn Data API) Subscribe to the API here: LinkedIn Data API on RapidAPI Use the key in the x-rapidapi-key header in the relevant nodes. ✉️ Mail.so Sign up and get your key here: Mail.so API > 💡 For both APIs, set up the credentials in n8n as “Generic Credential” types. This way, you won’t need to reconfigure the headers in each node. --- 🛠️ Customization Options Modify the Apollo filters (location, industry, seniority) to target your ideal customers. Change retry interval in the scheduler (e.g., weekly instead of 2 weeks). Connect the database to your email campaign tool like Mailchimp or Instantly.ai. Replace the AI nodes with your desired AI agents and customize the system messages further to get desired results. --- 🆕 Apify Update Guide To use this workflow, you’ll need the following credentials: Login to Apify, then open this link; https://console.apify.com/actors/2SyF0bVxmgGr8IVCZ/ Click on integrations and scroll down to API Solutions and select "Use API endpoints". Scroll to "Run Actor synchronously and get dataset items" and copy the actor endpoint url then paste it in the placeholder inside the http node of Apify alternative flow "apify-actor-endpoint". That's it, you are set to go. --- I am available for custom n8n workflows, if you like my work, please get in touch with me on email at joseph@uppfy.com
By JosephGenerate images and convert to video using Flux, Kraken & Runway
(Image Generation → Hosting → Video Generation) This workflow is designed for creators, automation enthusiasts, and indie hackers who want to generate image-based videos automatically using AI tools — at a low cost. --- ⚙️ Workflow Overview This automation performs the following steps: Trigger (Schedule or manual) Generate an image using Flux (choose between two APIs) Upload the image to Kraken.io to get a public URL Send the image to Runway ML (choose between two APIs) to generate a video Receive the video as a URL — ready for posting, download, or further automation --- 🛠️ Step-by-Step Setup 🖼️ Flux (Image Generation) You can use either of the following providers: Option 1: Flux by BlackForest Labs (Direct API) 🔑 Get your API key here: https://docs.bfl.ml/ Paste your API key in the HTTP Request node named Flux (Blackforest) You can customize prompts or styles inside the JSON body Option 2: Flux via RapidAPI 🔑 Subscribe and get your key here: https://rapidapi.com/poorav925/api/ai-text-to-image-generator-flux-free-api/playground/apiendpoint\_e38039ee-1912-4ef9-b4d4-270d72fca851 Enter your RapidAPI key in the X-RapidAPI-Key header Optional: tweak prompts, style, or resolution inside the JSON body --- 🐙 Kraken.io (Hosting the Image Publicly) Runway ML requires the image to be publicly accessible. We use Kraken.io to host the generated image and return a public URL. 🔑 Get your API credentials: https://kraken.io/account/api-credentials Setup: Copy your API Key and API Secret Open the Kraken Upload node in n8n Replace placeholders with your credentials The node uploads your image and gives back a public image URL for Runway to use --- 🎬 RunwayML (Video Generation) You also have two options here: Option 1: Runway Official API 🔑 Get your credentials at: https://dev.runwayml.com/ Use the public image URL from Kraken in the JSON body Paste your Bearer token in the Authorization header Customize other settings like video length, style, FPS, etc. Option 2: Runway via RapidAPI 🔑 Subscribe and get your key here: https://rapidapi.com/fortunehoppers/api/runwayml/playground/apiendpoint\_93c8554d-8097-40cd-8252-3d4dec9c0e68 Paste your RapidAPI key in the request header Customize prompt and generation options in the body Use the Kraken-generated image URL as the input source --- 📤 What to Do with the Video Once the video is generated, you’ll get a direct video URL. You can: Save it to Google Sheets or Notion Send it via email Trigger a YouTube upload automation Or download manually for editing and reposting --- 💡 Optional Tips & Notes You can schedule this workflow to generate AI videos daily or weekly Combine it with a Google Sheet of prompts for bulk automation Try using a consistent visual style or theme for better branding This workflow is lightweight and affordable — perfect for indie projects or experimental content generation Great for shorts, quote visuals, music loops, AI art promos, etc. --- 🔗 Resources Flux (Blackforest) Docs Flux on RapidAPI RunwayML Official Docs Runway on RapidAPI Kraken.io API Dashboard --- 🙋 Need Help? Feel free to reach out: 🐦 Twitter: @juppfy 📧 Email: joseph@uppfy.com If you’d like to hire me for custom n8n workflows or product automations, don’t hesitate to get in touch.
By JosephTrack SEO keyword position in Google SERP (Google Sheets + SerpAPI integration)
This n8n workflow automates scheduled checks for your target keywords’ positions in Google’s organic search results using SerpAPI. It logs new positions in Google Sheets, compares them to previous rankings, and sends notifications via WhatsApp and/or email based on the movement. --- Problem Statement & Target Audience Who is this for? This workflow is ideal for: SEO specialists monitoring keyword rankings. Website owners tracking performance. Agencies managing multiple client campaigns. It helps reduce manual effort by automatically checking rankings on a schedule and sending notifications only when there’s movement in position. --- Pre-conditions & API Requirements APIs & Services Used SerpAPI – Fetch Google search results Get API Key: https://serpapi.com/manage-api-key Docs for usage: SerpAPI Search API Note: Use Generic credential type in n8n for this to work with the preset configuration. Google Sheets API – To store and update keyword data Email API – To notify users of position changes WhatsApp API (e.g., Twilio, Ultramsg) – To send notifications > Setup help for Google Sheets, Email, and WhatsApp is available via the Docs tab in each respective node in n8n. --- Step-by-Step Workflow Explanation 🗓 1. Scheduled Trigger (Support Workflow) Marks all rows in the sheet as "notchecked" in the checkstatus column. This is the user-defined frequency trigger (e.g. weekly, daily). Triggers the main workflow. 🚀 2. Main Workflow Trigger Starts when a row with checkstatus = notchecked is found. 🔍 3. HTTP Node (SerpAPI Call) Sends a request to SerpAPI for each keyword. Fetches the current Google SERP for that keyword. 🧠 4. JavaScript Node (Parse Position) Loops through the SERP results and finds the position of the target URL. Extracts and returns the current rank. ✍️ 5. Google Sheets Node (Update Data) Writes the new ranking into the spreadsheet. Updates the currentposition and sets checkstatus to "checked". 🔀 6. Switch Node (Compare Rankings) Compares previousposition with currentposition: If rank has improved → send positive alert. If rank has dropped → send negative alert. If unchanged → no alert. 📩 7. Notification Nodes (WhatsApp / Email) Sends a message to chosen channels when a change is detected. --- Customization Guide ⏱️ Change Frequency Adjust the supporting schedule workflow to change how often the tracker runs. ✉️ Edit Notification Content Customize the WhatsApp and Email message content in their respective nodes. 🔗 Track Multiple URLs per Keyword (Advanced) Extend the JavaScript logic if you need to monitor several pages for the same keyword. 🌐 Expand Search Engine Targets SerpAPI also supports other search engines like Bing and Yahoo. Modify the request params to switch. --- How to Set Up This Workflow ✅ Step 1: Use This Google Sheets Template To get started quickly, make a copy of the template below: 👉 Google Sheets Template This template includes the required structure: keyword Website_url position timestamp checkstatus > ⚠️ Be sure to make your own copy to edit and connect via the Google Sheets node. --- 🔐 Step 2: Configure Your APIs SerpAPI: Get API key from serpapi.com/manage-api-key Set credential type to Generic in n8n for compatibility. Google Sheets, Email & WhatsApp: Use the instructions found in each node’s Docs tab to connect your accounts. --- 📦 Step 3: Import the Workflow Both the main keyword tracking workflow and the supporting scheduler workflow are in one file --- ▶️ Step 4: The workflow will start Since the check status columns will be 'notChecked' schedule workflow. The update sheets node will update each processed row's checkstatus to 'checked' and the workflow will process the next row the schedule trigger workflow will update checkstatus = notchecked and triggers the keyword tracking automatically. --- 🎉 Done! From now on, your keyword positions will be monitored at the frequency you set. You’ll receive WhatsApp and/or email updates only when rankings change. in case you need customized workflows or wanna reach out here is my twitter and email.
By JosephGenerate riddle shorts & post on YouTube with Sonnet 3.5, Pinecone & Creatomate
This workflow allows you to generate riddle-themed vertical videos (9:16), render them using Creatomate, and upload them directly to YouTube — all automatically. It's optimized for low-cost operation while still integrating AI and automation at key stages. Here is a sample: https://youtube.com/shorts/svhgti9L6Fw?feature=share --- 🔄 Workflow Overview This is a schedule-triggered workflow that: Generates riddles with answers using an AI agent. Checks Pinecone vector store to avoid repeating riddles. Inserts new riddles into Pinecone under a namespace structured by month/year for easier indexing. Fetches an unused music track URL for video background. Generates a video using Creatomate with the riddles and audio. Uploads the video to YouTube via a custom HTTP request with OAuth. Updates the worksheet and riddle numbering, and notifies via email. --- 🔗 Integration Guide 🔎 Pinecone Setup You need an active Pinecone account with an index created. The vector index should be accessible from n8n. Follow \[n8n's Pinecone Node Documentation] for help setting up credentials and connecting. 📝 Google Sheet Setup Open the sheets template provided in the Gumroad documentation pdf. Make a copy to your Google Drive. Set up the required credentials in n8n and link the Google Sheets node to your new copy. 🎧 Audio Tracks Get copyright-free tracks from Royalty Free Music Library. Ensure files are in .mp3 format for compatibility. 🎞️ Background Videos (Optional) For optional background visuals, use free stock videos from Pexels. --- 💡 Creatomate Setup Create a Creatomate account at \[creatomate.com]. Create a 9:16 aspect ratio template. Press F12 to open the source editor. Download the Creatomate JSON file from the Gumroad page and paste its contents into the source editor. Refresh the page and click "Use Template" > API Integration. Copy the cURL. From the cURL, extract your Bearer Token and Template ID. Paste them in the respective fields in the Creatomate Render Node inside n8n. --- 📉 YouTube Upload Configuration Inside n8n, set up a YouTube OAuth credential. Search for "YouTube" in the credentials list and select the OAuth type. Use the Custom HTTP Request node with multipart/form-data to upload the video using: Title (e.g., "Riddles4U 001") Description Video file binary Category ID (find ID here: https://gist.github.com/dgp/1b24bf2961521bd75d6c) --- 🔄 Workflow Logic Detail Riddle Generation Checks Pinecone vector store for existing riddles (to avoid duplicates). Generates 4 new riddles with answers. Stores them in Pinecone under month/year namespace. Extracts a numbered title for current riddle post (e.g., Riddles4U 001). Prepares next riddle title counter (but only updates after YouTube post succeeds). Track URL Fetching Pulls the first unused track from Google Sheets. Render & Upload Sends the riddles + track to Creatomate for rendering. Fetches binary video and uploads it directly to YouTube via HTTP. Note: For video source url, I downloaded a video, uploaded it to drive and used that video drive link. You can add a new sheet and rotate videos too, although youtube likes consistency in shorts so I think it is best to have one very beautiful and calm background video then change to a new one after some months or when you generate like 50 shorts. Post Actions Sends email with YouTube video link. Marks used audio row as "used". Updates to next riddle title. If all tracks have been used, resets them to "unused". --- 🚀 Customization Ideas Add AI-generated voiceover to the riddles. Replace riddles with trivia, quotes, or jokes. Integrate TikTok or Instagram upload APIs for multichannel publishing. --- ✉️ Support Refer to the comprehensive setup guide included in the Gumroad download folder to configure your template, credentials, and API keys correctly. This is a beginner-friendly, low-cost automation you can build on for more advanced content pipelines. Happy building! You can find me on twitter and via email incase you need any custom n8n workflows or wanna chat.
By JosephConvert PDF, DOC, and images to Markdown using Datalab.to API
This n8n workflow converts various file formats (.pdf, .doc, .png, .jpg, .webp) to clean markdown text using the datalab.to API. Perfect for AI agents, LLM processing, and RAG (Retrieval Augmented Generation) data preparation for vector databases. Workflow Description Input Trigger Node: Form trigger or webhook to accept file uploads Supported Formats: PDF documents, Word documents (.doc/.docx), and images (PNG, JPG, WEBP) Processing Steps File Validation: Check file type and size constraints HTTP Request Node: Method: POST to https://api.datalab.to/v1/marker Headers: X-API-Key with your datalab.to API key Body: Multipart form data with the file Response Processing: Extract the converted markdown text Output Formatting: Clean and structure the markdown for downstream use Output Clean, structured markdown text ready for: LLM prompt injection Vector database ingestion AI agent knowledge base processing Document analysis workflows Setup Instructions Get API Access: Sign up at datalab.to to obtain your API key Configure Credentials: Create a new credential in n8n Add Generic Header: X-API-Key with your API key as the value Import Workflow: Ready to process files immediately Use Cases AI Workflows: Convert documents for LLM analysis and processing RAG Systems: Prepare clean text for vector database ingestion Content Management: Batch convert files to searchable markdown format Document Processing: Extract text from mixed file types in automated pipelines The workflow handles the complexity of different file formats while delivering consistent, AI-ready markdown output for your automation needs.
By JosephTransform meeting transcripts into AI-generated presentations with Google Slides & Flux
Transform meeting transcripts into fully customized, AI-powered presentations automatically. This comprehensive 5-workflow automation system analyzes client conversations and generates professional slide decks complete with personalized content and AI-generated illustrations. 🎯 What This Automation Does This end-to-end solution takes a meeting transcript (Google Docs) and client information as input, then automatically: Creates a presentation from your custom template Generates a strategic presentation plan tailored to the client's needs Creates custom illustrations using AI image generation Populates slides with personalized text content Inserts generated images into the appropriate slides Delivers a client-ready presentation Perfect for sales teams, consultants, agencies, and anyone who needs to create customized presentations at scale. 🔧 How It Works The automation is split into 5 interconnected workflows: Workflow 1: Clone Presentation & Database Setup Form trigger captures client name, transcript URL, and submission time Clones your presentation template via Google Slides API Saves presentation details to Google Sheets for tracking Workflow 2: AI Presentation Plan Generation Analyzes meeting transcript to understand client pain points Generates comprehensive presentation structure and content strategy Saves plan to Google Docs for review and tracking Uses company profile (customizable) to match solutions to client needs Workflow 3: AI Illustration Generation AI agent creates image prompts based on presentation plan Generates illustrations using Flux model via OpenRouter (nanobanana) Uploads images to Google Drive for slide insertion Tracks all generated assets in database Workflow 4: Text Content Population AI agent generates final presentation text from the plan Replaces template placeholders with personalized content Uses Object IDs to target specific text elements in slides Updates slides using native n8n Google Slides node Workflow 5: Image Insertion Retrieves image Object IDs from presentation structure Downloads illustrations from Google Drive Converts images for ImgBB hosting (resolves Google Drive URL limitations) Updates slide images via Google Slides API 📋 Prerequisites Required Accounts & API Keys: Google Workspace (Drive, Slides, Docs) OpenAI API (for AI agents) OpenRouter API (for Flux image generation) ImgBB API (free tier available) Gemini API (optional, for additional AI tasks) Setup Requirements: Google Sheets database (template provided in article and inside the workflow) Google Slides presentation template with standard Object IDs Meeting transcript in Google Docs format 🎨 Customization Options This automation is designed to be flexible: Template Flexibility: Use any slide template structure Company Profile: Customize the business context for your use case AI Models: Swap OpenAI/Gemini agents for your preferred LLM Image Generation: Replace Flux with DALL-E, Midjourney API, or other models Slide Logic: Extend to dynamically select slides based on content needs 💡 Key Technical Insights Structured Output Handling: Uses JavaScript for reliable JSON parsing when AI output structure is complex Object ID System: Template placeholders use unique IDs for precise element targeting Image Hosting Workaround: ImgBB resolves Google Drive direct URL limitations in API calls HTTP Request Nodes: Used for API operations not covered by native n8n nodes (copying presentations, image updates) 🔗 Full Documentation For a detailed breakdown of each workflow, configuration steps, and best practices, read the complete guide on this Medium article 🚀 Use Cases Sales Teams: Auto-generate pitch decks from discovery calls Consulting Firms: Create client proposals from needs assessments Marketing Agencies: Build campaign presentations from strategy sessions Product Teams: Transform user research into stakeholder presentations Training & Education: Convert session notes into learning materials ⚠️ Important Notes Template must use consistent Object IDs for automation to work Google Drive images require ImgBB hosting for reliable URL access AI agent output structure is complex; JavaScript parsing recommended Rate limits apply for API services (especially image generation) 📦 Resources & Templates API Services (Get Your Keys Here) OpenRouter - For Flux (nanobanana) AI image generation ImgBB API - Free image hosting service OpenAI API - For AI agents and text generation Google Cloud Console - Enable Google Slides, Drive, and Docs APIs Google AI Studio - For Gemini API key Templates & Examples Meeting Transcript Sample - Example transcript structure Google Sheets Database Template - Copy this to track your presentations Presentation Template - Base slide deck with Object IDs 💡 Tip: Make copies of all templates before using them in your workflows! --- Have questions or improvements? Connect with me: X (Twitter): @juppfy Email: joseph@uppfy.com P.S: I'd love to hear how you adapt this for your workflow!
By JosephCreate AI-generated music playlists for YouTube using Suno, GPT-4, Runway & Creatomate
Automated AI Playlist Creator - Complete Music Production Pipeline Demo Youtube Video: https://www.youtube.com/watch?v=B_RDqM0kcgc Overview Transform your music creation process with this comprehensive 11-workflow automation system that generates complete music playlists from concept to YouTube publication. Using advanced AI services, this template creates original songs, lyrics, cover art, animated videos, and handles the entire publishing pipeline automatically. What This Template Does AI-Powered Song Creation: Generates 20 unique song ideas based on your specifications Lyric Generation: Creates custom lyrics for each song using advanced AI Music Production: Produces high-quality audio tracks with AI music generation Visual Content: Creates cover art and animated cover videos Video Compilation: Renders complete playlist videos with all songs Auto-Publishing: Uploads finished videos directly to YouTube Smart Selection: Allows manual curation from multiple AI-generated versions Workflow Architecture Core Workflows (11 Total) Playlist Details Setup - Telegram bot interface for configuration Database & Drive Configuration - Automated folder structure and data management Song Ideas Generator - AI-powered creative song concept generation Lyrics & Task Generation (Batch 1 & 2) - Parallel lyric creation and task management Audio Fetch & Drive Upload - Retrieves generated music and organizes files Song Selection Migration - Handles user curation of AI-generated alternatives Cover Image Generation - AI-powered visual artwork creation Cover Animation - Dynamic video cover creation Video Rendering (20 Songs) - Full playlist compilation Video Rendering (15 Songs) - Alternative stable rendering option YouTube Upload & Publishing - Automated social media publishing APIs & Services Used AI & Machine Learning OpenAI GPT-4.1 - Conversational AI, lyrics generation, image creation Suno API - High-quality AI music generation Runway ML - AI-powered video animation and effects Media & Storage Google Sheets - Database and workflow management Google Drive - File storage and organization via Google Apps Script ImageBB - Image hosting and CDN services Creatomate - Professional video rendering and compilation Communication & Publishing Telegram Bot API - User interface and workflow control YouTube Data API - Automated video publishing SerpAPI - Optional web search for creative inspiration Key Features Intelligent Automation Conversational Setup: Natural language playlist configuration via Telegram Batch Processing: Efficient handling of multiple songs simultaneously Quality Control: Multiple AI-generated versions with manual selection Error Recovery: Robust workflow design with alternative processing paths Status Tracking: Real-time progress monitoring through Google Sheets Professional Output High-Quality Audio: Professional-grade AI music generation Custom Visuals: Unique cover art and animated videos for each playlist Optimized Rendering: Smart video compilation with duration management Platform-Ready: Direct YouTube integration with metadata handling Flexibility & Customization Adjustable AI Prompts: Customize creativity and style parameters Multiple Rendering Options: Choose between 15 or 20 song compilations Genre Versatility: Works across all music genres and styles Scalable Architecture: Easily handle multiple playlists simultaneously Cost Breakdown (Per Playlist) API Service Costs Suno API: $2.40 (480 credits for 20 songs with 2 versions each) OpenAI Services: $0.50-$2.00 (varies by conversation length and customizations) Runway ML: $0.50 (10-second animated cover video) Creatomate: $0.20-$0.27 (within monthly plan of $45-$54/month) ImageBB: Free (within standard limits) Total Estimated Cost: $3.60-$5.17 per complete playlist Additional services (Google, YouTube, Telegram) operate within free tiers for normal usage Technical Requirements Platform Compatibility N8N Instance: Self-hosted or cloud deployment Google Workspace: Sheets and Drive integration API Access: Valid keys for all integrated services Setup Complexity Beginner-Friendly: Detailed documentation with step-by-step instructions Template Database: Pre-configured Google Sheets structure included Guided Configuration: Clear setup process for all API integrations Use Cases Content Creators Music channels and playlists Background music for videos Themed compilations and mixes Business Applications Brand-specific playlists Marketing campaign soundtracks Event and presentation music Personal Projects Custom playlists for special occasions Experimental music creation Learning AI music production What's Included Complete Workflow Package 11 pre-configured N8N workflows Google Sheets database template Custom Google Apps Script for file management Creatomate video template (JSON) Comprehensive setup documentation Support Resources Step-by-step API configuration guides Troubleshooting documentation Customization instructions for AI prompts Performance optimization guidelines Performance & Reliability Processing Capacity Concurrent Processing: Multiple songs generated simultaneously Batch Operations: Efficient API usage with rate limit management Alternative Pathways: Backup workflows for enhanced reliability Quality Assurance Multi-Version Generation: Compare and select best AI outputs Duration Management: Smart handling of video length limitations Error Handling: Comprehensive workflow error recovery --- This template represents a complete AI-powered music production pipeline, transforming simple text descriptions into professional playlist videos ready for publication. Perfect for content creators, musicians, and businesses looking to automate their music content creation workflow. After the Purchase in Gumroad, you will have access to all the workflows JSON files, creatomate template, google script gs code and comprehensive documentation guide. Reach out to me via email at joseph@uppfy.com incase you want a custom workflow.
By JosephUpload & rename videos to Google Drive via Apps Script from URL
📄 Google Script Workflow: Upload File from URL to Google Drive (via n8n) 🔧 Purpose: This lightweight Google Apps Script acts as a server endpoint that receives a file URL (from n8n), downloads the file, uploads it to your specified Google Drive folder, and responds with the file’s metadata (like Drive file ID and URL). This is useful for large video/audio files that n8n cannot handle directly via HTTP Download nodes. --- 🚀 Setup Steps: Create a New Script Project Go to https://script.google.com Click “New Project” Rename the project to something like: DriveUploader --- Paste the Script Code Replace the default Code.gs content with the following (your custom script): javascript function doPost(e) { const SECRET_KEY = 'your-strong-secret-here'; // Set your secret key here try { const data = JSON.parse(e.postData.contents); // 🔒 Check for correct secret key if (!data.secret || data.secret !== SECRET_KEY) { return ContentService.createTextOutput("Unauthorized") .setMimeType(ContentService.MimeType.TEXT); } const videoUrl = data.videoUrl; const folderId = 'YOURFOLDERID_HERE'; // Replace with your target folder ID const folder = DriveApp.getFolderById(folderId); const response = UrlFetchApp.fetch(videoUrl); const blob = response.getBlob(); const file = folder.createFile(blob); file.setName('uploaded_video.mp4'); // You can customize the name return ContentService.createTextOutput(file.getUrl()) .setMimeType(ContentService.MimeType.TEXT); } catch (err) { return ContentService.createTextOutput("Error: " + err.message) .setMimeType(ContentService.MimeType.TEXT); } } --- Generate & Set Up Secret Key To allow authorized post requests to your script only, we need to generate a secret key from aany reliable key generator. You can head over to acte, click generate and copy the "Encryption key 256". Paste it in the 'your-strong-secret-here' placeholder in your script then click save js const SECRET_KEY = 'your-strong-secret-here'; // Set your secret key here; Replace Folder ID in Code Open the target Drive folder in your browser The folder ID is the part of the URL after /folders/ Example: https://drive.google.com/drive/u/0/folders/1Xabc12345678defGHIJklmn Paste that ID in the script: js var folderId = "1Xabc12345678defGHIJklmn"; --- Set Up Deployment as Web App Click “Deploy” > “Manage Deployments” > “New Deployment” Under Select type, choose Web app Description: Upload from URL to Drive Execute as: Me Who has access: Anyone Click Deploy Authorize the script when prompted Copy the Web App URL --- 📤 How to Use in n8n HTTP Request Node Method: POST URL: (your web app URL) Secret Key: (Secret Key set in script) Body Content Type: JSON Paste code: json { "videoUrl": "https://example.com/path/to/your.mp4", "secret": "your-strong-secret-here" } videoUrl: The file download URL secret: The generated and set up secret key Rename Node A simple drive update node to rename the file using the file drive url returned from the script. ---
By JosephCreate complete 20-song YouTube playlists with Suno API, Claude & Telegram bot
Transform your music creation process with this comprehensive automated system that generates complete playlists from simple text descriptions! 🚀 What You Get This professional-grade N8N workflow system automatically creates 20 unique songs per playlist (40 total tracks with 2 versions each) using cutting-edge AI technology. Simply describe your desired playlist through Telegram, and watch as the system generates song ideas, writes lyrics, produces audio, and organizes everything in Google Drive. ⚡ Key Features 🤖 Telegram Bot Interface - User-friendly chat interface for playlist creation 🎼 AI Song Generation - 20 unique song titles and descriptions per playlist 📝 Automated Lyrics Writing - Professional-quality lyrics for each song 🎵 Audio Production - High-quality music tracks via Suno AI 📁 Organized Storage - Automatic Google Drive folder management 🔄 Complete Automation - End-to-end workflow with minimal manual intervention 🛠️ APIs & Services Used Telegram Bot API - User interaction interface Claude AI (Anthropic) - Song ideation and lyrics generation Suno AI - Professional music track generation Google Sheets - Database management Google Drive - Automated file storage and organization Google Apps Script - Seamless file upload integration 📦 What's Included ✅ 7 Complete N8N Workflows - Ready-to-import automation system ✅ Comprehensive Setup Guide - Step-by-step installation instructions ✅ Google Sheets Database Template - Pre-configured data structure ✅ Google Apps Script Code - Custom Drive upload functionality ✅ AI Prompt Templates - Optimized system messages for all agents ✅ Troubleshooting Guide - Solutions for common issues ✅ Customization Instructions - Modify outputs to match your style 💡 Perfect For Music producers and content creators Playlist curators and music enthusiasts Digital agencies offering music services Developers interested in AI automation Anyone looking to streamline music creation workflows 🎯 System Requirements Active N8N instance (cloud or self-hosted) API access to: Telegram, Claude AI, Suno AI, Google Services Basic understanding of N8N workflows (setup guide included) 💰 Cost Considerations Suno AI: ~240 credits per playlist (20 songs × 2 versions) Claude AI: Variable based on usage Other APIs: Minimal costs for most use cases ⏱️ Expected Processing Time Complete playlist generation: 30-45 minutes per playlist (fully automated) --- 🎁 Bonus: Complete documentation includes AI agent customization guide, allowing you to fine-tune song styles, lyrics generation, and bot behavior to match your specific needs. Get instant access to this powerful automation system and start generating professional playlists today! --- If you need a csutom workflow please reach out via email joseph@uppfy.com
By Joseph