Export SQL table into CSV file
This workflow demonstrates how easy it is to export SQL query to CSV automatically! Before running the workflow please make sure you have access to a local or remote MSSQL server with a sample AdventureWorks database. The detailed process is explained in the tutorial https://blog.n8n.io/sql-export-to-csv/
By EduardAi-powered automated job search & application
Unleash the power of AI to automate your job search, tailor your applications, and boost your chances of landing your dream job! This comprehensive workflow handles everything from finding relevant job postings to generating personalized resumes and cover letters. Use cases are many: Automate your entire job application process: Spend less time searching and more time preparing for interviews. Tailor your resume and cover letter for every application: Maximize your ATS compatibility and stand out to recruiters. Efficiently track your applications: Keep all your job search activities organized in one place. Discover new job opportunities: Leverage the Adzuna API to find relevant listings. --- Good to know: Free Adzuna API: This workflow utilizes the free* Adzuna API, making job search capabilities accessible without initial cost. OpenRouter Chat Model Costs: AI model usage (for resume rewriting and cover letter generation) will incur costs based on the OpenRouter pricing model. Please check OpenRouter's official website for updated pricing information. Model Availability: The AI models used may have geo-restrictions. If you encounter a "model not found" error, it might not be available in your country or region. --- How it works: Webhook Trigger: The workflow is initiated via a webhook, allowing you to trigger it manually or integrate it with other systems (e.g., a form submission with your desired job title and resume). Resume Extraction: Your uploaded resume (e.g., PDF) is automatically extracted into a readable text format. Job Search (Adzuna API): Using the provided job title, the workflow queries the Adzuna API to fetch relevant job postings. Job Filtering: Duplicate job listings are filtered out to ensure you receive unique opportunities. Job Info Extraction: Key details like job description, company name, and job URL are extracted from each posting. Skills Extraction (AI): An AI model (OpenRouter) analyzes the job description to identify the top skills and qualifications required. Resume Match Scoring (AI): Your resume is compared against the extracted job skills by an AI model, generating a compatibility score (1-5). Conditional Resume & Cover Letter Generation: If the resume match score is satisfactory (≥ 3): Tailored Resume Generation (AI): An AI model rewrites your resume, specifically highlighting the skills and experience most relevant to the target job, in an ATS-friendly and human-readable JSON/HTML format. Personalized Cover Letter Generation (AI): A custom cover letter is drafted by AI, uniquely tailored to the job description and your newly optimized resume, generated as well-formatted HTML. Google Sheets Integration: The generated cover letter, tailored resume, job URL, and application status are automatically updated in your designated Google Sheet for easy tracking. Gmail Notification: A personalized email containing the generated cover letter, tailored resume, and a direct link to the job posting on Adzuna is sent to your specified email address. Webhook Response: A final text response is sent back via the webhook, summarizing the sent application materials. --- How to use: Manual Trigger: The workflow is set up with a manual trigger (Webhook) for initial testing and demonstration. You can easily replace this with an n8n form, a scheduled trigger, or integrate it into your existing tools. Input: Provide your desired job search keyword and your resume (e.g., as a PDF) to the webhook. Review & Apply: Review the AI-generated cover letter and tailored resume sent to your email, then proceed to apply for the job using the provided Adzuna link. --- Requirements: n8n Instance: A running n8n instance (self-hosted or cloud). Adzuna API Key: A free Adzuna API key (easily obtainable from their developer portal). OpenRouter Account: For AI model access (costs apply based on usage). Google Sheets Account: To store and track your job applications. Gmail Account: To send automated application emails. --- Customizing this workflow: This workflow is highly customizable. You can: Integrate with other job boards (e.g., LinkedIn, Indeed) using their APIs. Add more sophisticated AI models or custom prompts for even finer control over resume and cover letter generation. Connect to other services for CRM, calendar management, or applicant tracking. Implement different filtering criteria for job postings. Expand the data stored in your Google Sheet (e.g., interview dates, feedback). Start automating your job search today and streamline your path to career success!
By Gerald DenorAutomate email management with Gemini AI and Gmail for smart responses
Managing your inbox can feel like a full-time job. Some emails deserve an instant response, others need thoughtful handling, and many don’t need a reply at all. This workflow takes that weight off your shoulders by combining AI intelligence with human oversight, so you spend less time sorting and more time focusing on what matters. --- Why This Workflow Matters Think about how much energy gets drained just deciding: Should I reply to this now? Is this too sensitive for an automatic response? Or is this just noise I can safely ignore? This workflow does that decision-making for you. With the help of Google Gemini, it reads each incoming email, categorizes it, and then either: Replies instantly with a warm, professional message, Prepares a draft reply for you to review, Or does nothing if the message is irrelevant. It’s like having a personal assistant who knows when to step in and when to leave things for you. --- Benefits You’ll Notice Clarity in your inbox: No more second-guessing which emails need your attention. Faster replies: Routine messages get answered automatically in seconds. Peace of mind: Sensitive or complex topics are flagged for your review, you’re always in control. Less mental clutter: By ignoring noise (marketing blasts, spam, automated notifications), you can focus on meaningful conversations. Consistency: Every reply feels polite, professional, and human, without you lifting a finger. Over time, you’ll notice your inbox feels lighter, your response times improve, and your focus shifts back to real work rather than inbox triage. --- How It Works Gmail Trigger catches every new incoming email. AI Categorizer decides whether the message should be: Reply (safe to answer immediately), Draft (needs your review), Nothing (ignore). AI Writer generates either a ready-to-send reply or a draft that feels natural and professional. Gmail Integration then either sends, drafts, or ignores, based on the AI’s decision. --- Use Cases Customer support: Quick replies for common questions, while important issues get drafted for your review. Freelancers & solopreneurs: Keep clients happy with fast replies, but stay safe on sensitive topics. Personal inbox management: Lighten the load of newsletters, promotions, and low-value emails. --- Requirements An n8n instance (self-hosted or cloud). A Gmail account connected via OAuth2 in n8n. Google Gemini API access for AI categorization and drafting. Basic familiarity with n8n workflows and how to connect credentials. --- FAQ Q: Will this replace my judgment entirely? No. It only automates what’s safe. Complex or sensitive emails are always drafted for you to review. Q: Can I customize how the AI writes replies? Yes. You can adjust the prompt inside the workflow to match your own style and tone. Q: What happens if the AI misclassifies an email? At worst, you’ll get a draft instead of an auto-reply. You’ll never lose control over sensitive communication. Q: Does this cost extra to run? Using Gmail via n8n is free, but you’ll need Google Gemini API access, which may come with its own usage limits or costs. --- ⚠️ Important Note: This workflow comes with no support. You need to be comfortable working with n8n, credentials, and AI nodes on your own. It’s provided as-is for the community to experiment with and adapt. --- Start using it, and you’ll quickly see how much lighter your inbox feels.
By Hashir Bin Waseem