Track loan applications and send SLA alerts with Sheets, Gmail, Slack and Gemini

Quick overview This workflow monitors a Google Sheets loan application tracker, alerts the team in Slack for SLA breaches, escalates high-value loans by Gmail, sends Gemini-generated status update emails to applicants, and emails a Gemini-written daily management digest on weekdays. How it works 1. Runs every 30 minutes, reads the “Application Tracker” Google Sheet, and selects applications whose current status changed since the last notification while flagging SLA breaches (underreview for more than 3 days) and high-value loans (over 2,000,000). 2. If an SLA alert is due, posts an SLA breach message to a Slack channel and updates the tracker row’s timestamp. 3. Combines the remaining changed applications and escalates any high-value applications to a manager via Gmail. 4. For each changed application, uses Google Gemini to generate a short, status-specific email body and sends it to the applicant via Gmail. 5. If an applicant email send fails, waits 5 minutes and retries up to three times, then appends the failure details to a Google Sheets “Log Failed Email to Sheet” tab. 6. After a successful applicant email, updates the application row in Google Sheets (including lastnotifiedstatus and lastupdated) and continues processing the next application. 7. Runs at 6 PM every weekday, reads all tracker rows, aggregates pipeline counts and SLA breaches, uses Google Gemini to draft a management digest, and emails it to the manager via Gmail. Setup 1. Connect Google Sheets credentials and update the spreadsheet ID and sheet tabs for “Application Tracker” and “Log Failed Email to Sheet.” 2. Connect Gmail credentials and set an n8n variable named MANAGEREMAIL for manager escalations and daily reports. 3. Connect Slack OAuth2 credentials, ensure the target channel (for example, loan-alerts) exists, and update the channel selection if needed. 4. Connect a Google Gemini (PaLM/AI Studio) API credential for both applicant emails and the daily management digest. 5. Ensure your tracker sheet includes the fields used by the workflow (for example applicationid, applicantname, applicantemail, loantype, loanamount, currentstatus, lastnotifiedstatus, lastupdated, and lastslaalertsent if you want daily SLA throttling). 6. Adjust the SLA window (3 days) and high-value threshold (2,000,000) in the workflow code if your policy differs. Additional info Use Case Examples 1. Home Loan Processing at a Bank Branch A bank branch managing home loan applications across multiple stages can use this workflow to automatically notify applicants every time their file moves from submitted to docsverified to underreview. The loan officer no longer needs to send individual status emails, and the branch manager receives a daily pipeline digest every evening without requesting a manual report. 2. NBFC Personal Loan Operations A non-banking financial company handling high volumes of personal loan applications can configure the ₹2,000,000 threshold to flag large-ticket applications for senior underwriter review. The Slack alert ensures the loan-alerts channel is immediately notified when any file has sat in review too long, keeping the operations team responsive without micromanagement. 3. Auto Financing Company Workflow An auto financing team can track applications from submission through final approval, with each status change triggering a warm, professionally worded applicant email customized to the loan type and amount. The retry logic ensures email delivery is resilient even during temporary Gmail outages. 4. Mortgage Broker Application Management A mortgage broker managing applications across multiple lenders can maintain a single Google Sheets tracker and use this workflow to keep applicants informed at every stage, while the manager receives daily summaries of the entire pipeline without needing direct access to the spreadsheet. 5. Microfinance or Rural Lending Operations A microfinance institution serving rural applicants can use the workflow to automate communica