{"product_id":"n8n-automation-ctd-dossier-folders-gemini-email-drafts","title":"n8n Automation: CTD Dossier Folders + Gemini Email Drafts","description":"\u003ch3\u003eAutomate CTD dossier folder creation and Gemini-assisted email drafting—fully inside n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation watches your Google Sheets CTD dossier intake, builds a structured CTD folder set in Google Drive, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to draft module assignment emails for human review in Gmail, and sends scheduled due-date reminders until tasks are completed.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on new intake rows:\u003c\/strong\u003e When a new row is added to your Google Sheets intake form, the workflow starts the CTD dossier processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates and invalid requests:\u003c\/strong\u003e It reads the existing registrations, identifies rows matching the same product and dosage form (or missing required fields), and deletes duplicate\/invalid entries from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates Google Drive folder structure:\u003c\/strong\u003e It makes a CTD dossier root folder in Google Drive and prepares a module list with their checklist filenames.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes module checklists:\u003c\/strong\u003e For each module, it creates a subfolder, downloads the module checklist via HTTP, uploads the checklist file to the module folder, and sends an \u003cstrong\u003eerror alert via Gmail\u003c\/strong\u003e if the upload fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts assignment emails with Google Gemini:\u003c\/strong\u003e Using Google Gemini (with a Google Sheets lookup tool), it finds the module owner and drafts an \u003cstrong\u003eHTML assignment email\u003c\/strong\u003e including folder links and a due date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHuman approval workflow:\u003c\/strong\u003e The drafted email is sent to a reviewer via Gmail for approval, then the module owner receives the checklist attachment, and a tracking row is appended to a Google Sheets tracking sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled reminders:\u003c\/strong\u003e On a schedule, it checks tracking entries, calculates days remaining to each due date, and sends reminder emails via Gmail for modules that are due soon or overdue.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCentralizing CTD intake from Google Sheets and automatically generating per-module Drive folders.\u003c\/li\u003e\n  \u003cli\u003eReducing manual effort for assigning module owners and distributing checklists with correct due dates.\u003c\/li\u003e\n  \u003cli\u003eEnsuring follow-ups happen automatically as deadlines approach via Gmail reminder emails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, Google Drive, Gmail, Google Gemini, HTTP download\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e if, set, code, filter, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore automation behavior:\u003c\/strong\u003e row validation + Drive folder creation + Gemini email drafting + approvals + tracking + scheduled reminders\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46289234559155,"sku":"N8N-21607","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/rhmSSmtFgBfL4i1d0RosT_2TfrG6mX.png?v=1793006624","url":"https:\/\/buyflowscripts.com\/products\/n8n-automation-ctd-dossier-folders-gemini-email-drafts","provider":"N8N Commerce","version":"1.0","type":"link"}