Public Google Sheets don't require connecting a Google account to fetch their contents through the API. There should be a button to skip the OAuth login step if you only want to sync a public sheet, since that requires you to give the integration access to your entire sheets library and it would be more convenient if you have multiple users who all need to be able to sync the collection.
Design concepts:
