Apply to jobs automatically from Google Sheets with status tracking Who's it for Job seekers who want to streamline their application process, save time on repetitive tasks, and never miss following up on applications. Perfect for anyone m…
Download this n8n workflow template and start using it instantly.
Job seekers who want to streamline their application process, save time on repetitive tasks, and never miss following up on applications. Perfect for anyone managing multiple job applications across different platforms.
This workflow automatically applies to jobs from a Google Sheet, tracks application status, and keeps you updated with notifications. It handles the entire application lifecycle from submission to status monitoring.
Key features:
The workflow runs on two main schedules:
Daily Application Process (9 AM, weekdays):
Status Monitoring (Every 2 days at 10 AM):
Create a Google Sheet with these exact column headers:
| Job_ID | Company | Position | Status | Applied_Date | Last_Checked | Application_ID | Notes | Job_URL | Priority |
|---|---|---|---|---|---|---|---|---|---|
| JOB001 | Software Engineer | Not Applied | https://careers.google.com/jobs/123 | High | |||||
| JOB002 | Microsoft | Product Manager | Not Applied | https://careers.microsoft.com/jobs/456 | Medium |
Column explanations:
In the "Set Configuration" node, update these values:
For basic version (no API access): The workflow includes placeholder HTTP requests that you can replace with actual job platform integrations.
For advanced version (with API access):
This workflow transforms job searching from a manual, time-consuming process into an automated system that maximizes your application efficiency while maintaining quality and compliance.
Daily Application Trigger (Cron): Starts the workflow on a recurring cron schedule.
Configuration (Set): Sets or transforms workflow data — prepares, renames, or injects fields before the next step.
Read Jobs Sheet (Google Sheets): Reads from or writes rows to a Google Sheets spreadsheet.
Filter Pending Applications (Filter): Keeps only the items that match a condition and discards the rest.
Process Jobs One by One (Split In Batches): Loops over items in batches, processing each one in turn (used for iteration).
Prepare Application Data (Set): Sets or transforms workflow data — prepares, renames, or injects fields before the next step.
Route by Platform (Switch): Routes the workflow down one of several paths based on a value.
Apply via LinkedIn (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Apply via Indeed (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Process Application Result (Set): Sets or transforms workflow data — prepares, renames, or injects fields before the next step.
Update Job Status (Google Sheets): Reads from or writes rows to a Google Sheets spreadsheet.
Send Application Notification (Gmail): Sends or reads email through Gmail.
Status Check Trigger (Cron): Starts the workflow on a recurring cron schedule.
Read Applied Jobs (Google Sheets): Reads from or writes rows to a Google Sheets spreadsheet.
Filter Applied Jobs (Filter): Keeps only the items that match a condition and discards the rest.
Check Status One by One (Split In Batches): Loops over items in batches, processing each one in turn (used for iteration).
Mock Status Check (Set): Sets or transforms workflow data — prepares, renames, or injects fields before the next step.
Check if Status Changed (If): Branches the workflow based on a true/false condition.
Update Changed Status (Google Sheets): Reads from or writes rows to a Google Sheets spreadsheet.
Send Status Update (Gmail): Sends or reads email through Gmail.
How it works This template launches your very first AI Agent —an AI-powered chatbot that can do more than just talk— it can take action using tools. Think of an AI Agent as a smart assistant, and the tools are the apps on its phone. By connecting it to other nodes, you give your agent the ability to interact with real-world data and services, like checking the weather, fetching news, or even sending emails on your behalf. This workflow is designed to be the perfect starting point: The Chat Interface: A Chat Trigger node provides a simple, clean interface for you to talk to your agent. The Brains: The AI Agent node receives your messages, intelligently decides which tool to use (if any), and formulates a helpful response. Its personality and instructions are fully customizable in the "System Message". The Language Model: It uses Google Gemini to power its reasoning and conversation skills. The Tools: It comes pre-equipped with two tools to demonstrate its capabilities: 1. Get Weather: Fetches real-time weather forecasts. 2. Get News: Reads any RSS feed to get the latest headlines. The Memory: A Conversation Memory node allows the agent to remember the last few messages, enabling natural, follow-up conversations. Set up steps Setup time: ~2 minutes You only need one thing to get started: a free Google AI API key. 1. Get Your Google AI API Key: Visit Google AI Studio at aistudio.google.com/app/apikey. Click "Create API key in new project" and copy the key that appears. 2. Add Your Credential in n8n: On the workflow canvas, go to the Connect your model (Google Gemini) node. Click the Credential dropdown and select + Create New Credential. Paste your API key into the API Key field and click Save. 3. Start Chatting! Go to the Example Chat node. Click the "Open Chat" button in its parameter panel. Try asking it one of the example questions, like: "What's the weather in Paris?" or "Get me the latest tech news."* That's it! You now have a fully functional AI Agent. Try adding more tools (like Gmail or Google Calendar) to make it even more powerful.
Generate AI videos with Seedance & Blotato, upload to TikTok, YouTube & Instagram Who is this for? This template is ideal for creators, content marketers, social media managers, and AI enthusiasts who want to automate the production of short-form, visually captivating videos for platforms like TikTok, YouTube Shorts, and Instagram Reels — all without manual editing or publishing. What problem is this workflow solving? Creating engaging videos requires: Generating creative ideas Writing detailed scene prompts Producing realistic video clips and sound effects Editing and stitching the final video Publishing across multiple platforms This workflow automates the entire process, saving hours of manual work and ensuring consistent, AI-driven content output ready for social distribution. What this workflow does This end-to-end AI video automation workflow: 1. Generates a creative idea using OpenAI and LangChain 2. Creates detailed video prompts with Seedance AI 3. Generates video clips via Wavespeed AI 4. Generates sound effects with Fal AI 5. Stitches the final video using Fal AI’s ffmpeg API 6. Logs metadata and video links to Google Sheets 7. Uploads the video to Blotato 8. Auto-publishes to TikTok, YouTube, Instagram, and other platforms Setup 1. Add your OpenAI API key in the LLM nodes 2. Set up Seedance and Wavespeed AI credentials for video prompt and clip generation 3. Add your Fal AI API key for sound and stitching steps 4. Connect your Google Sheets account for tracking ideas and outputs 5. Set your Blotato API key and fill in the platform account IDs in the Assign Social Media IDs node 6. Adjust the Schedule Trigger to control when the automation runs How to customize this workflow to your needs Change the AI prompts to target your niche (e.g., ASMR, product videos, humor) Add a Telegram or Slack step for video preview before publishing Tweak scene structure or video duration to match your style Disable platforms you don’t want by turning off specific HTTP Request nodes Edit the sound generation prompts for different moods or effects Documentation: Notion Guide --- Need help customizing? Contact me for consulting and support : Linkedin / Youtube
This workflow allows users to generate AI videos using Google Veo3, save them to Google Drive, generate optimized YouTube titles with GPT-4o, and automatically upload them to YouTube with Upload-Post. The entire process is triggered from a Google Sheet that acts as the central interface for input and output. IT automates video creation, uploading, and tracking, ensuring seamless integration between Google Sheets, Google Drive, Google Veo3, and YouTube. --- Benefits of this Workflow No Code Interface: Trigger and control the video production pipeline from a simple Google Sheet. Full Automation: Once set up, the entire video generation and publishing process runs hands-free. AI-Powered Creativity: Generates engaging YouTube titles using GPT-4o. Leverages advanced generative video AI from Google Veo3. Cloud Storage & Backup: Stores all generated videos on Google Drive for safekeeping. YouTube Ready: Automatically uploads to YouTube with correct metadata, saving time and boosting visibility. Scalable: Designed to process multiple video prompts by looping through new entries in Google Sheets. API-First: Utilizes secure API-based communication for all services. --- How It Works 1. Trigger: The workflow can be started manually ("When clicking ‘Test workflow’") or scheduled ("Schedule Trigger") to run at regular intervals (e.g., every 5 minutes). 2. Fetch Data: The "Get new video" node retrieves unfilled video requests from a Google Sheet (rows where the "VIDEO" column is empty). 3. Video Creation: The "Set data" node formats the prompt and duration from the Google Sheet. The "Create Video" node sends a request to the Fal.run API (Google Veo3) to generate a video based on the prompt. 4. Status Check: The "Wait 60 sec." node pauses execution for 60 seconds. The "Get status" node checks the video generation status. If the status is "COMPLETED," the workflow proceeds; otherwise, it waits again. 5. Video Processing: The "Get Url Video" node fetches the video URL. The "Generate title" node uses OpenAI (GPT-4.1) to create an SEO-optimized YouTube title. The "Get File Video" node downloads the video file. 6. Upload & Update: The "Upload Video" node saves the video to Google Drive. The "HTTP Request" node uploads the video to YouTube via the Upload-Post API. The "Update Youtube URL" and "Update result" nodes update the Google Sheet with the video URL and YouTube link. --- Set Up Steps 1. Google Sheet Setup: Create a Google Sheet with columns: PROMPT, DURATION, VIDEO, and YOUTUBE_URL. Share the Sheet link in the "Get new video" node. 2. API Keys: Obtain a Fal.run API key (for Veo3) and set it in the "Create Video" node (Header: Authorization: Key YOURAPIKEY). Get an Upload-Post API key (for YouTube uploads) and configure the "HTTP Request" node (Header: Authorization: Apikey YOUR_API_KEY). 3. YouTube Upload Configuration: Replace YOUR_USERNAME in the "HTTP Request" node with your Upload-Post profile name. 4. Schedule Trigger: Configure the "Schedule Trigger" node to run periodically (e.g., every 5 minutes). --- Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
Automate video creation with Veo3 and auto-post to Instagram, TikTok via Blotato Who is this for? This template is ideal for content creators, social media managers, YouTubers, and digital marketers who want to generate high-quality videos daily using AI and distribute them effortlessly across multiple platforms. It’s perfect for anyone who wants to scale short-form content creation without video editing tools. What problem is this workflow solving? Creating and distributing consistent video content requires: Generating ideas Writing scripts and prompts Rendering videos Manually posting to platforms This workflow automates all of that. It transforms one prompt into a professional AI-generated video and publishes it automatically — saving time and increasing reach. What this workflow does 1. Triggers daily to generate a new idea with OpenAI (or your custom prompt). 2. Creates a video prompt formatted specifically for Google Veo3. 3. Generates a cinematic video using the Veo3 API. 4. Logs the video data into a Google Sheet. 5. Retrieves the final video URL once Veo3 finishes rendering. 6. Uploads the video to Blotato for publishing. 7. Auto-posts the video to Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Twitter (X), Pinterest, and Bluesky. Setup 1. Add your OpenAI API key to the GPT-4.1 nodes. 2. Connect your Veo3 API credentials in the video generation node. 3. Link your Google Sheets account and use a sheet with columns: Prompt, Video URL, Status. 4. Connect your Blotato API key and set your platform IDs in the Assign Social Media IDs node. 5. Adjust the Schedule Trigger to your desired posting frequency. How to customize this workflow to your needs Edit the AI prompt to align with your niche (fitness, finance, education, etc.). Add your own branding overlays using JSON2Video or similar tools. Change platform selection by enabling/disabling specific HTTP Request nodes. Add a Telegram step to preview the video before auto-posting. Track performance by adding metrics columns in Google Sheets. Documentation: Notion Guide --- Need help customizing? Contact me for consulting and support : Linkedin / Youtube