[BUG] Google Sheet - Upsert action show error Cannot read property 'updatedData' of undefined

[vunguyenhung]

Describe the bug
I create a new Workflow and add the Google Sheet - Upsert action. Upon executing the action, the workflow failed with error Cannot read property 'updatedData' of undefined
To Reproduce
Steps to reproduce the behavior:

1. Create a new Google Sheet spreadsheet, add sample data as below

2. On Pipedream, create a new Workflow, then add a Google Sheet - Upsert action
3. Connect with the created Google Sheet, add sample data. Then execute the action and observe the error

Expected behavior
The action should be executed successfully

Additional context
First reported by a customer here: https://pipedream-users.slack.com/archives/CPTJYRY5A/p1670199077151129

[alysonturing]

Hello @vunguyenhung I wasn't able to reproduce the error, followed the same steps:

[Rsslone]

I was the original reporter of this bug on slack, and something has changed, I rebuilt the step it exactly the way I did before and its completing as expected. He was able to reproduce my issue as well.

I think something was changed with how the array builder copies a path, before it would construct it as
{{steps.node.$return_value[0].id}}
now its
{{steps.Get_Discord_Connections.$return_value[0].id}}

[vunguyenhung]

Hello @alysonturing @Rsslone, I have just tested the action again and it works now

I suspect that this is because Google Sheet APIs previous change that caused the error on Pipedream side. Now the issue is fixed because they might have been rolled back the change.

@Rsslone I assume the action is ok for your usage right now! Kindly let me know if you need more help! I'll close this ticket!

Thank you!