Learning how to Connect to Google Drive (Google sheets)

Hello Forum

Today I’m looking or someone who has experience on working with Google Drive, Specifically Google Sheets. I have questions on the connection matter and on the capabilities of manipulation.

One of my main question is with the connection. I’ve made some research and to be able to create a connection i’ll have to create a API and Credentials on the Google Console. The thing is that every time I execute some kind of process, for being able to log to the account the robot always has this set up that i have to click manually the google account to be use, so that exclude all the unattended idea of the project. Is there any way to log in withought having to assist the robot?

Also which package should I download?

This and more I would love to discuss.

Thank you.