{"product_id":"reactivate-n8n-workflows-nightly-via-data-table-rest-api","title":"Reactivate n8n Workflows Nightly via Data Table \u0026 REST API","description":"\u003ch3\u003eRe-activate n8n workflows every morning—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow runs nightly to restore any n8n workflows that were temporarily disabled for maintenance. It reads workflow IDs from an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e, reactivates each one via the \u003cstrong\u003en8n REST API\u003c\/strong\u003e, and then clears the log so the next maintenance cycle starts fresh.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes daily at \u003cstrong\u003e08:45\u003c\/strong\u003e using the Schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds REST API requests:\u003c\/strong\u003e sets the \u003cstrong\u003en8n instance base URL\u003c\/strong\u003e used to construct API calls.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads maintenance log entries:\u003c\/strong\u003e loads all rows from a selected \u003cstrong\u003en8n Data Table\u003c\/strong\u003e that contains a \u003cstrong\u003eworkflow_id\u003c\/strong\u003e column (and optionally other metadata).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReactivates workflows:\u003c\/strong\u003e iterates through the logged workflow IDs and calls the \u003cstrong\u003en8n REST API\u003c\/strong\u003e (via an HTTP Request node) to activate each workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResets the maintenance log:\u003c\/strong\u003e after processing completes, deletes all rows from the same Data Table to prepare for the next cycle.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS ops \u0026amp; maintenance windows:\u003c\/strong\u003e safely disable workflows during updates, then automatically reactivate them the next morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReduce manual recovery:\u003c\/strong\u003e eliminate the need to manually track which workflows were turned off and turn them back on.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMulti-workflow maintenance:\u003c\/strong\u003e restore dozens of workflows using a centralized Data Table log.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e Schedule (daily at 08:45)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic nodes:\u003c\/strong\u003e if, set, split out, Data Table, HTTP Request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI integration:\u003c\/strong\u003e n8n REST API using an \u003cstrong\u003en8n API credential\u003c\/strong\u003e configured under Settings → n8n API\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData integration:\u003c\/strong\u003e reads workflow IDs from an n8n Data Table and deletes rows afterward\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e Ensure the companion “Maintenance ON” workflow writes deactivated workflow IDs into the same Data Table and does not disable this reactivation workflow.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46154098245811,"sku":"N8N-20045","price":77.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kJM-3Mw7BbakIWIclFxxU_I17QRu4K.png?v=1790933671","url":"https:\/\/buyflowscripts.com\/products\/reactivate-n8n-workflows-nightly-via-data-table-rest-api","provider":"N8N Commerce","version":"1.0","type":"link"}