How can I open or read a Google Sheets document.

I do not mind coding so that I download the sheet as a csv and then read and reprocess the downloaded contents.

I only need the information from google sheets as read only.

The google sheet contains details such as Member Number and Name.

My app would ideally
Read into a dictionary or store locally a csv file downloaded from Gdrive.
Present a screen to allow enter of member number.
Display member name.