Google Sheets only sees shared with me files

[Embodied Marketing System]

I am setting up my first workflow. I am wanting to add a new row with data from previous step into a google sheet. This spreadsheet sits in a subfolder on my google drive. However, the google sheets action only lets me select spreadsheets that area listed in that are "shared with me", I can't see any other spreadsheets in my google drive. I have tried to use the pabbly add on in google sheets but even though it is installed I don't get an option to use the add on :-/ Any help or idea would be appreciated

 

[Embodied Marketing System]

after some more digging around I discovered pabbly won't connect with excel spreadsheets in google drive, they need to be saved as "google sheets" to work.

 

[Pabbly13]

Hey @Embodied Marketing System !

Excel sheet or Xls format is not supported by us.

So if you have directly uploaded Excel sheet from your PC to Google Drive, then it will not show you in the Pabbly Connect workflow.

You need to have Google Sheet format only in order to work with Pabbly Connect.

Hope, we have mentioned your query.