Do universities provide automatic scholarships or do we need to apply separately?

It depends on the university and scholarship type.

Some German universities offer automatic merit-based scholarships based on your admission profile, so you may be considered without a separate application. However, major scholarships like DAAD or Deutschlandstipendium almost always require a separate application with specific documents and deadlines.