Evoort Solutions
Categories
Templates by Evoort Solutions
Generate AI-Powered LinkedIn Posts with Google Gemini and Gen-Imager
🚀 AI-Powered LinkedIn Post Automation --- 🧩 How It Works This workflow automatically generates LinkedIn posts based on a user-submitted topic, including both content creation and image generation, then publishes the post to LinkedIn. Ideal for marketers, content creators, or businesses looking to streamline their social media activity, without the need for manual post creation. High-Level Workflow: Trigger: The workflow is triggered when a user submits a form with a topic for the LinkedIn post. Data Mapping: The topic is mapped and prepared for the AI model. AI Content Generation: Calls the Google Gemini AI model to generate engaging post content and a visual image prompt. Image Creation: Sends the image prompt to the external API, gen-imager, to generate a professional image matching the topic. Post Creation: Publishes the text and image to LinkedIn, automatically updating the user's feed. --- ⚙️ Set Up Steps (Quick Overview) 🕐 Estimated Setup Time: ~10–20 minutes Connect Google Gemini: Set up your Google Gemini API credentials to interact with the AI model for content creation. Set Up External Image API: Configure the external image generation API (gen-imager API) for visual creation based on the post prompt. Connect LinkedIn: Set up OAuth2 credentials to authenticate your LinkedIn account and allow publishing posts. Form Submission Setup: Create a simple web form for users to submit the topic for LinkedIn posts. Activate the Workflow: Once everything is connected, activate the workflow. It will trigger automatically upon receiving form submissions. 💡 Important Notes: The flow uses Google Gemini (PaLM) for generating content based on the user's topic. Text to Image: The image generation process involves creating a professional, LinkedIn-appropriate image based on the post’s topic using the gen-imager API. You can customize the visual elements of the posts and adjust the tone of the generated content based on preferences. --- 🛠 Detailed Node Breakdown: On Form Submission Trigger: Captures the user-submitted topic and initializes the workflow. Action: Start the process by gathering the topic information. Mapper (Field Mapping) Action: Maps the captured topic to a variable that is passed along for content generation. AI Agent (Content Generation) Action: Calls Google Gemini to generate professional LinkedIn post content and an image prompt based on the submitted topic. Key: Outputs content in a structured form — post text and image prompt. Google Gemini Chat Model Action: AI model that generates actionable insights, engaging copy, and an image prompt for LinkedIn post. Normalizer (Data Cleanup) Action: Cleans the output from the AI model to ensure the content and image prompt are correctly formatted for use in the next steps. Text to Image (Image Generation) Action: Sends the image prompt to the gen-imager API, which returns a custom image based on the post's topic. Decoder (Base64 Decoding) Action: Decodes the image from base64 format for easier uploading to LinkedIn. LinkedIn (Post Creation) Action: Publishes the generated text and image to LinkedIn, automatically creating a polished post for the user’s feed. --- ⏱ Execution Time Breakdown: Total Estimated Execution Time: ~15–40 seconds per workflow run. On Form Submission: Instant (Trigger) Mapper (Field Mapping): ~1–2 seconds AI Content Generation: ~5–10 seconds (depending on server load) Text to Image: ~5–15 seconds (depends on external API) LinkedIn Post Creation: ~2–5 seconds --- 🚀 Ready to Get Started? Let’s get you started with automating your LinkedIn posts! Create your free n8n account and set up the workflow using this link. --- 📝 Notes & Customizations Form Fields: Customize the form to gather more specific information for the LinkedIn posts (like audience targeting, post category, etc.). Image API Customization: Adjust the image generation prompt to fit your brand’s style, or change the color palette as needed. Content Tone: The tone can be adjusted by modifying the system message sent to Google Gemini for content generation. ---
By Evoort SolutionsAI-powered product research & SEO content automation
AI-Powered Product Research & SEO Content Automation Skip the guesswork and manual effort — this n8n flow automates the entire process of researching your product's online competition and generating high-quality SEO content. Whether you're launching a new product or optimizing existing listings, this workflow leverages real-time web data and AI-driven copywriting to deliver: 📈 Search-optimized metadata (Title, Description, Keywords) 🛍️ Engaging product descriptions tailored for marketing 📊 Auto-organized output ready for use in your content or e-commerce platform All of this happens with just one product title input! --- 🧠 How It Works • User submits a product title via a form. • The workflow uses Google Custom Search to gather real-time competitor content based on that title. • Titles, snippets, and keywords are extracted from the search results. • This information is sent to a language model (Google Gemini via LangChain) to generate: SEO-optimized metadata (Title, Description, Keywords) A compelling product description tailored for marketing • The AI-generated content is then parsed and organized into two categories: SEO data and product content. • The structured output is saved automatically into a connected Google Sheet for easy access or further automation. --- 🛠️ What Problems Does This Solve? Manual competitor research and writing SEO content from scratch can be: Time-consuming Inconsistent in quality Not optimized for search engines Hard to scale for multiple products This workflow automates the entire research + writing + structuring process. --- ✅ Key Benefits Instant Content Creation: Generate polished SEO content in seconds. Competitor-Aware: Pulls in real-time data from the web for relevant, market-aligned content. Scalable: Easily repeat the process for multiple product titles with minimal effort. Data Centralization: Stores everything in Google Sheets—great for collaboration or syncing with other tools. Customizable: Easily extend or modify the workflow to include translations, publishing, or social media automation. --- ⚙️ Set-Up Steps • Connect Google Custom Search API with a valid API key and search engine ID (CX). • Connect and configure Google Gemini or LangChain with access credentials. • Provide access to a Google Sheet with columns for storing SEO and product data. • Estimated setup time: ~15–25 minutes depending on API access and sheet setup. --- 🚀 Let’s Get You Started with Automating Your LinkedIn Posts! Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsSummarize youtube videos from transcript for social media
🎥 YouTube Video Summarizer for Social Media Turn any YouTube video into a short, structured summary using AI — perfect for content creators, marketers, or social media managers. --- 🔧 What We Built We created a no-code automation in n8n that: Accepts a YouTube Video ID via a form Fetches the video transcript using an external API Summarizes the transcript using AI (Google Gemini) Automatically saves the summary to Google Docs for team use --- 🧩 Flow Overview | Step | Description | |------|-------------| | ✅ Form Trigger | User submits a YouTube video ID using an n8n form | | 🔁 Set Node | Maps the YouTube video ID for use in the API request | | 🌐 HTTP Request (External API) | Calls the YouTube Transcriptor AI API via RapidAPI to fetch transcript | | 🧹 Formatter (Code Node) | Joins transcript lines into a readable text block | | 🧠 AI Agent + Google Gemini (via Langchain) | Summarizes the full transcript into bullet points and tone | | 🧽 Optimizer (Code Node) | Extracts just the summary from the AI response | | 📝 Google Docs Node | Appends the clean summary to a shared Google Doc | --- 🌍 Real-World Problem Solved ❌ The Challenge Creators and marketers waste hours watching full videos just to extract the key points. Manual summarization is inconsistent, repetitive, and delays content planning. ✅ Our Solution ⏱️ Reduces time spent watching videos 🧠 AI-powered summaries keep tone consistent and structured 📄 Auto-sync with Google Docs makes summaries instantly available for teams 🔥 Bonus: This uses the YouTube Transcriptor AI API, so no need to manually scrape captions or use browser extensions. --- 🚀 Ideal Use Cases Repurpose YouTube content into Instagram Reels, LinkedIn posts, or blog content Build a video summary library for your editorial team Quickly extract talking points from podcast episodes --- 🛠️ Tech Stack n8n – workflow automation engine YouTube Transcriptor AI API – via RapidAPI Google Gemini (via Langchain) – AI summarization Google Docs – stores the final summary JavaScript nodes – custom text parsing & formatting --- 💡 Want to customize it? Add Slack, Airtable, Notion, or Tweet auto-posting to expand the flow. Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsAutomate TikTok video transcription with RapidAPI and Google Sheets
TikTok Transcript Generator Overview This automated workflow extracts transcripts from TikTok videos by reading video URLs from a Google Sheet, calling the API via TikTok Transcript Generator, cleaning the subtitle data, and updating the sheet with transcripts. It efficiently handles batches, errors, and rate limits to provide a seamless transcription process. Key Features Batch processing: Reads and processes multiple TikTok video URLs from Google Sheets. Automatic transcript generation: Uses the TikTok Transcript Generator API on RapidAPI. Clean subtitle output: Removes timestamps and headers for clear transcripts. Error handling: Marks videos with no available transcript. Rate limiting: Implements wait times to avoid API throttling on RapidAPI. Seamless Google Sheets integration: Updates the same sheet with transcript results and statuses. API Used TikTok Transcript Generator API Google Sheet Columns | Column Name | Description | |----------------|-----------------------------------------| | Video Url | URL of the TikTok video to transcribe | | Transcript | Generated transcript text (updated by workflow) | | Generated Date | Date when the transcript was generated (YYYY-MM-DD) | Workflow Nodes Explanation | Node Name | Type | Purpose | |--------------------------|-----------------------|-------------------------------------------------------------------| | When clicking ‘Execute workflow’ | Manual Trigger | Manually starts the entire transcription workflow. | | Google Sheets2 | Google Sheets (Read) | Reads TikTok video URLs and transcript data from Google Sheets. | | Loop Over Items | Split In Batches | Processes rows in smaller batches to control execution speed. | | If | Conditional Check | Filters videos needing transcription (URL present, transcript empty). | | HTTP Request | HTTP Request | Calls the TikTok Transcript Generator API on RapidAPI to fetch transcripts. | | If1 | Conditional Check | Checks for valid API responses (handles 404 errors). | | Code | Code (JavaScript) | Cleans and formats raw subtitle text by removing timestamps. | | Google Sheets | Google Sheets (Update)| Updates the sheet with cleaned transcripts and generation dates. | | Google Sheets1 | Google Sheets (Update)| Updates sheet with “No transcription available” message on error.| | Wait | Wait | Adds delay between batches to avoid API rate limits on RapidAPI. | Challenges Resolved Manual Transcription Effort: Eliminates the need to manually transcribe TikTok videos, saving time and reducing errors. API Rate Limits: Introduces batching and wait periods to avoid exceeding API usage limits on RapidAPI, ensuring smooth execution. Incomplete or Missing Data: Filters out videos already transcribed and handles missing transcripts gracefully by logging appropriate messages. Data Formatting Issues: Cleans raw subtitle data to provide readable, timestamp-free transcripts. Data Synchronization: Updates transcripts back into the same Google Sheet row, maintaining data consistency and ease of access. Use Cases Content creators wanting to transcribe TikTok videos automatically. Social media analysts extracting text data for research. Automation enthusiasts integrating transcript generation into workflows. How to Use Prepare a Google Sheet with the columns: Video Url, Transcript, and Generated Date. Connect your Google Sheets account in the workflow. Enter your RapidAPI key for the TikTok Transcript Generator API. Execute the workflow to generate transcripts. View transcripts and generated dates directly in your Google Sheet. --- Try this workflow to automate your TikTok video transcriptions efficiently! Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsGenerate & upload images with Image-to-Image GPT, Google Sheets & Drive
🖼️ Image-to-Image AI Generator from Google Sheets with Google Drive Upload --- ✅ Use Case Automatically generate AI images from prompts listed in a Google Sheet, upload the images to Google Drive, and log the result back into the sheet. Uses the image-to-image-gpt API for fast, customizable generation. --- 💡 Problem It Solves Manual image generation workflows are inefficient and error-prone. Creative and content teams often have to: Manually paste prompts into image generation tools Save images locally Upload to Google Drive Paste the link back into tracking spreadsheets This automation removes all that friction—turning one spreadsheet into a complete image creation pipeline. --- 🌟 Benefits 🔁 Fully automated image generation 📤 Direct uploads to Google Drive 🧾 Image links and timestamps logged in Google Sheets ⚠️ Built-in error logging for API failures 🧩 Modular and easily extensible 📊 Keeps a historical log of successes and errors --- 🧩 Workflow Overview | Node | Description | |------|-------------| | 1. Manual Trigger | Starts the workflow when executed manually | | 2. Google Sheets2 | Reads all rows from the input Google Sheet | | 3. Loop Over Items | Processes one row (prompt) at a time | | 4. If2 | Filters only rows where Prompt is not empty and drive path is empty | | 5. HTTP Request1 | Calls the image-to-image-gpt API with the prompt | | 6. If1 (Error Handling) | If an error exists in the API response, route to logging | | 7. Google Sheets4 (Error Log) | Appends error details to a log sheet for review | | 8. Code1 | Decodes the base64 image returned by the API | | 9. Google Drive1 | Uploads the image to a selected Google Drive folder | | 10. Google Sheets1 (Write Back) | Updates the original row with the image drive path and timestamp | | 11. Wait | Delays the next prompt to prevent hitting API rate limits | --- 🛠 Tech Stack n8n (no-code automation) Google Sheets (data input/output) Google Drive (image storage) image-to-image-gpt API via RapidAPI JavaScript (in Code node) for base64 processing --- 📝 Sheet Format Your Google Sheet should include the following columns: | Column | Purpose | |----------------|----------------------------------| | Prompt | The AI prompt to send to the API | | Image url | (Optional) Initial image URL | | drive path | Updated with Drive link by flow | | Generated Date | Auto-filled by the workflow | | Base64 | Stores raw or error data | --- 🚀 How to Use Import this workflow into your n8n instance Set up Google Sheets and Google Drive service credentials Add your RapidAPI key in the HTTP Request node headers Use the image-to-image-gpt endpoint in the HTTP request Configure the Google Sheet and Drive folder in the respective nodes Execute manually or add a Cron node for scheduling --- 📌 Example Applications 🛍 eCommerce: Auto-generate product mockups 🧵 Fashion/Design: Visualize styles or fabrics from prompts ✍️ Blogging/Content: Auto-generate header images from titles 📣 Marketing: Generate ad banners from text --- 🧪 Tips You can add a Cron node if you want this to run on a schedule Use a separate tab/sheet for logging failed prompts Extend the flow by adding: Email notifications Slack alerts File name templating --- Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsYouTube to multilingual blogs: convert videos to SEO-friendly Google Doc articles
🎬 YouTube Video to Blog – Multilingual Blog Generator Convert YouTube videos into SEO-friendly blog posts in just seconds using this fully automated n8n workflow. Perfect for content creators, marketers, educators, and bloggers looking to repurpose video content without manual transcription or formatting. --- 🔧 What It Does 📥 Accepts a YouTube video URL and preferred language via a simple form 🧠 Uses a third-party API to convert the video into a blog-style article 📄 Automatically inserts the generated content into a Google Docs document --- 🌍 Supported Languages Supports all major languages, including but not limited to: English Hindi French German Gujarati 🎯 The workflow is flexible and can generate blog content in any language supported by the API. Just select your language when submitting the form. --- 🚀 Benefits ⏱️ Time-Saving: Eliminate manual video transcription and formatting 🌐 Multilingual: Easily generate blogs in multiple languages 📚 Centralized Storage: Store all generated blogs in a single Google Docs file 🔧 Customizable: Extend the flow to auto-publish, email, or analyze content --- 🧠 Use Cases Repurpose YouTube content into keyword-rich blog posts Generate multilingual content for global reach Convert educational videos into study guides or summaries Create email newsletters or social media posts from video content --- 🛠️ Requirements ✅ An n8n instance (self-hosted or cloud) 🔑 RapidAPI key for youtube-to-blog.p.rapidapi.com 🧾 A Google Docs account with API access --- 🚨 Note: Be sure to update the API key and Google Docs URL with your own credentials before activating the workflow. --- Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsText-to-image generator with Google Sheets & Drive integration using Flux AI
🖼️ Text-to-Image Generator using n8n + Flux AI This n8n workflow automates image generation from text prompts using the Text-to-Image Flux AI API. It reads prompts from Google Sheets, generates images via API, uploads them to Google Drive, and logs the outcome. --- 🌟 Key Features Integrates with Text-to-Image Flux AI on RapidAPI Converts base64 image data to downloadable files Stores images on Google Drive Updates logs and errors back into Google Sheets Skips prompts already processed --- 📄 Google Sheet Column Structure Your source Google Sheet should include the following columns: | Column Name | Description | |-------------------|--------------------------------------------------| | Prompt | The text prompt to generate an image from | | drive path | (Optional) File path or URL of saved image | | Generated Date | Date/time the image was generated | | Base64 | Base64 string or error message (for logging) | Only rows with a non-empty Prompt and empty drive path will be processed. --- 📌 Use Case Perfect for: Bulk AI image generation for content marketing Creative automation with prompt-based image creation Building image assets based on structured datasets Any workflow where prompts are tracked via Google Sheets Uses the Text-to-Image Flux AI API to generate high-quality images on demand. --- 🔧 Workflow Summary | Step | Node | Description | |------|------|-------------| | 1 | Manual Trigger | Manually start the workflow | | 2 | Google Sheets2 | Reads prompts from Google Sheets | | 3 | Loop Over Items | Processes rows one by one | | 4 | If2 | Skips rows that already have images | | 5 | HTTP Request1 | Calls Text-to-Image Flux AI via RapidAPI | | 6 | Code1 | Converts base64 image to binary file | | 7 | Google Drive1 | Uploads the image file to a Drive folder | | 8 | Google Sheets1 | Logs base64 result and timestamp back | | 9 | If1 | Handles errors from the API | | 10 | Google Sheets4 | Logs errors to the sheet | | 11 | Wait | Adds delay between batches to prevent rate-limiting | --- 🚀 RapidAPI: Text-to-Image Flux AI This flow is powered by Text-to-Image Flux AI. Be sure to: Sign up at RapidAPI and subscribe to the API. Copy your API Key. Replace "your key" in the HTTP Request1 node’s x-rapidapi-key header. You can test the API directly here before connecting it to n8n. --- ✅ Tips for Setup Ensure you’ve set up a Google Service Account with access to both Sheets and Drive. Fill only the Prompt column — leave drive path and Base64 empty for new prompts. Monitor your RapidAPI dashboard for usage and quota. --- Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsTrack YouTube trends by country and language with RapidAPI & Google Sheets
📈 YouTube Trend Finder Workflow using n8n & RapidAPI Description: Easily discover trending YouTube videos by country and language using this automated n8n workflow. The flow leverages the YouTube Trend Finder API and logs insights to Google Sheets — ideal for content creators, marketers, and researchers. --- 🔗 Node-by-Node Explanation | Node Name | Type | Description | |-----------------------------|--------------------|-----------------------------------------------------------------------------| | 1. On form submission | Form Trigger | Captures user input for country and language through a web form. | | 2. Trend Finder API Request | HTTP Request | Sends a request to YouTube Trend Finder API with the form data. | | 3. Re format output | Code | Extracts and reshapes API response data like title, link, and tags. | | 4. Google Sheets | Google Sheets | Appends the trending video data into a structured spreadsheet. | --- 🎯 Use Cases 🔍 Content Research: Find top-trending videos in any region or language for idea inspiration. 📈 Marketing Intelligence: Track video trends to tailor your video marketing strategy. 📰 Trend Monitoring: Journalists and analysts can quickly surface viral video topics. --- ✅ Benefits of this Workflow No Coding Required: Easy-to-use form interface for non-technical users. Real-Time Trends: Instantly access trending YouTube content with the YouTube Trend Finder API. Automated Logging: Stores data directly in Google Sheets for future analysis or sharing. Customizable: Easily modify for more inputs like video category, max results, or add filters. --- Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsAutomated SEO Keyword Tracking and Research via Semrush API in Google Sheets
🔎 Automated Keyword Research Workflow with Google sheet logging & Semrush API Description: Easily collect keywords and country input, run automated keyword research via the Semrush Keyword Research API on RapidAPI, and store results in Google Sheets for seamless tracking and analysis. --- ⚙️ Node-by-Node Explanation 🟢 On form submission (formTrigger) Collects keyword and country inputs from the user via a simple form to start the research process. Triggers the workflow execution upon submission. 🌐 Keyword Research (httpRequest) Sends a POST request with user inputs (keyword and country) to the Semrush Keyword Research. Retrieves keyword suggestions, search volume, and related data for comprehensive keyword insights. 📄 Append Data to Google Sheet (googleSheets) Automatically appends the keyword research results into a connected Google Sheets document. Enables easy tracking, sharing, and further analysis of keyword data. --- 📈 Example Spreadsheet Structure | Keyword | Country | Search Volume | CPC | Competition | Keyword Difficulty | Related Keywords | Date of Research | |---------------|---------|---------------|------|-------------|--------------------|-------------------------------------|------------------| | keyword1 | US | 10,000 | $2.50| 0.75 | 45 | keyword2, keyword3 | 2025-09-09 | | example term | UK | 15,000 | $1.80| 0.60 | 38 | term1, example keyword | 2025-09-09 | 🌟 Benefits 🚀 Powered by Semrush Keyword Research API on RapidAPI: Reliable, up-to-date keyword insights accessible via a simple API integration. 🔄 Fully Automated: From user input to data storage, the process is seamless and requires no manual handling. 📊 Centralized Data Storage: Storing results in Google Sheets ensures accessibility and easy collaboration. 📈 Scalable & Repeatable: Run keyword research on-demand for multiple keywords and countries effortlessly. --- 🚀 Use Cases 🏢 SEO Agencies: Quickly gather keyword data for clients in different markets using the Semrush Keyword Research. 📱 Digital Marketing Teams: Monitor and expand keyword strategies by collecting keyword ideas and volume regularly through the Semrush Keyword Research. 🔎 Content Creators: Identify trending and high-traffic keywords tailored by country to optimize content via the Semrush Keyword Research API. 📅 Automated Reporting: Generate scheduled keyword research reports by integrating this workflow into larger marketing automation pipelines. --- 🔑 How to Get Your API Key for Semrush Keyword Research Visit the API Page: Go to the Semrush Keyword Research on RapidAPI. Sign Up/Login: Create an account or log in if you already have one. Subscribe to the API: Click "Subscribe to Test" and choose a plan (free or paid). Copy Your API Key: After subscribing, your API Key will be available in the "X-RapidAPI-Key" section under "Endpoints". Use the Key: Include the key in your API requests like this: bash -H "X-RapidAPI-Key: YOURAPIKEY" 🛠 Customizing the Workflow To modify the automated workflow and adapt it to your specific use case, follow these guidelines: Adjust the Data Retrieval Process: You can modify the data you want to receive from the Semrush API. For example, if you’re only interested in search volume and CPC, you can filter out the other results in the API request. Add More Countries: If you work with multiple regions, modify the workflow to accept multiple country inputs. You could either pass in a list of countries or have a dropdown on the form that lets users select their country of choice. Expand Keyword Types: The workflow can be expanded to collect data for different types of keywords, such as long-tail or LSI (Latent Semantic Indexing) keywords, depending on your SEO needs. Set Up Scheduled Keyword Reporting: To automate reporting, you can schedule keyword research reports to run at regular intervals, such as monthly, using Google Apps Script or another task scheduler. This way, you’ll always have fresh data on hand for analysis. ✅ Tips for Smooth Workflow Integration Test Your API Integration: Run a test to check if data is properly flowing into your Google Sheet before automating the process. Set Up Notifications: Use Google Sheets' built-in notifications or an external automation tool (e.g., Zapier, Integromat) to notify you when new data is added or if there’s an issue with the workflow. Handle Errors Gracefully: Add error handling in your automated process to prevent issues like missing data or API request failures from disrupting your workflow.
By Evoort SolutionsAutomate job searches with Job Search Global API & Google Sheets
Job Search Automation with Job Search Global API & Google Sheet Logging Description: Automate your job search process by querying the Job Search Global API via RapidAPI every 6 hours for a specified keyword like “Web Developer.” This workflow extracts job listings and saves them directly to Google Sheets, with alerts sent for any API failures. --- Workflow Overview Schedule Trigger Runs the workflow automatically every 6 hours to ensure up-to-date job listings. Set Search Term Defines the dynamic job keyword, e.g., "Web Developer," used in API requests. Fetch Job Listings Sends a POST request to the Job Search Global API (via RapidAPI) to retrieve job listings with pagination. Check API Response Validates the API response status, branching workflow on success or failure. Extract Job Data Parses the job listings array from the API response for processing. Save to Google Sheet Appends or updates job listings in Google Sheets, avoiding duplicates by matching job titles. Send Failure Notification Email Sends an alert email if the API response fails or returns an error. --- How to Obtain Your RapidAPI Key (Quick Steps) Go to RapidAPI Job Search Global API. Sign up or log in to your RapidAPI account. Subscribe to the API plan that suits your needs. Copy your unique X-RapidAPI-Key from the dashboard. Insert this key into your workflow’s HTTP Request node headers. --- How to Configure Google Sheets Create a new Google Sheet for job listings. Share the sheet with your Google Service Account email to enable API access. Use the sheet URL in the Google Sheets node within your workflow. Map columns correctly based on the job data fields. --- Google Sheet Columns Used | Column Name | Description | | ----------- | ----------------------------------- | | title | Job title | | url | Job posting URL | | company | Company name | | postDate | Date job was posted | | jobSource | Source of the job listing | | slug | Unique job identifier or slug | | sentiment | Sentiment analysis score (if any) | | dateAdded | Date the job was added to the sheet | | tags | Associated tags or keywords | | viewCount | Number of views for the job post | --- Use Cases & Benefits Automated Job Tracking: Get fresh job listings without manual searching by automatically querying the Job Search Global API multiple times per day. Centralized Job Data: Save and update listings in Google Sheets for easy filtering, sharing, and tracking. Failure Alerts: Get notified immediately if API calls fail, helping maintain workflow reliability. Customizable Search: Change keywords anytime to tailor job searches for different roles or industries. --- Who Is This Workflow For? Recruiters looking to monitor job market trends in real-time. Job Seekers who want to automate job discovery for specific roles like “Web Developer.” HR Teams managing talent pipelines and job postings. Data Analysts needing structured job market data for research or reporting. --- Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsConvert YouTube videos to MP3 with RapidAPI, Google Drive storage & sheets logging
Automated YouTube to MP3 Conversion and Storage with Google Sheets This automated workflow allows seamless conversion of YouTube videos to MP3, using the YouTube to MP3 Downloader API. The converted MP3 files are uploaded to Google Drive, and all relevant conversion data like download links and file sizes are logged in Google Sheets. Ideal for content creators and download enthusiasts, it enhances efficiency and accuracy in handling YouTube-to-MP3 conversions. Node-by-Node Explanation: On form submission Triggers the workflow when a user submits a YouTube video URL for conversion. HTTP Request Sends a POST request to the YouTube to MP3 Downloader API to initiate the conversion of the YouTube URL to MP3 format. Google Drive Uploads the converted MP3 file to Google Drive for cloud storage. Google Sheets (Initial Log) Logs initial details such as URL and status in Google Sheets before the conversion is complete. Google Sheets (Final Log) After successful conversion, logs the download link, file size, and other relevant data in Google Sheets. If Condition Filters the process to only proceed if the conversion status is "done." Wait Pauses the workflow until the conversion process is completed. Code Converts file size from bytes to megabytes (MB) for easier reference in Google Sheets. Download MP3 Triggers the MP3 file download once the conversion is finished. Problem Solved: Converting YouTube videos to MP3 manually is time-consuming and tedious. The process involves multiple steps, such as downloading the video, extracting audio, and organizing the files, which can be a hassle, especially if you need to do it frequently. Additionally, managing and tracking these files and their statuses can be chaotic, leading to disorganization. This workflow automates the entire process: Conversion automation: No need for third-party apps or websites to handle YouTube-to-MP3 conversion. Efficient tracking: All conversion details (file size, download link, etc.) are logged in Google Sheets, keeping everything organized. Cloud storage: Directly stores converted MP3s in Google Drive, ensuring files are secure, easy to access, and well-managed. By leveraging the YouTube to MP3 Downloader API, this workflow removes all the manual steps, allowing you to save time and effort while keeping everything organized. Benefits of the Flow: Time-Saving Automation: Automatically converts YouTube videos to MP3 using the YouTube to MP3 Downloader API, eliminating the need for manual conversion. Data Logging: Automatically logs essential conversion details (like file size, download link, etc.) in Google Sheets for easy reference. Cloud Storage Integration: Converted MP3 files are directly uploaded to Google Drive for secure, cloud-based storage. No Hassle: Eliminates the need for third-party tools or manual tracking of conversions. Use Cases: Content Creators If you’re a YouTuber or a podcast creator, you might need to convert and store multiple audio files for your content. This workflow can help by automatically converting YouTube videos or podcasts to MP3 and saving them to Google Drive, all while keeping a detailed log in Google Sheets. Educators and Trainers Teachers or trainers often use YouTube videos for educational purposes and might want to extract the audio (e.g., for podcasts or lectures). With this automation, they can easily convert YouTube content into MP3 format for use in offline teaching or sharing with students. Social Media Managers Social media managers working with audio content can use this workflow to quickly convert YouTube videos to MP3 files and upload them to Google Drive for easy sharing with their team or posting on social platforms. Music Enthusiasts Music lovers who want to save YouTube music videos or tracks into MP3 format for personal use or offline listening can benefit from this automated conversion process. The workflow makes it fast and easy to convert, store, and track MP3 files. Content Archivists If you’re working on archiving online media or curating content libraries, this system allows for quick and efficient conversion, storing, and cataloging of YouTube videos in MP3 format with all relevant metadata stored in Google Sheets for easy management. --- Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsDownload watermark-free TikTok videos to Google Drive with automated sheets logging
📥 TikTok to MP4 Converter with Google Drive & Sheets Convert TikTok videos to MP4 , MP3 (without watermark), upload to Google Drive, and log conversion attempts into Google Sheets automatically — powered by TikTok Download Audio Video API. --- 📝 Description This n8n automation accepts a TikTok video URL via a form, sends it to the TikTok Download Audio Video API, downloads the watermark-free MP4, uploads it to Google Drive, and logs the result (success/failure) into Google Sheets. --- 🧩 Node-by-Node Overview | | Node | Functionality | |---|-------------------------------|-------------------------------------------------------------------------------| | 1 | 🟢 Form Trigger | Displays a form for user input of TikTok video URL. | | 2 | 🌐 TikTok RapidAPI Request | Calls the TikTok Downloader API to get the MP4 link. | | 3 | 🔍 If Condition | Checks if the API response status is "success". | | 4 | ⬇️ MP4 Downloader | Downloads the video file using the returned "no watermark" MP4 URL. | | 5 | ☁️ Upload to Google Drive | Uploads the video file to Google Drive root folder. | | 6 | 🔑 Set Google Drive Permission | Makes the file publicly shareable via link. | | 7 | 📄 Google Sheets (Success) | Logs TikTok URL + public Drive link into a Google Sheet. | | 8 | ⏱️ Wait Node | Delays to prevent rapid write operations on error. | | 9 | 📑 Google Sheets (Failure) | Logs failed attempts with Drive_URL = N/A. | --- ✅ Use Cases 📲 Social media managers downloading user-generated content 🧠 Educators saving TikTok content for offline lessons 💼 Agencies automating short-form video curation 🤖 Workflow automation demonstrations with n8n --- 🎯 Key Benefits ✔️ MP4 without watermark via TikTok Download Audio Video API ✔️ Automated Google Drive upload & shareable links ✔️ Centralized logging in Google Sheets ✔️ Error handling and retry-safe structure ✔️ Fully customizable and extendable within n8n --- 💡 Ideal for anyone looking to automate TikTok video archiving with full control over file storage and access. 🔐 How to Get Your API Key for the TikTok Download Audio Video API Go to 👉 TikTok Download Audio Video API - RapidAPI Click "Subscribe to Test" (you may need to sign up or log in). Choose a pricing plan (there’s a free tier for testing). After subscribing, click on the "Endpoints" tab. Your API Key will be visible in the "x-rapidapi-key" header. 🔑 Copy and paste this key into the httpRequest node in your workflow. --- Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n
By Evoort Solutions