Use only selected row as webhook payload

Ask for Help Formulas
,
1

Hi all, i’m trying to use n8n to link grist to dolibarr. I’d like to send only the currently selected row’s data through to n8n, the ultimate goal is to create an order in dolibarr with data that is a grist table row…

So far i’ve only managed to send a whole table to n8n, which is a step in the right direction, but not quite my goal.

2

If you use the official Grist node in n8n, there’s a filter option, if that’s what you mean.

3

I wish it was this simple but i could not find a way to filter according to which row is currently selected in grist. Workflow is like :

  • select a row in a grist table
  • in this row there’s a link/action button/boolean switch/whatever, click it
  • n8n webhook is triggered and received the data from the row that is selected
  • n8n does some magic
  • a new order is created in dolibarr, prefilled with the previously mentioned row
  • victory

Maybe my workflow is incorrect so i’m open to suggestions and tips !

4

I think what you need is to utilize the webhook in Grist:

image
image948×309 9.99 KB

5

That’s what i meant by

I could rephrase it into : grist webhook that triggers n8n is called and transmits data from the selected row. But that’s the step that does not work as a grist webhook transmits the whole table unless you specify a filter column. Problem is : i don’t know how to create a “currently selected row” behaviour in a specific column.

EDIT : but again, that’s the way i intend it to work, maybe not the way it is intended to…

6

From what I know, Grist webhook sends the subject record only as the payload, not the whole table. I suggest you make a boolean (toggle) column, and make that to be the column for grist webhook to watch for. As soon as you toggle that column for that record, that record will be sent to n8n for processing. You have to toggle that though, not just select and trigger a webhook.