Is drinking coffee too much bad?

Ive gotten to a point where coffee makes me tired rather than keeping me awake. Been trying out tea instead of energy drinks if the need arises. Tho Ill still hit up a Frappuccino since its a sweet drink especially since its summer