Updated settings working for oauth2 authentication in Sheets API

For quick reference purposes, I would like to share the current solution for the authentication settings (there is a lot of outdated or non-working information on the web).

After a lot of research and reading to find the problem, I found the final solution in a youtube video by Renato Asse.

App ID and Secret are unique for your project (see Google Cloud Console)

Scope may vary depending on your needs and you must configure them both on the Cloud Console oauth page and Bubble. I´m using <https://www.googleapis.com/auth/userinfo.profile https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/spreadsheets>. Pasted this way (without “<” and “>”. With simple space between the URLs).