{"product_id":"freee-invoices-overdue-summary-with-gemini-slack-gmail-n8n","title":"freee Invoices Overdue Summary with Gemini, Slack \u0026 Gmail (n8n)","description":"\u003ch3\u003eGet an instant, prioritized view of overdue freee invoices—sent to Slack, logged to Google Sheets, and emailed via Gmail (with Gemini)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your \u003cstrong\u003efreee Invoices\u003c\/strong\u003e every morning, ranks unsettled invoices by how overdue they are, and generates a concise summary and recommended next action using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e. The result is then delivered to your team in \u003cstrong\u003eSlack\u003c\/strong\u003e, recorded in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emailed through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 9:00 AM\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003eCalls the \u003cstrong\u003efreee Invoices API\u003c\/strong\u003e to fetch all \u003cstrong\u003eunsettled invoices\u003c\/strong\u003e for your configured \u003cstrong\u003efreee company_id\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates days overdue\u003c\/strong\u003e for each invoice, sorts them by urgency, and prepares totals and counts.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e to generate a \u003cstrong\u003eshort plain-text summary\u003c\/strong\u003e including a recommended next action based on the ranked list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the summary\u003c\/strong\u003e to a specified \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tab as a historical log.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts the same summary to Slack\u003c\/strong\u003e via an \u003cstrong\u003eincoming webhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the summary\u003c\/strong\u003e to your configured accounting contact using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAccounting teams who want \u003cstrong\u003edaily overdue invoice monitoring\u003c\/strong\u003e without manual checking.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking receivables and needing a \u003cstrong\u003eprioritized escalation\u003c\/strong\u003e workflow.\u003c\/li\u003e\n  \u003cli\u003en8n users\/automation engineers creating an \u003cstrong\u003eend-to-end invoice status reporting\u003c\/strong\u003e pipeline across tools.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003efreee Invoices API\u003c\/strong\u003e (OAuth2): fetch unsettled invoices and use \u003cem\u003ecompany_id\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (PaLM): generate a concise summary and next action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2): append output to a configured spreadsheet ID and tab name.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack incoming webhook\u003c\/strong\u003e: post the summary to a target channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth2): email escalation to the configured address.\u003c\/li\u003e\n  \u003cli\u003eUses n8n nodes including \u003cstrong\u003ehttp request\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egoogle sheets\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, and supporting nodes (e.g., \u003cstrong\u003eset\u003c\/strong\u003e and notes).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45949999546547,"sku":"N8N-19177","price":33.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/we_g_8P29sbs3oKdtRhPj_y0kAN0AP.png?v=1788512803","url":"https:\/\/buyflowscripts.com\/products\/freee-invoices-overdue-summary-with-gemini-slack-gmail-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}