How to trigger a flow when a row is updated in your Google Sheets spreadsheet

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"
    },
1 Like