{"product_id":"spawn-recurring-notion-tasks-via-n8n-data-tables-slack","title":"Spawn Recurring Notion Tasks via n8n Data Tables + Slack","description":"\u003ch3\u003eSpawn daily Notion tasks from recurrence rules—then notify your team in Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reads recurring schedules from a \u003cstrong\u003eNotion\u003c\/strong\u003e database every day, creates the due \u003cstrong\u003eNotion task\u003c\/strong\u003e pages in your tasks database, prevents duplicate spawns with an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e ledger, and posts a concise summary to \u003cstrong\u003eSlack\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 06:00\u003c\/strong\u003e using the n8n Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads recurrence rules\u003c\/strong\u003e by reading all pages from a Notion “recurrence rules” database.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvaluates which tasks are due\u003c\/strong\u003e by checking each rule against today’s date in a configurable timezone (for a correct day boundary).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAvoids duplicates\u003c\/strong\u003e by checking the \u003cstrong\u003en8n Data Table\u003c\/strong\u003e ledger named \u003ccode\u003ecadence_last_spawned\u003c\/code\u003e. If a rule already spawned today, it’s skipped.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates due task pages\u003c\/strong\u003e in your Notion “tasks” database and sets the task page \u003cstrong\u003eDue\u003c\/strong\u003e date to today.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the ledger\u003c\/strong\u003e by upserting each rule’s \u003ccode\u003elast_spawned_on\u003c\/code\u003e value after a spawn.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a one-line summary\u003c\/strong\u003e of the created tasks to a configured Slack channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn recurring “maintenance” or “checklist” schedules into daily Notion tasks for your ops team.\u003c\/li\u003e\n  \u003cli\u003eUse Notion recurrence settings (frequency, weekdays, day-of-month, nth weekday) to drive task creation without manual work.\u003c\/li\u003e\n  \u003cli\u003eKeep stakeholders informed via Slack whenever new due tasks are generated from the rules database.\u003c\/li\u003e\n  \u003cli\u003eEnsure idempotency—so reruns or scheduling hiccups don’t create duplicate task pages.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e Schedule Trigger, Notion (rules read + tasks create), Code (rule evaluation + timezone logic), Data Table (duplicate prevention ledger), Slack (summary posting), Sticky Note (workflow documentation).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired Notion properties:\u003c\/strong\u003e rules include \u003ccode\u003erule_id\u003c\/code\u003e, \u003ccode\u003etask_title\u003c\/code\u003e, \u003ccode\u003efrequency\u003c\/code\u003e, \u003ccode\u003einterval_days\u003c\/code\u003e, \u003ccode\u003eanchor_date\u003c\/code\u003e, \u003ccode\u003eweekdays\u003c\/code\u003e, \u003ccode\u003eday_of_month\u003c\/code\u003e, \u003ccode\u003enth\u003c\/code\u003e, \u003ccode\u003enth_weekday\u003c\/code\u003e, \u003ccode\u003eactive\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTasks database requirement:\u003c\/strong\u003e a date property named \u003cstrong\u003eDue\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Data Table requirement:\u003c\/strong\u003e \u003ccode\u003ecadence_last_spawned\u003c\/code\u003e with columns \u003ccode\u003erule_id\u003c\/code\u003e, \u003ccode\u003elast_spawned_on\u003c\/code\u003e, \u003ccode\u003erule_title\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738511696051,"sku":"N8N-17549","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/axWBpCCF5bsp7YceZbj4M_oC1NWtqe.png?v=1785229646","url":"https:\/\/buyflowscripts.com\/products\/spawn-recurring-notion-tasks-via-n8n-data-tables-slack","provider":"N8N Commerce","version":"1.0","type":"link"}