It's a combination of "Great" and "Sweet". It's used when you want to express the appreication you have for somebody's "great" perfomrance or action.

Someone people turn to when they're sad who makes them feel better.