by Rahul Joshi
Description This workflow automates employee retention analytics by combining candidate performance data with trait-level retention statistics. It scores candidates, validates data, and generates a polished Retention Digest HTML email using GPT (Azure OpenAI). Hiring managers receive structured insights weekly, highlighting top/weak traits, candidate scores, and actionable JD refinement tips. What This Template Does (Step-by-Step) ⚡ Manual Trigger – Starts workflow execution on demand. 📑 Candidate Data Fetch (Google Sheets – Hires Tracking) – Pulls candidate-level details like name, role, traits, start date, and retention status. 📑 Trait Summary Fetch (Google Sheets – Retention Summary) – Fetches aggregated trait-level retention statistics, including hires, stayed, left, retention %, and weight adjustments. 🔀 Merge Candidate + Trait Data – Combines both datasets into a unified stream for scoring. 🧮 Candidate Scoring & Data Normalization (Code Node) – Cleans and standardizes data. Builds a trait → weight map. Calculates each candidate’s Candidate_Score. Outputs normalized JSON. ✅ Data Validation (If Node) – Ensures both candidate and trait datasets are present. TRUE → continues to AI digest generation. FALSE → routes to error logging. ⚠️ Error Handling Logic (Google Sheets – Error Log) – Logs any failed or incomplete runs into a dedicated error sheet for auditing. 🧠 AI Processing Backend (Azure OpenAI) – Prepares candidate + trait data for GPT processing. 🤖 Retention Digest Generator (LLM Chain) – Uses GPT (gpt-4o-mini) to create a structured HTML Retention Digest, including: TL;DR summary Top Traits (positive retention) Weak Traits (negative retention) Candidate highlights (scores & retention status) 3 actionable JD refinement tips 📧 Email Delivery (Gmail) – Sends the digest directly to hiring managers as a styled HTML email with subject: Retention Analysis Digest – Weekly Update Prerequisites Google Sheets (Hires Tracking + Retention Summary + Error Log) Gmail API credentials Azure OpenAI access (gpt-4o-mini model) n8n instance (self-hosted or cloud) Key Benefits ✅ Automates retention analytics & reporting ✅ Provides AI-powered insights in structured HTML ✅ Improves hiring strategy with trait-based scoring ✅ Reduces manual effort in weekly retention reviews ✅ Ensures reliability with error handling & validation Perfect For HR & Recruitment teams monitoring post-hire retention Organizations optimizing job descriptions & hiring strategy Talent analytics teams needing automated, AI-driven insights Stakeholders requiring clear weekly digest emails
by Avkash Kakdiya
How it works This workflow automatically creates daily AI-generated videos for any niche. It generates a short script, converts it into a cinematic video prompt, and produces an 8-second video with Veo 3. The workflow waits for the video, downloads it, and sends it via Gmail with a ready-to-post social media description. You can customize the script prompt to match any industry or topic. Step-by-step 1. Trigger the workflow Daily Trigger** – Starts the workflow automatically every day. 2. Generate content Generate Script** – Creates a short, engaging script for your chosen niche. Generate Veo3 Prompt** – Turns the script into a cinematic video prompt for Veo 3. Social Media Description** – Writes an SEO-friendly description for LinkedIn, Instagram, and YouTube. 3. Generate the video Create Video** – Sends the prompt to Veo 3 for video generation. Wait for Video** – Pauses until video processing is complete. Status** – Checks whether the video is ready. If** – Loops until the video is successfully generated. 4. Download and share Download Video** – Fetches the completed video file. Send a message** – Emails the video with the social media description attached. Why use this? Create short, engaging videos in any niche automatically. Combine scriptwriting, video creation, and content delivery in one workflow. Save time by eliminating manual editing and waiting. Ensure consistent, professional social content for multiple platforms. Flexible for marketing, education, news, product updates, and more.
by Afareayo Soremekun
ChannelCrawler API to Google Slides Template This template shows how you can use the ChannelCrawler API alongside ChatGPT (or any LLM) to generate google slides using images and texts received from the API How it Works A user inputs the link to the Youtube channel(s) of their target creators The list is parsed by a python script, returning it in a format that can be ran in a loop The workflow iterates over each channel url The url is passed to the ChannelCrawler API, where it returns a json of the creators profile. The OpenAI node processes the description and content of the creators profile to create a summary We retrieve the google slides presentation using the get presentation node. We use the Google Slides API to duplicate an existing page and pull back the original page as it has a new revision ID We use the Google Slides API to change the image placeholder of the of the image Presentation Lastly we update other placeholders in with text from the ChannelCrawler and ChatGPT outputs How to Use From executing the workflow, a pop up form will come up where you can insert the Youtube Channel urls On submission, provided the prerequisites are set up - rest of the workflow will be triggered Use Cases You can create profiles on influencers and creators with extensive data points from the ChannelCrawler API and consistent summarisation from GPT Prerequisites ChannelCrawler Account - there's a great pay as you go options for access to the API OpenAI account - the you can access free Open AI credit if you are a first time n8n user! Check the credentials options in the node Google account (For slides) - You should have a google account or sign up for google with your non google email
by Rahul Joshi
Description This workflow automates Zendesk ticket escalation by creating ClickUp tasks for urgent cases and notifying the support team in Telegram. It ensures that high-priority tickets are instantly visible to the right team members, avoiding delays in resolution. What This Template Does (Step-by-Step) 🟢 Trigger (Manual Test or Later Zendesk Trigger) Currently uses a manual trigger (Execute Workflow) for testing. In production, this would start whenever a pending Zendesk ticket appears. 🎫 Fetch Zendesk Tickets Pulls all pending tickets assigned to a group. Sorts them by status and date. 🧹 Select Latest Ticket Sorts by created_at and keeps only the newest ticket. Outputs: id, subject, description, requester_id, created_at. 📧 Fetch Requester Email Retrieves requester details (name, email, timezone) from Zendesk Users API. 🔀 Merge Ticket & Requester Data Combines both streams: ticket info + requester info. Ensures the ClickUp task payload has everything it needs. 📝 Prepare ClickUp Task Payload Builds a structured task: Task Name: [Escalation] {Subject} (Ticket #ID) Description: Ticket + requester details + escalation message Priority: 3 (default, can be adjusted) Tags: zendesk, escalation 📂 Create ClickUp Task Pushes the structured task into ClickUp under the escalation list. Assigns it to a predefined team member. 📨 Format Telegram Alert Message Generates a concise but urgent message: Ticket subject + ID Requester name + email Direct ClickUp link Adds urgency formatting (🚨 Immediate Attention Required). 📢 Send Telegram Escalation Alert Posts the alert into the chosen Telegram chat/team. Ensures managers/stakeholders know instantly. Prerequisites Zendesk account + API credentials ClickUp account + API credentials Telegram bot token & chat ID n8n instance (cloud or self-hosted) Customization Ideas ⚡ Replace manual trigger with Zendesk “Ticket Created” trigger. 🎯 Add SLA-based conditions (e.g., escalate only if response > 4 hrs). 📊 Auto-assign ClickUp tasks by ticket category. 🔔 Add Slack/Email notification along with Telegram. 📂 Store escalation logs into Notion or Google Sheets. Key Benefits ✅ Zero delay in handling critical tickets ✅ Automatically creates ClickUp task + Telegram alert ✅ Reduces manual handoff between support → escalation team ✅ Keeps everyone aligned in real-time Perfect For 🎯 Support teams needing fast escalations 📈 SaaS companies managing large ticket volumes 🚀 Agencies ensuring VIP clients never wait
by Jitesh Dugar
Automated Influencer Campaign Management System A comprehensive n8n workflow template for streamlining influencer application processing with real-time social media data validation, intelligent scoring algorithms, and automated onboarding workflows. Who’s It For Marketing agencies managing high-volume influencer applications Brand marketing teams screening social media creators Influencer platforms automating creator onboarding Digital marketing consultants reducing manual workload E-commerce brands building creator partnerships Social media management companies scaling operations How It Works Capture influencer applications via Webhook (connected to forms/websites). Validate applicant emails using VerifiEmail to prevent fake submissions. Fetch real-time social data from Instagram (via Instagram120 API) and YouTube (via YouTube138 API). Calculate engagement scores using a weighted algorithm (Instagram 60% + YouTube 40%). Auto-approve qualified influencers based on follower count & engagement thresholds. Log approved applications in Google Sheets with complete metrics. Send personalized welcome emails with campaign information & next steps. Reject low-quality applications with detailed reasoning (for internal tracking). Generate scoring breakdown with platform-specific analytics & tier classification. Track application volume and approval rates for performance optimization. Offers: Real-time API integration, intelligent scoring, automated actions, scalable processing. 🛠️ How to Set Up Connect your application form to Webhook: POST → https://[your-n8n-url]/webhook/influencer-signup Sign up for RapidAPI and subscribe to Instagram120 + YouTube138 APIs. Get VerifiEmail API key (100 free verifications/month). Configure Gmail OAuth2 in Google Cloud Console for email automation. Create a Google Sheets database for approved influencer storage. Add credentials in n8n: RapidAPI, VerifiEmail, Gmail, Google Sheets. Customize scoring thresholds & email templates in Function nodes. Test with sample data: { "name": "Test Creator", "email": "test@gmail.com", "social_handles": { "instagram": "testuser", "youtube": "testchannel" }, "niche": "fitness", "rate_card": 500 } Requirements n8n instance** (cloud or self-hosted) API credentials**: RapidAPI (Instagram120 + YouTube138 APIs) VerifiEmail Gmail OAuth2 Google Sheets access Form/website integration** → sends webhook data Google Sheets** for database & reporting RapidAPI Integration Details Instagram120 API Pricing Plans:** Free: 1,000 requests/month Pro: 10,000 requests/month ($10/mo) Ultra: 100,000 requests/month ($50/mo) n8n Example:** { "method": "POST", "url": "https://instagram120.p.rapidapi.com/api/instagram/profile", "headers": { "X-RapidAPI-Host": "instagram120.p.rapidapi.com", "X-RapidAPI-Key": "YOUR_RAPIDAPI_KEY", "Content-Type": "application/json" }, "body": { "username": "{{ $('Data Sanitizer').item.json.social_handles.instagram }}" } } YouTube138 API Pricing Plans:** Free: 1,000 requests/month Pro: 10,000 requests/month ($15/mo) Ultra: 100,000 requests/month ($75/mo) n8n Example:** { "method": "GET", "url": "https://youtube138.p.rapidapi.com/channel/details", "headers": { "X-RapidAPI-Host": "youtube138.p.rapidapi.com", "X-RapidAPI-Key": "YOUR_RAPIDAPI_KEY" }, "queryParameters": { "id": "{{ $('Webhook').item.json.body.social_handles.youtube }}", "hl": "en", "gl": "US" } } Core Features Social Media Validation** Instagram follower counts, engagement, verification YouTube subscriber counts, channel stats Cross-platform scoring algorithm Fraud prevention via email validation Intelligent Scoring** Multi-tier classification (Nano, Micro, Macro, Mega) Engagement analysis per platform Customizable approval thresholds Automation Actions** Auto-approve/reject with reasoning Store results in Google Sheets Send onboarding emails Track performance stats Use Cases & Applications Marketing Agencies** → Process 100+ daily influencer applications automatically Brands** → Validate influencer metrics before partnerships Platforms** → Qualify creators for platform admission automatically E-commerce** → Build authentic influencer partnerships Key Benefits ✔️ Saves 80-90% processing costs ✔️ Cuts manual review time from 15 minutes → 30 seconds ✔️ Prevents fraud with real-time validation ✔️ Scales infinitely with no extra staffing Technical Specifications Execution time:** 30–45 sec per application Throughput:** 100+ applications/hour Success rate:** 95%+ valid applications Cost:** ~$0.05–$0.15 per application ROI & Cost Breakdown Manual:** $15–25/hour human review Automated:** $0.05–0.15/application Savings:** 80–90% at scale Break-even:** 50–100 apps/month Integration Example // Example website form submission fetch('https://your-n8n-instance.com/webhook/influencer-signup', { method: 'POST', headers: {'Content-Type': 'application/json'}, body: JSON.stringify(formData) }); Sample Application Data: { "name": "Sarah Johnson", "email": "sarah.fitness@gmail.com", "social_handles": { "instagram": "sarahfitlife", "youtube": "SarahFitnessJourney" }, "niche": "fitness", "country": "US", "rate_card": 750 } Installation Import workflow JSON file into n8n Add API credentials (RapidAPI, VerifiEmail, Gmail, Sheets) Configure Sheets with correct columns Customize scoring & emails Test with sample apps Activate workflow Disclaimers Requires paid RapidAPI plans for scale API rate limiting applies Data accuracy depends on APIs Ensure GDPR/CCPA compliance before production Always test before live deployment License This template is provided as-is for educational and commercial use. Users are responsible for ensuring compliance with laws, platform TOS, and data privacy rules.
by nobu
Title Create Google Calendar events from labeled Gmail emails using AI Description Who is it for? This template is for anyone who frequently receives unstructured event or task information via email and wants to quickly add it to their Google Calendar without manual data entry. It's perfect for busy professionals, personal productivity enthusiasts, and anyone looking to streamline their scheduling. What it does This workflow automates the process of creating Google Calendar events from emails you label in Gmail, using AI to parse the details. Triggers on Labeled Email: The workflow starts when a new email is given a specific label in Gmail (e.g., "Scheduled"). Parses Event with AI: The email's content is sent to Google Gemini to extract structured event data: title, start time, end time, location, and a description. Creates Calendar Event: Using the data extracted by the AI, a new event is automatically created in your Google Calendar. Sends Confirmation Email: A confirmation email is sent back to you, containing a summary of the created event and a direct link to edit it in Google Calendar. Requirements An active n8n instance. A Google account for Gmail and Google Calendar. Credentials for the Google Gemini API. How to set up Credentials: Configure your credentials for the 'Gmail Trigger', 'Google Gemini Chat Model', 'Create Google Calendar Event', and 'Send Confirmation Email' nodes. Gmail Trigger: Select the 'Gmail Trigger' node. In the 'Label Ids' field, choose the Gmail label you want to use to trigger the workflow (e.g., a label named Scheduled). Confirmation Email: Select the 'Send Confirmation Email' node. In the 'Send To' field, enter the email address where you want to receive the confirmation email. Activate Workflow: Save and activate the workflow. How to customize AI Prompt: You can modify the prompt in the 'Parse Event with AI' node to better suit your needs. For example, you can change the default timezone or add rules for how to handle recurring events. Email Content: Customize the subject and body of the confirmation email in the 'Send Confirmation Email' node. Calendar Options: In the 'Create Google Calendar Event' node, you can add more event details, such as attendees or reminders.
by Meak
Auto-Post Instagram Carousels from Google Sheets + Drive (Cloudinary + IG Graph) This workflow checks your Google Sheet for “Carousel” posts to do, pulls images from a Drive folder, uploads them to Cloudinary, creates an Instagram carousel, publishes it, and marks the row as “Processed”. Benefits Hands-off posting from a simple Google Sheet queue Pulls all images from a Drive folder for each carousel Uses Cloudinary for fast, reliable hosting Posts via Instagram Graph API (official) Updates your Sheet status to “Processed” after publish How It Works Schedule Trigger runs every few minutes. Get Execution for Carousel reads rows where Status = ToDo and Type = Carousel. Get image list loads all files from the Drive folder in that row. Download Image fetches each file from Drive. Upload to Cloudinary stores the image and returns a public URL. Setup for Instagram prepares access_token, ig_user_id, image_url, caption. Create Media Container (Image) creates an IG container for each image. Combine containers collects all container IDs. Create Media Container (Carousel) builds one carousel with the children IDs + caption. Publish Instagram Carousel publishes the carousel post. Update Execute sets Status = Processed for that ExecuteId in Sheets. Who Is This For Social media managers batching carousels Agencies posting client content on a schedule Creators who organize posts in Google Sheets Setup Google Sheets: set Spreadsheet and “Execute” tab (with ExecuteId, Folder, Expected content, Status, Type) Google Drive: put carousel images in the folder referenced by the row Cloudinary: set cloud name + upload_preset Instagram Graph: get ig_user_id and a valid access_token In n8n: paste tokens/IDs into the Set nodes and HTTP nodes as shown Tips Keep image order in Drive as you want it to appear (or sort before upload) Caption comes from the Sheet field Expected content Make sure the IG account is a Business/Creator account connected to a Facebook Page Use high-res images; Cloudinary will optimize delivery Add error alerts (Slack/Email) if a step fails ROI Save 2–4 hours/week on manual uploads Fewer posting mistakes (everything logged in Sheets) Scales easily to multiple brands and calendars Strategy Insights Add a “Schedule_at” column and delay publishing until that time Write back the IG post ID to Sheets for tracking Extend to cross-post (e.g., Facebook Page) with the same media containers Check Out My Channel For more practical automation workflows for content teams, check out my YouTube channel where I share the exact systems I use to run social posting at scale.
by PDF Vector
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Automated Academic Paper Monitoring Stay updated with the latest research in your field. This bot monitors multiple academic databases for new papers matching your interests and sends personalized alerts. Bot Features: Monitor keywords across multiple databases Filter by authors, journals, or institutions Daily/weekly digest emails Slack notifications for high-impact papers Automatic paper summarization Workflow Components: Schedule: Run daily/weekly checks Search: Query latest papers across databases Filter: Apply custom criteria Summarize: Generate paper summaries Notify: Send alerts via email/Slack Archive: Store papers for future reference Perfect For: Research groups tracking their field PhD students monitoring specific topics Labs following competitor publications
by Jitesh Dugar
Transform your order fulfillment process with complete invoice automation. This workflow automatically generates professional PDF invoices from Jotform orders and delivers them to customers while keeping organized records. What This Workflow Does ✅ Receives order data from Jotform Trigger ✅ Generates professional HTML invoice with your branding ✅ Converts to PDF using HTML to PDF conversion ✅ Saves invoice to Google Drive for record-keeping ✅ Emails PDF invoice to customer automatically Workflow Steps Jotform Trigger - Captures order data when a customer places an order Format Invoice Data - Prepares and structures line item data Generate HTML Invoice - Creates custom branded HTML invoice Generate PDF Invoice - Converts HTML to professional PDF format Download File PDF - Prepares PDF for distribution Save to Google Drive - Archives invoice for your records Email to Customer - Sends invoice PDF directly to customer's inbox Requirements Jotform account with order form set up Sign up for free here PDF generation API key (get yours at pdfmunk.com) Google Drive connection for storage Email service connection (Gmail, SMTP, etc.) Benefits Save time** - Eliminate manual invoice creation Professional branding** - Customize invoice template to match your brand Organized records** - All invoices automatically saved to Google Drive Better customer experience** - Instant invoice delivery after order placement Scalable** - Handles unlimited orders without additional work
by Abdul Mir
Overview Impress your leads with ultra-personalized “thank you” emails that look hand-written — sent automatically seconds after they submit your intake form. This workflow instantly scrapes the prospect's website, extracts meaningful copy, and uses AI to write a custom thank-you message referencing something specific from their site. It gives the impression you immediately reviewed their business and crafted a thoughtful reply — without lifting a finger. Who’s it for Agencies and consultants using intake forms Freelancers booking discovery calls B2B businesses that want high-touch first impressions Sales teams automating initial follow-ups How it works Triggered when a form (e.g. Tally, Typeform) is submitted Scrapes the website URL provided in the form Converts HTML to Markdown and extracts plain copy Uses AI to write a personalized thank-you message referencing the site Waits briefly to simulate real typing delay Sends the message via Gmail (or any email provider) Example use case > Prospect submits a form with their website: coolstartup.ai > > 30 seconds later, they receive: > > “Thanks for reaching out! I just checked out Cool Startup’s homepage — love the clean UX and mission around AI for teams. Looking forward to diving into how we might collaborate!” How to set up Connect your form tool (e.g. Tally or Typeform) Connect Gmail or another email provider Customize the AI prompt to match your tone Set the wait time (e.g. 30 seconds) for a realistic delay Update your website scraping logic if needed Requirements Form tool with webhook support OpenAI (or other LLM) credentials Email sending integration (Gmail, Mailgun, Postmark, etc.) How to customize Edit the email tone (casual, formal, funny, etc.) Add CRM integration to log form submission and response Trigger additional workflows like lead scoring or Slack alerts Add fallback logic if the website doesn’t scrape cleanly
by WeblineIndia
YouTube Transcription, Summarization & Translation to Google Docs This workflow automates the end-to-end process of converting YouTube videos into structured, multilingual written content. It transcribes the video's speech, optionally summarizes it, translates it into the chosen language and stores the result in a well-formatted Google Doc—ready for review, sharing or publication. Who’s It For Content creators and bloggers repurposing video content. Educators and researchers converting lectures into readable notes. Marketing teams localizing video material for international audiences. Students summarizing and translating study material. YouTube viewers who want written notes or blog-ready formats. How It Works A Webhook triggers the flow with inputs: youtube_url, language and enable_summary. A Code node formats these inputs into videoId, originalUrl, language and enable_summary. An HTTP Request node sends the video to Supadata API for full transcription. Another Code node combines all transcript segments into one body of text. The Basic LLM Chain node uses the Google Gemini Chat Model to summarize and translate the transcript if requested. A Google Docs node creates a new document with a title based on videoId and language. A final Google Docs node appends the processed summary and translation into the created document. How to Set Up Webhook Input: Send a POST request with three fields: youtube_url, language, enable_summary. Configure Supadata API: Add the HTTP URL and Authorization Header for transcription. Set up Gemini Chat Model: Use Google Vertex AI/Gemini integration in the Basic LLM Chain node. Create Google Docs Credentials: Connect your Google account using OAuth2. Document Naming Logic: You may adjust document titles using expressions (e.g., {{ videoId }} - {{ language }}). Requirements Supadata API key (or any video-to-text API). Google account with Google Docs access. Google Gemini access via n8n’s LLM integration. n8n Cloud or self-hosted instance. Basic understanding of webhook setup (or a form frontend). How to Customize Change LLM model:** Swap Gemini with GPT-4 or Claude in the LLM Chain node. Summarization toggle:** Use the enable_summary flag to control verbosity. Document layout:** Customize headings, font styles and content sections in Google Docs. Multiple languages:** Extend the workflow to translate into multiple languages and generate one document per language. Sharing options:** Add Gmail or Slack nodes to notify users once the document is generated. Add‑ons Notion Export:** Send the document summary directly into Notion using the Notion node. Slack Notification:** Notify your team with a link to the Google Doc using the Slack node. Google Sheets Logging:** Log video URLs, timestamps, and language used for auditing. n8n Forms Integration:** Allow users to submit video URLs and language via a hosted n8n form. Use Case Examples Repurposing Videos into Blogs:** Automatically convert YouTube podcasts into multilingual blog posts. Educational Notes:** Extract and translate lecture content into shareable study documents. International Marketing Teams:** Summarize and localize product explainer videos for different countries. Transcription Library:** Create a searchable database of translated transcripts from niche educational YouTube channels. Common Troubleshooting | Issue | Possible Cause | Solution | | ------------------------------- | ------------------------------------------ | ---------------------------------------------------------- | | Webhook not triggering | Incorrect webhook URL or POST format | Double-check payload and content-type (application/json) | | Transcription API fails | Invalid video ID or API key | Validate YouTube URL and Supadata API access | | Empty translation/summarization | Transcript was empty or prompt was weak | Ensure the video contains spoken content and refine prompt | | Google Doc not created | OAuth2 credentials not authorized properly | Reconnect Google Docs credentials in n8n | | Gemini LLM Chain fails | Model misconfigured or request malformed | Verify your model selection and payload structure | Need Help? Need help getting this set up or customizing it for your workflow? ✅ We can help you: Set up transcription and translation APIs Modify the summarization prompt Customize document layouts or automate sharing 👉 Contact WeblineIndia's automation experts !
by Oneclick AI Squad
Automate your payroll process with this efficient workflow. Triggered monthly on the 28th, it fetches employee data from a Google Sheet, uses AI to calculate net salaries with tax and deductions, structures payslip data, generates PDF payslips, and notifies employees via email while alerting HR on Slack. Ensure accurate payroll distribution with minimal manual effort. 💰📧 Good to Know The workflow runs on the 28th of each month to align with typical payroll cycles. Ensure AI credentials and Google Sheet access are configured for smooth operation. How It Works The Monthly Payroll Trigger initiates the process on the 28th. Gets Employee Data** by reading salary and deduction details from a Google Sheet. AI Calculates Salary** applies tax and deduction rules to compute net pay. Formats Payslip Data** prepares structured data for distribution. Generates PDF Payslip** creates individual payslip documents. Logs payroll data to a Google Sheet for records. Branches to: Sends Email Payslip to Employee with the PDF attachment. Notifies HR on Slack with payroll completion details. How to Use Use the manual trigger for testing, then set a monthly cron (e.g., 0 0 28 * *) for live runs on the 28th. Adjust tax and deduction rules in the AI node to match local regulations. Requirements GOOGLE_SHEET_ID**: Your Google Sheet ID (structured as below) Credentials Needed:** Google Sheets OAuth2 Gmail API Key OpenAI API Key (or similar) Slack Bot Token (with chat:write permissions) Customize:** • Employee data columns (e.g., ID, Name, Base Salary, Deductions) • Tax and deduction formulas • Email subject and Slack message format Google Sheet Structure: Create a sheet with columns: Employee ID Name Base Salary Deductions Net Salary Payslip Status Updated At Customizing This Workflow Adapt for bi-weekly payroll by adjusting the trigger to the 14th and 28th. Integrate with HR systems like BambooHR for real-time employee updates.