Problem in node 'Google Sheets1'

Help me Build my Workflow
1

I have created a workflow that creates a spreadsheet on form submission and also updates the sheet with information collected using https openai/gpt-4o. My issue is on the final node which is google sheet. I am getting final output as “Sheet with ID not found” but if I remove the spreadsheetid and put the same back again, manually, it worked. What could be the issue

2

The issue has been fixed. I had to replace the “find sheet from the list” with “find sheet with ID” at the final node and insert the correct ID. That’s it.

1 Like
3

Correct. Even when you choose Select from list, the workflow node stores the ID of the sheet. This is also generated by the first Google Sheets node.
As solution you can use the {{ $('Google Sheets').item.json.sheets[0].properties.sheetId }}as sheet.

1 Like
4

Thank you so much. I will try this too.