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

**URL:** <https://discourse.nodered.org/t/how-to-trigger-a-flow-when-a-row-is-updated-in-your-google-sheets-spreadsheet/70635>\
**Category:** General\
**Created:** [15 November 2022 10:03 UTC](https://discourse.nodered.org/t/how-to-trigger-a-flow-when-a-row-is-updated-in-your-google-sheets-spreadsheet/70635 "2022-11-15T10:03:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jameer.basha](https://avatars.discourse-cdn.com/v4/letter/j/9d8465/32.png) [@jameer.basha](https://discourse.nodered.org/u/jameer.basha)\
**Post date:** [15 November 2022 10:03 UTC](https://discourse.nodered.org/t/how-to-trigger-a-flow-when-a-row-is-updated-in-your-google-sheets-spreadsheet/70635/1 "2022-11-15T10:03:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![knoepsche](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knoepsche/32/69450_2.png) [@knoepsche](https://discourse.nodered.org/u/knoepsche)\
**Post date:** [16 November 2022 14:51 UTC](https://discourse.nodered.org/t/how-to-trigger-a-flow-when-a-row-is-updated-in-your-google-sheets-spreadsheet/70635/2 "2022-11-16T14:51:27Z")

</div>

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](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](https://cookbook.nodered.org/http/create-an-http-endpoint)

and don't forget to edit your settings.js:

```auto
httpNodeCors: {
        origin: "*",
        methods: "GET,PUT,POST,DELETE"
    },

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [15 January 2023 14:51 UTC](https://discourse.nodered.org/t/how-to-trigger-a-flow-when-a-row-is-updated-in-your-google-sheets-spreadsheet/70635/3 "2023-01-15T14:51:55Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.