Google Sheets Action: Get Row(s) Error

[jpr]

I do not understand why I am getting an error when mapping a Google Sheet to a previous Google Sheet action step. Please see loom video - https://www.loom.com/share/da4fbad35f104d4490635581a05d4917

Workflow link: https://connect.pabbly.com/workflow...KVm5dSVZSB1FRIlZPAxEBAlErAUwIc1QFWmlcAgcvBGU#

 

[Resham]

Hello,

Greetings!

Please enter the spreadsheet id only, it will not accept the entire URL.

You can use text formatter> text parser to get the spreadsheet id.

 

[jpr]

Hello,

Greetings!

Please enter the spreadsheet id only, it will not accept the entire URL.

You can use text formatter> text parser to get the spreadsheet id.

View attachment 56306

Thanks Resham, but now I have another problem with the 'Select Sheet' option. Please see video - https://www.loom.com/share/30a01c4da21847eba872bb7abbbe6b7e

 

[ArshilAhmad]

When mapping is enabled, you need to pass the ID (0) associated with the sheet instead of its name. You cannot directly pass the sheet name when mapping is enabled. If you want to send data to the same sheet, disable mapping and simply select 'Sheet1' from the dropdown.

google_screen_recording_2025-05-07T16-49_23.961Z.webm

drive.google.com

 

[jpr]

When mapping is enabled, you need to pass the ID (0) associated with the sheet instead of its name. You cannot directly pass the sheet name when mapping is enabled. If you want to send data to the same sheet, disable mapping and simply select 'Sheet1' from the dropdown.

google_screen_recording_2025-05-07T16-49_23.961Z.webm

drive.google.com

Thanks, but this didn't answer my question. I don't want to add anything manually. This should all happen dynamically hence I need to map the sheet code. The sheet itself, then needs to be 0 which is fine. But as I highlighted in the video, the 0 identifier is not being saved it seems. How do I make sure it gets saved?

 

[Preeti Paryani]

Hello @jpr,

Thank you for highlighting this.

We’ll discuss the issue with our team and keep you updated. For now, please note that "Sheet1" has an ID of zero, which you can confirm by enabling the Map option. Although the zero disappears after refreshing, the workflow will work fine if you select "Sheet1" from the dropdown.

Thank you for your patience.

SMAI GBP Phase 1 | Pabbly Connect

www.awesomescreenshot.com