Thts the mentality you want to adopt , trust me
Every lifter had to start somewhere , an can all empathize with ur feels right now
Joining the gym at first is going to be incredibly daunting , your going to walk onto the gym mat the first time and look around you , seeing all these jacked silverbacks and then struggle to pick up 8kg or something lol .
I'd recommend reading up quite a bit and looking at videos of the exercises so at least you have some idea of what your going to be doing and how to perform it correctly. 5x5 routines are THE best routines for a beginner , and when followed correctly your strength will rocket sky high within weeks , but if you really want to start from rock bottom there are always the resistance machines which are easy to use but I wouldn't recommend , maybe the first week or two after joining the gym ? These work out a range of muscle groups your going to want to target (chest , upper back , lower back , legs ).
Where you really want to be though , is in the free weight section . Core exercises which target multiple muscle groups are going to be the best option for you : Bench Press , Squats , Dead lifts , Overhead Press etc look them up , I know your probably going to think there's no way I can do that ... Start very very low , and slowly add weight,
Protein shakes can taste pretty decent , I currently have unflavoured though which pretty much tastes like sick but i gulp it down nonetheless.
If you have a friend whos looking to join too , it would be an excellent choice . Not only can they help you by spotting you (making sure you perform excercises ok ) ., they will motivate you to go and the journey you make together will only solidify your friendship.
Best of luck ,