I have been trying to get my webhook to set column values where data is returned from my webhook that I need to update my sheets with. I have tried many different ways to configure this action but with no luck. The only way I am able to configure the set columns values action adding the action to my outgoing webhook action and returning the data just before my status, which I am able to return the data that I want but the rows are not updated with the data. Can someone offer some advice on how to configure this action to update my rows please.
Do you have a Call API/trigger webhook action and wants to update your table with data you get from the webhook?
I think the way you should do it is creating a webhook trigger (if you’re on the right plan), then send data to that webhook, parse it and update to the right row.
Please attach some screenshots of your configurations if possible.
For my current setup I am using a webhook (from external source) trigger writing the return to a new row on a dedicated sheet and then querying that sheet to update my row on my main sheet. Everything is working up to the set column value action. The main reason why it is not working is because I cannot configure my set columns value action using this method, I have tried to test the workflow just to get data to come through in order to prime the action but that hasn’t worked either. I have used the set columns value action as part of my app interaction action and returned the data that I want to update in json just before the status code, captured it and I was able to configure the set columns value action but it still did not write to my sheet. My latest configuration is from the Glide tutorials on how to configure incoming webhooks but even using this method I still cannot get the set columns value action to configure. By this I mean the section where the row is set remains greyed out.
Couple of things I can see from your screen shots:
- A Webhook Triggered Workflow (unlike a User Interaction Workflow) is not attached to any table. So if you want to update values in a table you first need to establish a link to that table. One way to do that is with a Query (Single) node. Another way is with a Single Value->Whole Row node. So you need either one of those in your Workflow
- Your Query JSON node isn’t configured properly, so it returns nothing. Assuming that you are trying to extract a value from the Webhook Trigger body, then you need to specify which value you want.
Thank you Darren for your response, okay for the Query JSON node, I need to extract 5 different values from my return webhook, I can only extract one per Query as far as I can see, do I need to add additional nodes to get all the values that I need? also for the nodes that you are referring to (Query single or Single Value) I do not see those options in my configurations.