Google Sheets Discord Issue: Can Anyone Help with Cell Change Detection?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

Hi all, is anyone able to give me a hand with this? Google Sheets -> Discord | Seems to not pickup a change in the cell - #3 by ThomasLubanga

2

After screwing around with it, it is now actually updating. However, is there a way to use conditional statements like IF and OR (see what I did there?) in the Discord advanced message? For example, can I get the action to pull old data if new data doesn’t exist (I.E. there hasn’t been an update)? All I get at the moment is “undefined” where no update to the data has been made.

3

As mentioned in the post itself, I’ve managed to get an embed to work. Any ideas on how I can pull data from the Google Sheets trigger into the Node.js code?

4

Can I still use the {{steps.trigger.event.currentValues.values[10][1]}} type variables to do this or no?