Hey there, I’m a bit of a newbie when it comes to working with APIs, but I know it’s possible to send a webhook from ActiveCampaign –> Google App Script whenever my contacts take certain actions, and I’m wondering how to add a +1 count to a cell every time the webhook triggers?
Here’s a basic Google Sheet that I’m looking to update: https://docs.google.com/spreadsheets/d/1UfRFM7Uz0YUqemPTVYe1lmZ5NC5v9naFvmlLvXPZuVM/edit#gid=0
I’ve figured out how to send out webhooks to the Google Web App like this for every action:
^^ these will each contain a payload with the contact info from ActiveCampaign (although I’m not sure that’s it’s necessary).
I just need to know how to tell Google Sheets to add +1 to the correct column (action) & row (date) based on the webhook.
Thanks so much,