{"product_id":"n8n-workflow-google-sheets-doc-reminders-via-openai-gmail","title":"n8n Workflow: Google Sheets Doc Reminders via OpenAI + Gmail","description":"\u003ch3\u003eAutomate Google Sheets doc reminders—drafted by OpenAI and sent via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your Google Sheets “Requests” list every weekday morning, generates reminder emails with \u003cstrong\u003eOpenAI\u003c\/strong\u003e in your preferred tone, sends them through \u003cstrong\u003eGmail\u003c\/strong\u003e, and then updates each row with the latest “Last sent” date and “Reminders” count.\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 triggers every weekday at \u003cstrong\u003e8am\u003c\/strong\u003e using an n8n schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads open requests:\u003c\/strong\u003e loads rows from the Google Sheets \u003cstrong\u003e“Requests”\u003c\/strong\u003e tab where \u003cstrong\u003eStatus = Open\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates reminder timing:\u003c\/strong\u003e determines how many reminders have already been sent, how many days have passed since the last email, and whether the next message should be a \u003cem\u003efirst request\u003c\/em\u003e, \u003cem\u003ereminder\u003c\/em\u003e, or \u003cem\u003efinal reminder\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnforces your policy:\u003c\/strong\u003e if enough time has passed and the reminder limit is not exceeded, it proceeds.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates email content with OpenAI:\u003c\/strong\u003e creates a short email subject and body tailored to the client and document.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Gmail:\u003c\/strong\u003e delivers the reminder to the client, using your configured \u003cstrong\u003ereply-to\u003c\/strong\u003e address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets:\u003c\/strong\u003e writes today’s date to \u003cstrong\u003eLast sent\u003c\/strong\u003e and increments \u003cstrong\u003eReminders\u003c\/strong\u003e for that row.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend consistent follow-ups for \u003cstrong\u003edocument requests\u003c\/strong\u003e tracked in Google Sheets—without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eMaintain a controlled reminder cadence (days between reminders + max reminders) for client compliance.\u003c\/li\u003e\n  \u003cli\u003eStandardize messaging tone while still personalizing subject\/body per \u003cstrong\u003eClient\u003c\/strong\u003e and \u003cstrong\u003eDocument\u003c\/strong\u003e.\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 (weekdays at 8am)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (reads\/writes “Requests” tab: Status, Last sent, Reminders)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e (drafts reminder subject + body)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (sends email; uses configured reply-to)\u003c\/li\u003e\n  \u003cli\u003eLogic nodes including \u003cstrong\u003eif\u003c\/strong\u003e and \u003cstrong\u003eset\u003c\/strong\u003e (for reminder decisioning and payload setup)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky Note\u003c\/strong\u003e (workflow documentation)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup required:\u003c\/strong\u003e add Google Sheets credentials and spreadsheet ID, connect Gmail credentials and reply-to, and configure an OpenAI credential. Optionally adjust \u003cem\u003etone\u003c\/em\u003e, \u003cem\u003edaysBetweenReminders\u003c\/em\u003e, and \u003cem\u003emaxReminders\u003c\/em\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46160853041331,"sku":"N8N-20400","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4odvOwyXeEunTgf8x78y0_uJdFNaYE.png?v=1791191609","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-doc-reminders-via-openai-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}