Perhaps the most important 'thing' to have for indoor and night photography is a thorough understanding of the exposure triangle and how to deal with its limitations.
In 12 words or less, AUTO is highly unlikely to create any keepers without a flash. But flash photography has its own learning curve in addition to the exposure triangle. Note, too, that the popup flash on your camera will blind anyone within 4-5 feet, light them up OK at 8-10 feet, and provide close to zero illumination beyond 10 feet.
The big 'problem' is how to get a fast enough shutter speed to freeze subject motion...and camera shake motion as well. People simply standing in one place, even if posed, need at least 1/125th shutter speed to freeze them. Yes, 1/60th will sometimes work, but there will be a fair number of those that have slight blurring due to movement. People dancing? Even faster shutter speeds. Shutter speeds slower than 1/60th will result in a substantial portion of the shots being blurred.
On the other hand, cranking up the shutter speed has to be compensated for by increasing either the aperture (lower f-stop number) of the lens and/or faster ISO speeds. Both of those actions have 'limits' as well, namely a thin DOF resulting from a wide aperture, or too much noise in the picture from too high an ISO for your camera. And don't forget that many zoom lenses available have a variable aperture, such as f3.5 - 5.6, meaning that as one zooms in on a subject, 'wide open' for the aperture is reduced.
As others have already responded, getting a flash is the easiest means of handling low light photography. Shooting without a flash adds considerable challenges and compromises to get the shots you want.