Send Event Reminders

From '[Google Sheet Link]', sheet '[Attendees Sheet Name]', identify attendees for events in the next 24 hours. For each, send a Gmail reminder to 'Email Address'. Subject: 'Reminder: Your Upcoming Event - [Event Name]'. Body: '[Event Date]', '[Event Time]', '[Meeting Link]'. Update 'Reminder Sent' to 'Yes'.

Apps used

GmailGoogle Sheets