Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Email Automation

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

  1. Generate Unique ID
  2. Filter Participants
  3. Read Participants Sheet
  4. Loop Over Participants
  5. Set Mail Message
  6. Manual Email Trigger
  7. Send Email Draft
  8. Update Participant ID

Similar automations