workflow error updating google sheet
Status: Closed · Asked by rjwalkerz on · 0 views
Here is the issue in loom - https://www.loom.com/share/63b6a910e27940b1b4f46fa131058664
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.
@Naveen
I rebuilt it ... and it is still erroring out. https://www.loom.com/share/e097e84086b04e37be69d2dc937e38e0
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:
youtube.com/watch?v=W3HMbI5Q68U
I hope you find the above solution helpful.
Thank you! I will go edit and run again.