Google Sheets -> Discord | Seems to not pickup a change in the cell

Help
1

Now, I’m a little stupid when it comes to this stuff but I do try. I’m sure I’m missing something damn obvious.

I’ve got a “New updates (instant)” trigger hooked up to a google sheet and a worksheet is defined. It pulls the values from the worksheet then I’ve got it linked to a “Send message (advanced)” for Discord. The Pipedream bot has the required roles and is obviously using my email for access to the sheet so why won’t it pull the data specified in the message which looks something like this;

Update
{{steps.trigger.event.currentValues.values[3][3]}}
{{steps.trigger.event.currentValues.values[4][3]}}

{{steps.trigger.event.currentValues.values[9][1]}}
{{steps.trigger.event.changes[3].new_value}}

{{steps.trigger.event.currentValues.values[9][3]}}
{{steps.trigger.event.changes[4].new_value}}

{{steps.trigger.event.currentValues.values[9][5]}}
{{steps.trigger.event.changes[5].new_value}}

When tested, the workflow completes with no errors but does not update the currentValue.values[4][3] when needed. I’ve looked for other variables in the message but doesn’t seem to be much I can change. Regardless, when even the changes[3].new_value is changed, still no update to the data is seen and no message is sent.

Also, is there a particular reason for the “changes” variables to start on the 7th row? Can’t see why the 3rd and 4th row aren’t there considering they were updated yesterday at the same time as the others.

Is there something I have to enable for it to dump old data and pull new ones or something? I can’t figure this out for the life of me.

2

Hi @etomkins11138,

I’m sorry to hear that you’re having trouble with your workflow. I’ll do my best to help you out.

First, let’s make sure that the data from the Google Sheets trigger is being received correctly. You can add a step right after the trigger to log the data received from the trigger. To do this, add a new step and select the “Run Node.js code” action. In the code editor, add the following code:

export default defineComponent({
  async run({ steps }) {
    console.log("Trigger data:", steps.trigger.event);
  },
});

Save and run the workflow. Check the logs to see if the data from the Google Sheets trigger is being received as expected. If the data is not as expected, there might be an issue with the trigger configuration. Please double-check the trigger settings and make sure it’s set up correctly.

Regarding the “changes” variables starting on the 7th row, it’s possible that the trigger is only detecting changes from that row onwards. You might want to check the trigger configuration and ensure it’s set up to track changes for the entire sheet.

If you’re still having issues, please don’t hesitate to visit https://pipedream.com/support for more support options.
I’m a bot powered by Pipedream and GPT-4. I’m still learning, so please double check my answers and code! Learn how to build your own.

3

It looks like the data isn’t being updated after running the trigger data code. As far as I can see, the trigger should be working fine.
It has;

  1. An account linked
  2. A Google Sheet specified
  3. A Worksheet specified

Presumably, the “New updates (Instant)” should work worksheet-wide as there doesn’t seem to be anywhere to specify individual cells.

usectrigger
usectrigger914×815 30.3 KB

4

I’ve managed to get this to work now. However, I would like to have it embedded so resorted to using the “generate code” feature to provide me with a blank embed code template using Node.js and the axios library. Can’t quite seem to nail the problem, however.

If anyone can help, it’d be much appreciated.

5

Success!

After 5 hours of T&E tonight, I’ve managed to get it to push everything I need.
Now to figure out how to pull info from the sheets trigger into the Node.js code, anyone got any ideas?