Automate Lead Capture from Emails to Google Sheet

Check my Gmail inbox for emails received in the past 24 hours with the subject line containing '[Keyword/Subject Line, e.g., New Contact Form Submission]'. For each matching email, extract the sender's name, email address, and the subject. Add this information as a new row to the Google Sheet located at '[Google Sheet Link]', in the sheet named '[Sheet Name]', with columns 'Name', 'Email', and 'Subject'.

Apps used

GmailGoogle Sheets