{"product_id":"validate-google-drive-scheduled-post-queue-in-n8n","title":"Validate Google Drive Scheduled Post Queue in n8n","description":"\u003ch3\u003eQuickly audit your Google Drive “scheduled post” queue before publishing\u003c\/h3\u003e\n\u003cp\u003eThis n8n manual workflow scans your Google Drive scheduled-post folders, validates their folder names, scheduled times, and required contents (like \u003cem\u003etweet.txt\u003c\/em\u003e and images), then produces a clear human-readable report plus structured JSON results—so you catch errors early and avoid broken or duplicate scheduled posts.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns as a manual validation pass\u003c\/strong\u003e to check the queue on demand.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads validation settings\u003c\/strong\u003e including image minimum\/maximum counts and supported file extensions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLists all scheduled-post folders\u003c\/strong\u003e under a selected Google Drive root folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates folder naming format\u003c\/strong\u003e in \u003ccode\u003eyyyy-MM-dd_HHmm__label\u003c\/code\u003e:\n    \u003cul\u003e\n      \u003cli\u003eConfirms the date\/time is real and convertible\u003c\/li\u003e\n      \u003cli\u003eConverts to UTC using your \u003ccode\u003eutcOffsetMinutes\u003c\/code\u003e\n\u003c\/li\u003e\n      \u003cli\u003eChecks whether the scheduled time is in the future\u003c\/li\u003e\n      \u003cli\u003eFlags \u003cstrong\u003eduplicate scheduled times\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks folder contents\u003c\/strong\u003e by listing files in each scheduled-post folder and enforcing:\n    \u003cul\u003e\n      \u003cli\u003eExactly one \u003ccode\u003etweet.txt\u003c\/code\u003e\n\u003c\/li\u003e\n      \u003cli\u003eConfigured number of images and valid extensions\u003c\/li\u003e\n      \u003cli\u003eFailure if the folder contains nested folders or “already processed” marker files\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutputs results\u003c\/strong\u003e: a summary, a readable text report, and a \u003cstrong\u003eJSON results array\u003c\/strong\u003e marking folders as valid, warning, or invalid.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBefore an automation publishes queued items, validate that every scheduled post folder is correctly named and complete.\u003c\/li\u003e\n  \u003cli\u003eDetect timezone mistakes by adjusting \u003ccode\u003eutcOffsetMinutes\u003c\/code\u003e and confirming future scheduled times.\u003c\/li\u003e\n  \u003cli\u003eSpot configuration issues—wrong image counts, unsupported extensions, missing \u003ccode\u003etweet.txt\u003c\/code\u003e, or accidental duplicates.\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: Manual Trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Drive\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic\u003c\/strong\u003e: set, code, sticky note, split in batches\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInputs\u003c\/strong\u003e: Google Drive root folder selection + validation limits (\u003ccode\u003eutcOffsetMinutes\u003c\/code\u003e, \u003ccode\u003eminImages\u003c\/code\u003e, \u003ccode\u003emaxImages\u003c\/code\u003e, \u003ccode\u003esupportedExtensions\u003c\/code\u003e)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45760999981235,"sku":"N8N-17846","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ehH83WvlOFYRyCggEJHTe_zhn6cHyF.png?v=1785920540","url":"https:\/\/buyflowscripts.com\/products\/validate-google-drive-scheduled-post-queue-in-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}