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: https://script.google.com/a/modernmusician.me/macros/s/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/exec?tag=TourHackingLead&count=1 https://script.google.com/a/modernmusician.me/macros/s/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/exec?tag=DDSCompleted&count=1 https://script.google.com/a/modernmusician.me/macros/s/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/exec?tag=Applications&count=1 ^^ these will each contain a payload with the contact info from ActiveCampaign (although I'm not sure that's all 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. Any ideas? Thanks so much, Michael -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/46598b68-253d-4cd5-a04c-ebb8105add9a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
