How to update a Cell in Google Sheets to fire a new Webhook post into Pabbly
Status: Closed · Asked by RoCrow on · 0 views
I have a Google Sheet that is taking data from a Paperform form submission.
When the sheet updates the row with the new form submission, it is firing a webhook into Pabbly, which is working fine.
Let's say that the Sheet is receiving data in columns A and C, that B is blank, and that C is the trigger column to fire the webhook into Pabbly.
I want to be able to manually add some data into B at a later date, and then that will re-fire the Webhook, but it's not happening.
(because it seems to me that only if I edit data in the trigger column - C - will it fire the webhook again)
How can I do that? (manually enter data into column B at a later date and have it re-fire the webhook?)
Yes, you edit the data in C column's cell for the same row after adding data to Column B's cell it will fire the webhook for that row.
Yes, you edit the data in C column's cell for the same row after adding data to Column B's cell it will fire the webhook for that row.
Thanks for that. But I want to add data in B cell and it would fire, without needing to then amend/add/edit data again in C cell.
Eg. in the table below, row 1 is added and because there is data in C, it fires - view 1a below.
Then I add data in the B column, without touching the C column cell - view 1b below - and it still fires
[TABLE]
[TR]
[TD](view)[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD](result)[/TD]
[/TR]
[TR]
[TD]1a[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]30[/TD]
[TD]FIRES[/TD]
[/TR]
[TR]
[TD]1b[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]30[/TD]
[TD]FIRES[/TD]
[/TR]
[/TABLE]
Or is that what you meant?
If you have setup Column C as trigger column then it is not possible currently in Pabbly Connect.
If you have setup Column C as trigger column then it is not possible currently in Pabbly Connect.
Cool, thanks for that.