Summarize Customer Feedback from Emails and Log to Google Sheet

Fetch all emails received in my Gmail inbox from the last 24 hours with the label '[Gmail Label, e.g., Customer Feedback]' or containing the keyword '[Keyword, e.g., feedback, complaint, suggestion]'. For each email, generate a concise summary of the feedback/issue. Then, add a new row to the Google Sheet at '[Google Sheet Link]', in the sheet named '[Sheet Name]', including the sender's email, the date received, and the generated feedback summary. Mark the processed emails as read.

Apps used

GmailGoogle Sheets