Upload FOIA Gmail attachments to Google Drive and update FOIA Tracking Google Sheet with links

“Anytime a new email is received in Gmail with the FOIA label do the following: 1. Lookup spreadsheet row in Google Sheets that has the same MY_ID as the subject line in the email. 2. Update spreadsheet row in Google Sheets with a link to that email 3. Only continue with Zap if the email has attachments 4. Create a new sub-folder within an existing Google Drive folder for FOIA responses. Name this new folder as "MYID - Agency" (but with the relevant request details) 5. Upload the attachments from the FOIA email to that folder 6. Update FOIA Tracking google sheet with a URL to the new folder”