I am trying to connect a new google sheets file to my automation. Activepieces recognises the Connection, also the spreadsheet, but the individual sheet it doesn’t recognise. When you click on the dropdown menu no sheets appear.
I have the same issue, the problem is with the integration version, I don’t know when was updated.
In my local installation the Google sheet integration version is v0.11.14 and in the cloud version is v0.12.0
I exported one of the flows from my local, imported it into the cloud, then I copied the v0.11.14 integration into my new flow and now I’m able to see the sheet in the dropdown.
I had the same problem but found that if I create a new Work Sheet within the Google Sheet it found the new Work Sheet, it just didn’t find the original Work Sheet (Sheet 1) that was created with the worksheet so if you’ve already put a lot of work into the ‘Sheet 1’ (the original worksheet) just make a copy of it (duplicate) then delete the original and rename the copy and Active Pieceswill find it.