Encountering 'Unable to Parse Range' Error in Task Flow Automation

[cybershopindia]

Your Task History ID

IjU3NjIwNTZjMDYzMjA0M2M1MjZhNTUzZDUxM2E1MTY0NTQzMSI_3D_pc

I hope this message finds you well. I am currently facing an issue in my task flow automation, and I am seeking assistance to resolve it. The Task History ID associated with the error is: IjU3NjIwNTZjMDYzMjA0M2M1MjZhNTUzZDUxM2E1MTY0NTQzMSI_3D_pc.

The specific problem occurs when attempting to update the row of the ChatGPT response onto the Google Sheets. The error message I am encountering is "Unable to parse range," and I am finding it challenging to pinpoint the root cause of this issue.

I would greatly appreciate it if any community members who have experience with similar errors or expertise in Pabbly automation could provide insights or guidance on troubleshooting steps. If possible, please share any recommendations or best practices that could help me resolve this issue and successfully update the row without encountering parsing errors.

Thank you in advance for your time and assistance. I look forward to receiving valuable insights from the Pabbly community.

Best regards,
Shreyans Jain

 

[ArshilAhmad]

Hi @cybershopindia,

Based on the workflow you have shared, it appears that after setting up your workflow, you changed the name of the sheet whose row you are trying to update. This may be the reason why the sheet is not being recognized in automation, and you are facing this error.

google_screen_recording_2023-11-11T20-55_38.891Z.webm

drive.google.com

I suggest refreshing the 'Select Sheet' field and choosing the new name for that sheet. Then, click the 'Save' button in the 'Update Row' action step.

 

[cybershopindia]

Hello team,
thanks for the reply. But I did try to change. lemme just try again and update you regarding the same.

 

[cybershopindia]

Hello team,
It seemed like I havent press the "Save" button that encountered the same problem. My bad. Sorry for the trouble and thanks for solving this for me at the quickest time possible.

 

[ArshilAhmad]

I am glad I was able to help resolve your issue.