This only works with Http, cuz sheet node only supports Google Sheet Oauth2 credential while Http node supports Google Oauth2 credential which is more general and you can link it with a client id.
This issue doesn’t appear until now, only thing is you need to replace all of the sheet nodes with http node.