There is a Google Sheet in which Meta leads coming, I want them to send to my CRM as it supports webhooks. So, I piece together a GAPPS script from various sources on the internet to do it but it is not firing when a new row is added from Meta connector.

There is a Google Sheet in which Meta leads coming, I want them to send to my CRM as it supports webhooks. So, I piece together a GAPPS script from various sources on the internet to do it but it is not firing when a new row is added from Meta connector.

Trying to make a Google Apps script so that everytime I press “Get Contact” on RocketReach and it displays the profile of the contact including email, it goes to the webhook I deployed via Google Apps Script and pastes the completed lookup into my Google Sheets.