{"product_id":"n8n-loan-tracker-alerts-google-sheets-slack-gmail-gemini","title":"n8n Loan Tracker Alerts: Google Sheets + Slack + Gmail + Gemini","description":"\u003ch3\u003eTurn loan-tracker updates into real-time Slack alerts, applicant emails, and Gemini-written digests\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your Google Sheets loan application tracker, detects status changes and SLA breaches, notifies your team in Slack, escalates high-value loans via Gmail, and uses Google Gemini to generate applicant and management email updates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every 30 minutes\u003c\/strong\u003e and reads your \u003cstrong\u003e“Application Tracker”\u003c\/strong\u003e Google Sheet.\u003c\/li\u003e\n  \u003cli\u003eSelects applications whose \u003cstrong\u003ecurrent status changed\u003c\/strong\u003e since the last notification, while flagging:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eSLA breaches\u003c\/strong\u003e when status is \u003cstrong\u003eunder_review\u003c\/strong\u003e for \u003cstrong\u003emore than 3 days\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eHigh-value loans\u003c\/strong\u003e when amount is \u003cstrong\u003eover 2,000,000\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf an SLA alert is due, it \u003cstrong\u003eposts to Slack\u003c\/strong\u003e and updates the tracker row timestamp.\u003c\/li\u003e\n  \u003cli\u003eIt then \u003cstrong\u003eescalates high-value applications\u003c\/strong\u003e to a manager using \u003cstrong\u003eGmail\u003c\/strong\u003e, alongside remaining changed applications.\u003c\/li\u003e\n  \u003cli\u003eFor each changed application, it uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate a \u003cstrong\u003eshort, status-specific email body\u003c\/strong\u003e and sends it to the applicant via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf an applicant email fails, the workflow \u003cstrong\u003ewaits 5 minutes and retries up to three times\u003c\/strong\u003e; after that, it appends the failure details to the \u003cstrong\u003e“Log Failed Email to Sheet”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003eAfter a successful applicant email, it updates the row in Google Sheets (including \u003cstrong\u003elast_notified_status\u003c\/strong\u003e and \u003cstrong\u003elast_updated\u003c\/strong\u003e), then moves to the next application.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns at 6 PM every weekday\u003c\/strong\u003e to read all rows, aggregate pipeline counts and SLA breaches, draft a \u003cstrong\u003eGemini management digest\u003c\/strong\u003e, and email it to the manager via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNotify loan operations immediately in \u003cstrong\u003eSlack\u003c\/strong\u003e when \u003cstrong\u003eSLA\u003c\/strong\u003e thresholds are breached.\u003c\/li\u003e\n  \u003cli\u003eAutomatically escalate \u003cstrong\u003ehigh-value\u003c\/strong\u003e loan applications to decision-makers.\u003c\/li\u003e\n  \u003cli\u003eSend applicants timely, consistent updates—without manual drafting—using \u003cstrong\u003eGemini\u003c\/strong\u003e-generated email content.\u003c\/li\u003e\n  \u003cli\u003eSend a weekday \u003cstrong\u003emanagement digest\u003c\/strong\u003e summarizing pipeline and SLA risks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, Slack, Gmail, Google Gemini\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic\/nodes:\u003c\/strong\u003e if, set, code, wait, merge (including retry handling and updates to tracker fields)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46159504146611,"sku":"N8N-20376","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xo680hrSowyVqsYsIjbPN_C5mb4OoN.png?v=1791105051","url":"https:\/\/buyflowscripts.com\/products\/n8n-loan-tracker-alerts-google-sheets-slack-gmail-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}