Track Daily Reports from Email in Google Sheet

Search my Gmail for the latest email with the subject '[Report Subject Line, e.g., Daily Sales Summary]' from '[Sender Email Address]'. From this email, extract the following data points: '[Data Point 1 Name, e.g., Total Revenue]', '[Data Point 2 Name, e.g., New Customers]', and '[Data Point 3 Name, e.g., Conversion Rate]'. Record these data points, along with the current date, as a new row in the Google Sheet at '[Google Sheet Link]', in the sheet named '[Sheet Name]', with corresponding columns.

Apps used

GmailGoogle Sheets