{"product_id":"n8n-workflow-google-sheets-gmail-drafts-for-event-feedback","title":"n8n Workflow: Google Sheets → Gmail Drafts for Event Feedback","description":"\u003ch3\u003eAutomatically generate personalized Gmail drafts to collect missing event feedback\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your event participants from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, finds the people missing a “Food pref” value, creates a unique ID for each, and then generates \u003cstrong\u003epersonalized Gmail drafts\u003c\/strong\u003e containing a \u003cstrong\u003epre-filled Google Forms link\u003c\/strong\u003e to capture their feedback.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual trigger:\u003c\/strong\u003e Start the workflow by manually running it in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRead participants from Google Sheets:\u003c\/strong\u003e The workflow loads all participant rows from your selected spreadsheet and sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter for missing data:\u003c\/strong\u003e It filters to participants whose \u003cstrong\u003e“Food pref”\u003c\/strong\u003e field is empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate and store unique IDs:\u003c\/strong\u003e In batches, it assigns a unique ID to each participant that doesn’t already have one, then \u003cstrong\u003eupdates the participant row\u003c\/strong\u003e in Google Sheets with that generated ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreate a personalized email draft:\u003c\/strong\u003e For each qualifying participant, the workflow builds a personalized email body that includes a \u003cstrong\u003epre-filled Google Forms link\u003c\/strong\u003e using the participant’s \u003cstrong\u003ename\u003c\/strong\u003e and \u003cstrong\u003eunique ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrite Gmail drafts in batches:\u003c\/strong\u003e It creates a \u003cstrong\u003eGmail draft\u003c\/strong\u003e addressed to the participant, then continues until all matching participants are processed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend follow-ups to attendees who haven’t completed food preference details.\u003c\/li\u003e\n  \u003cli\u003eCollect event feedback via Google Forms without manually crafting emails per person.\u003c\/li\u003e\n  \u003cli\u003eImprove response quality by tying each email to a unique identifier stored in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow category:\u003c\/strong\u003e n8n automation workflow\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tech stack:\u003c\/strong\u003e \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e Configure \u003cem\u003eGoogle Sheets OAuth2\u003c\/em\u003e (read + update steps) and \u003cem\u003eGmail OAuth2\u003c\/em\u003e (draft creation).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheet requirements:\u003c\/strong\u003e Columns for \u003cstrong\u003eName\u003c\/strong\u003e, \u003cstrong\u003eEmail\u003c\/strong\u003e, \u003cstrong\u003eFood pref\u003c\/strong\u003e, and an \u003cstrong\u003eID field\u003c\/strong\u003e (plus row_number for updates), or adjust the filter\/column names accordingly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Form personalization:\u003c\/strong\u003e Replace the form URL and entry parameters in the email message so the link is pre-filled with the participant’s ID and name.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46228889141427,"sku":"N8N-20973","price":43.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/psLs2duQh1dFjTH_alloK_xiVhFQBz.png?v=1792055523","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-gmail-drafts-for-event-feedback","provider":"N8N Commerce","version":"1.0","type":"link"}