Generate draft emails for article reviews in Gmail from Google Sheets every week

Schedule weekly reviews to generate draft emails for articles needing attention. Lookup relevant rows in Google Sheets, loop through them, and create drafts in Gmail for timely follow-ups with responsible parties.