Thank you very much! Your example, of course, saw, but for now (I hope so far) too complicated.
Tell me, please, how in Mock Data node value “Foo” can be made dynamic, i.e. write there what comes by webhook?
Hi @asuhan, how to dynamically set the value depends on how your input data looks like.
If you want to set a value by simply opening a webhook URL such as https://your.n8n.url/webhook/sheets?text=hello in your browser, your workflow could look like so:
This example uses a Set node which references the value after text= through an expression, making further changes rather simple (simply connect a new node to the Set node an update the expression accordingly). The data is then transformed in the format expected by Google Sheets and finally written in cell B3.
Hope this helps! If you’re still having trouble here, could you share the JSON data returned by your webhook node?