Before The Minish Cap
They firstly appears according to Hyrule Historia during the Era of Chaos (before The Legend of Zelda: The Minish Cap) where Rauru the sage of light is forced to build the Temple of Time to protect the Sacred Realm and the Triforce from evil minds, he then seal himself there to ensure their protection.
Ocarina of Time
In The Legend of Zelda: Ocarina of Time, you had to gather the sages to stop Ganondorf and save Hyrule. After Link gathers the sages and defeats Ganon, Zelda calls upon the sages and they banish Ganondorf to the void or sacrifice themself alongside Zelda in the Decline Timeline.
In The Legend of Zelda: The Wind Waker, a new group of sages called "The sages of the Master Sword" appears their elements are wind and earth those element may be chosen because of the name of the springs that allowed Zelda to bess the Mastersword (Skyview spring and Earth spring). It is also notable that stained glass windows of the six sages from Ocarina of Time appear in this game.
In The Legend of Zelda: Twilight Princess, the sages appear as generic faceless old men as opposed to actual species. It is also notable that in this game Ganondorf kills the ancien Sage of water.
A Link to the Past
In A Link to the Past the seven Sages are mentioned in the begining of the game and it is said that they are responsible for the sealing of Ganon, later their descendants the seven maidens are captured by Agahnim and sent to the Dark World to destroy the seal of Ganon.
A Link Between worlds
In A Link Between worlds the sages are back and are said to be the descendants of the Sages mentioned in A Link to the Past and hence the maidens.They are captured by Yuga who hope to break the seal of Ganon after that they are rescued by Link in Lorule before granting him the Triforce of Courage.
In Adventure of Link the towns are named after the seven Sages from Ocarina of Time.
Leader of the Sages
Sages of light
Sages of water
Sages of fire
Sages of shadow
- Sage Impa (OOT)
- Ancien Sage of shadow
- Sage Impa (ALBW)
Sages of forest
Sages of spirit
Sages of wind
Sages of earth
- Sage Seres (possibly a reference to the Maiden from ALTTP)
- The ancients sages from The Legend of Zelda: A Link to the Past
- The Maidens from ALTTP