Compile and send weekly email digest from Google Drive, update Google Sheets, and send via Gmail

Schedule weekly updates to keep stakeholders informed. Find the latest file in Google Drive, update your Google Sheets with key data, and send a concise email via Gmail, ensuring everyone stays in the loop with current information.