Weekly Project Status Summary

Search my Gmail inbox for emails received in the last 7 days with the subject 'Weekly Project Update for [Project Name]' from '[Team Lead Email Address]'. For each email, summarize the key progress, blockers, and next steps. Add a new row to the Google Sheet at '[Google Sheet Link]', in the sheet named '[Sheet Name]', including the project name, the week ending date, and the summarized status.

Apps used

GmailGoogle Sheets