Consolidate Newsletter Subscriber Sign-ups

Monitor my Gmail inbox for emails received in the past 24 hours with the subject line '[Newsletter Confirmation Subject, e.g., Welcome to Our Newsletter, Subscription Confirmed]' from '[Newsletter Service Email Address, e.g., [email protected]]'. For each email, extract the subscriber's email address. Add this email address as a new row to the Google Sheet at '[Google Sheet Link]', in the sheet named '[Sheet Name]', with a column 'Subscriber Email'

Apps used

GmailGoogle Sheets