I couldn't find an issue for the Google Sheets tap would the spreadsheets anywhere one work instead?

You should be able to add https://github.com/singer-io/tap-google-sheets as a custom plugin: https://meltano.com/docs/plugin-management.html#custom-plugins https://github.com/ets/tap-spreadsheets-anywhere only supports CSV and Excel files, not connecting directly to Google Spreadsheets

Thanks @douwe_maan!