Email Automation
Send feedback request emails to event participants from Google Sheets via Gmail
Runs on demand to filter participants listed in a Google Sheet and create personalised feedback email drafts in Gmail for each one.
What it does
## Chase feedback (for Events, Operations, etc.) ### How it works 1. Starts with manual trigger to initiate the run. 2. Retrieves all participants from Google Sheets. 3. Filters the participants based on specific criteria. 4. Processes each participant in batches, creating unique IDs. 5. Matches IDs and sets up email drafts in Gmail. 6. Loops back if more participants remain. ### Setup steps - [ ] Configure an OAuth 2 client (type "Web application" in the Google console - [ ] Then in n8n, we need a Google sheets client - [ ] Create your own sheet and form (can use the sample here to see how things work with XLOOKUP, ID, etc.). Select your sheet in "Get all participants" and "Set ID to match later" - [ ] Create a fillable form link ("Get pre-filled link" in G-Form) - [ ] Change "Create Mail message" to include your message - and also your form link (use from link from previous step, adjust similar to sample) ### Customization Pls. customize sheet and form and message sent
The steps
- Generate Unique ID
- Filter Participants
- Read Participants Sheet
- Loop Over Participants
- Set Mail Message
- Manual Email Trigger
- Send Email Draft
- Update Participant ID
Similar automations
E-commerce & PaymentsSell Zoom Meeting Seats with Stripe Payments and Gmail38 stepsChatbots & Messaging BotsRun Telegram Giveaways with Referrals Using a Postgres Bot37 stepsEmail AutomationSend monthly timesheet reminder emails from SharePoint CSV via Outlook10 stepsEmail AutomationSend Obsidian Notes as Emails with Gmail13 steps