For me, I got around this issue by setting the Share to anyone with the link is an editor, as well as use the share link rather than the URL in the search bar. Make sure the sheet tab name is the same, eg no extra spaces. Good luck
After connecting to the Google sheet, I am unable to connect it to any particular sheet to add a row in. Please help, when I click on Get this app, it shows the first screenshot.