Log Website Contact Form Submissions

Monitor my Gmail inbox for new emails received in the past 24 hours from '[Your Website Contact Email Address, e.g., [email protected]]' with the subject line 'New Website Contact Form Submission'. For each email, extract the sender's name, email, phone number (if available), and the message content. Add this data as a new row to the Google Sheet at '[Google Sheet Link]', in the sheet named '[Sheet Name]', with columns 'Name', 'Email', 'Phone', and 'Message'.

Apps used

GmailGoogle Sheets