Can anyone give me a run down of how to use webhooks to change the email on reports from email@example.com to my personal address? Thanks!
You should create a Google Apps Script with using doPost(e) call and in the function you should use MailApp.sendEmail(…) method to send the emails from your Google account. After finalizing your script, publish it as a webapp and use its published URL as webhook endpoint URL in AppsSheet’s webhook workflow rule. You can specify the to, cc, bcc, body message, body type etc. inside the payload. You can check these pages: