How to trigger a flow when a row is updated in your Google Sheets spreadsheet
I have no experience in using google sheets but I think as the result of a quick google search I would start with this google app script:
https://gist.github.com/NikitaAvvakumov/10cad2fef7d5ae303b2ba92c0fffec2d
and I would try to add an http endpoint in node-red which I would try to trigger by the javascript fetch api:
https://cookbook.nodered.org/http/create-an-http-endpoint
and don't forget to edit your settings.js:
httpNodeCors: {
origin: "*",
methods: "GET,PUT,POST,DELETE"
},
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.