Some Google sheets action events don't recognize the sheets ID

[Ori D]

Hello,

I've created a complex workflow: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTY5MDYzZjA0MzI1MjY4NTUzYzUxMzQi_pc. Whenever a paying customer schedules a meeting. I could trace and track it on my Google sheets.

Everything worked properly but when I created some Google sheets action events, it didn't succeed to fetch the data inside the sheets. What was even stranger was that it succeeded to fetch the data when I tried to use the lookup feature. But when I tried to use the get row or update cell it didn't succeed. So it seems that there is some sort of bug here.

I'm adding a video recording to show you what I mean: https://drive.google.com/file/d/1JPH-tDH6VtQIbE5QZxwLNAfluj_kWThJ/view?usp=sharing

Could you kindly fix this issue? Meaning that each Google sheet action event would be able to fetch the sheet ID. Also, could you consider adding the possibility to leave the sheets name blank. Then, as a default, it would change or add the data to the first sheet.

Thank you

 

[Supreme]

Hey @Ori D
If you're having trouble finding a specific sheet in your Google Sheets, you can make use of the "Google Drive: Global Search" action step which might provide the available sheet name to pass in the Google Sheets Update Row action step.

 

[Ori D]

Thank you!

I know how to find the Google sheets ID (or as you call it a spreadsheet). I have a problem with using the sheet ID inside the spreadsheet. For some reason I can't use the sheet ID or even use its name when I try the mapping option.

I'm adding screenshots to show you what I mean.

Again, hopefully you can, at least, add an option that the update row or cell will pick the first sheet (inside the spreadsheet). That is if we don't write any value inside the sheet.

 

[Supreme]

I know how to find the Google sheets ID (or as you call it a spreadsheet). I have a problem with using the sheet ID inside the spreadsheet. For some reason I can't use the sheet ID or even use its name when I try the mapping option.

When you're updating a row using the Google Sheets API, it relies on the Sheets name. If you provide the Spreadsheet ID in the action step, it automatically fetches sheet 1.

Alternatively, you have another effective option. Use the List Sheet action step to dynamically retrieve the first sheet from Google Sheets. Then, you can easily map the Property title field to the Sheet ID field, making the process smoother and more efficient.