Automate Weekly Invoice/Payment Confirmation Logging

Scan my Gmail inbox for emails received in the last 7 days with the subject containing '[Payment Confirmation Keyword, e.g., Payment Received, Invoice Paid]' from '[Payment Processor Email Address]'. For each email, extract the client name, payment amount, and transaction date. Add this information as a new row to the Google Sheet at '[Google Sheet Link]', in the sheet named '[Sheet Name]', with columns 'Client Name', 'Amount', and 'Date'.

Apps used

GmailGoogle Sheets