Google Sheets not finding file

I am trying to add a row to google sheets. However, I am unable to find the specific file. The folder has been shared to my email in google drive. Does someone know why this is not working?

Thank you in advance!

This is simple. You cannot use the Google Drive API to read Google Workspace files that are shared with your personal account.

These icons identify which are from an organisation’s Google Workspace account:


To get around this, you need to change the module’s connection to use a user account that is a member of that Google Workspace, instead of a personal Google account.