Email new files in OneDrive to a mailing list in Google Sheets

OneDrive

OneDrive

Google Sheets
Mail

Google Sheets and Mail

Keep your mailing list up to date. Whenever you add a file in a certain OneDrive folder, email every email address in a Google Sheet table. Be sure to have the first row with a column header called Email in your table.