Error in connection with google sheet

Yes totally agree! Is on my list since months to create instructions how to create credentials for each service. Any contributions there are welcome.

The Google credentials are actually the only ones for which a tutorial exists as @svenjanssen created one which can be found here: n8n Nodemation nodes - using Google Sheets and Google API nodes (Tutorial) - YouTube