Generate email draft with final report from Google Drive, extract info with Python, and lookup in Google Sheets

Create a draft email in Gmail with the final report when a new file is added to a specific Google Drive folder. Extract necessary information from the file name and Google Sheets for faster reporting and communication.