workflow error updating google sheet

[rjwalkerz]

Here is the issue in loom - https://www.loom.com/share/63b6a910e27940b1b4f46fa131058664

 

[PabblyMember3]

Could you please try reconnecting your Google Sheets: Update Row action step and reconfigure it once?

Hope that will resolve the issue. Let us know if issue persists.

 

[rjwalkerz]

@Naveen
I rebuilt it ... and it is still erroring out. https://www.loom.com/share/e097e84086b04e37be69d2dc937e38e0

 

[PabblyMember3]

Thanks for getting back to us,

I have checked your workflow history and found that, you have mapped with the response of Lookup Spreadsheet Rows step's rowIndex value in the in the Update Row action.

But, for all your executions, the you are receiving data not found in the Lookup step instead of any row index which is resulting the error in the update row as there is no row index is passed.

Please check your workflow history:

Kindly, updated your workflow with a filter condition step which checks for if row index exists in the response of lookup step to avoid such errors in the update row step.

Watch this video to learn more about the Filters:

I hope you find the above solution helpful.

 

[rjwalkerz]

Thank you! I will go edit and run again.