I am currently fetching data from webhook and data is being published to google sheet.
my google sheet get updated based on data from webhook
example:- someone order something at a website, his details like id, name, mobile number, order value, and “order status(pending)” is updated to google sheet.
now once the website changes order status(accepted/done) at their backend, webhook is called to get the latest order status, updates the row in google sheet based on id.
I want to trigger an email when the order status is updated in google sheet row.
I have tried using the lookup option but either it fetches a certain row or all data based on the column.
n8n Desktop app