{"product_id":"daily-stale-approvals-digest-with-inistate-email-n8n","title":"Daily Stale Approvals Digest with Inistate + Email (n8n)","description":"\u003ch3\u003eKeep approval backlogs under control with a Daily Stale Approvals Digest\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every morning at \u003cstrong\u003e9:00\u003c\/strong\u003e to detect \u003cstrong\u003eInistate\u003c\/strong\u003e entries stuck in a specific approval state for longer than a set number of days, then emails you an \u003cstrong\u003eHTML digest\u003c\/strong\u003e via SMTP—so stale approvals don’t quietly linger.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules daily\u003c\/strong\u003e using a Schedule Trigger (runs every morning at \u003cstrong\u003e9:00\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads configuration\u003c\/strong\u003e values for:\n    \u003cul\u003e\n      \u003cli\u003ethe exact \u003cstrong\u003eInistate approval state\u003c\/strong\u003e name\u003c\/li\u003e\n      \u003cli\u003ethe \u003cstrong\u003estale-day threshold\u003c\/strong\u003e (how many days before an item is considered stale)\u003c\/li\u003e\n      \u003cli\u003eemail \u003cstrong\u003erecipients\u003c\/strong\u003e and the \u003cstrong\u003efrom address\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries Inistate\u003c\/strong\u003e for entries currently in the configured approval state and not updated since the calculated cutoff date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates results\u003c\/strong\u003e into a single list of stale items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an email\u003c\/strong\u003e with:\n    \u003cul\u003e\n      \u003cli\u003esubject line for the digest\u003c\/li\u003e\n      \u003cli\u003ean \u003cstrong\u003eHTML table\u003c\/strong\u003e summarizing each entry (ID, last updated, updated by, and assignees)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the digest via SMTP\u003c\/strong\u003e to the configured recipients.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOperations teams monitoring approvals that should move forward but may be stalled in a specific Inistate state.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators needing daily visibility into stale workflow items without manually checking Inistate.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing governance: consistent reporting for approvals past an SLA threshold.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e: runs every day at \u003cstrong\u003e9:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInistate integration\u003c\/strong\u003e: \u003ccode\u003en8n-nodes-inistateinistate\u003c\/code\u003e to query entries by workspace\/module and approval state.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData handling\u003c\/strong\u003e: \u003ccode\u003eset\u003c\/code\u003e and \u003ccode\u003eaggregate\u003c\/code\u003e to prepare the stale cutoff and compile the digest.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery\u003c\/strong\u003e: HTML digest sent using \u003cstrong\u003eemail send (SMTP)\u003c\/strong\u003e with an SMTP email credential.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional notes\u003c\/strong\u003e: \u003ccode\u003esticky note\u003c\/code\u003e for workflow documentation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eSetup reminder:\u003c\/em\u003e add an Inistate credential, configure the target state and stale threshold, then verify your SMTP server allows the chosen \u003cstrong\u003efrom address\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46160845078707,"sku":"N8N-20419","price":67.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/idjkwGKtB7Vbo09oMfDsf_UoVFofXc.png?v=1791191142","url":"https:\/\/buyflowscripts.com\/products\/daily-stale-approvals-digest-with-inistate-email-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}