Spreadsheet ID doesn't work

[Ori D]

Your Task History ID

IjU3NjMwNTY1MDYzZTA0MzU1MjZkNTUzNzUxMzI1MTZhNTQzMiI_3D_pc

Hello,

I tried to run a workflow that the Pabbly Connect should recognize the Spreadsheet by its ID. As it should be dynamic. Unfortunately, for some reason it doesn't recognize it.

I tried to run the add new row and add multiple rows, but it didn't work in both cases. However, when I ran these steps manually, it worked. Also, I tried to run these steps by their name and not their ID, it also worked.

By the way, in order to find the ID of the Spreadsheet I tried to run two different action steps like: Global search and Search a spreadsheet. In both cases, it found the Spreadsheet ID. But when I tried to add a row by using the same ID I found in both action steps, it didn't work. In the history of this workflow I got an error: 400.

Please check this workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTY5MDYzZjA0MzI1MjY4NTUzYzUxMzQi_pc

Thank you!

 

[Supreme]

Hey @Ori D

As we can see from your workflow, it seems like your Google Sheets action step didn't respond at that moment. Perhaps due to excessive application requests or maybe the data that
you were trying to fetch doesn't exist or unable to access it.

You can re-execute the task again and it will work again.

 

[Ori D]

Hi, thank you for your quick reply.

Sorry, but I tried to re-execute the task, but it didn't work. I get the same error 400.

Also, I tried to fetch the data from the form itself (step 1) so the data should be existed. Still it didn't work.

This is the error I have received:

IjU3NjMwNTY1MDYzZjA0Mzc1MjY1NTUzNjUxM2E1MTY0NTQzNCI_3D_pc​

 

[Ori D]

By the way, I also tried another option which I hadn't changed and worked before. Now it doesn't work for the same reason.

This is the workflow ID:

IjU3NjMwNTY1MDYzZjA0MzA1MjZkNTUzNjUxMzU1MTYxNTQzNCI_3D_pc​

 

[Supreme]

Hey @Ori D

It seems that the spreadsheet ID you've mapped from the specific key is receiving the folder ID instead of the spreadsheet ID. As a result, the "Add multiple Row Values" operation is affected.

Our recommended solution is to select the file type as Google Sheets only. This option will limit the associated values with the name from your Google Drive to only Google Sheets.