We want to be able to build a webhook that runs when someone clicks a link in an email. So anyone who clicked a certain link, their email address automatically gets sent to a google spreadsheet. Does anyone know how to build a webhook like this that can help?
You can adapt the method described in Logging Marketo form fills to a Google Sheet. to post anything you want to Sheets.
Just be aware that Clicked Email events don't mean a human clicked the link. Advanced mail scanners pre-click all your links as well.