I’ve tried to add this post two other times and it keeps getting deleted, not sure why. I will leave the code out and see if that helps.
I have a zap that takes the output of a Cognito form and adds a row to a Google sheet. I want to run a script via a webhook that essentially does a vlookup on an ID number to another tab in the Google sheet and returns a value from that sheet into a cell in the row that was just added.
The web app script is set up properly; the script runs with no errors, and the logger outputs “processed successfully” but it does not output any of the data that’s passing through the webhook, and the value is not added into the appropriate cell (or anywhere else on the row).
This post is kind of similar to what I am dealing with, although not an exact comp. I have run out of ideas to try to debug this. Any ideas?