dnd 5e – What are the effects of eating many berries from the Goodberry spell per day?

(besides the 1HP you get from each berry)

Goodberry specifies all of its effects in the spell description. Nowhere does it state any effects that come about from eating many of them. And spells do only what they say in their description and anything further is the realm of a DM to decide. So, by the rules, goodberries have no additional effects on you even when eaten many at a time.

There are no rules in the books that even state what would happen if you ate too much normal food over a long period of time (though we could certainly extrapolate in that case), much less magical food.

This really depends on the table. There could be some fun in ruling that a character starts turning red or gaining weight1 or any other effect a DM can imagine for these eating the berries, but, in the end it should be up to that DM to decide what is the most fun for their table.

It is certainly extremely arguable that magical nourishment works in any way like normal food-eating, but that is a detail that each DM can decide for themselves.

I would generally advise that if a DM was to go down this route to only introduce mechanically meaningless effects and definitely not ones that impose any kind of negative mechanical effect.

1 – Note that playing up a weight gain for laughs is also not cool at many tables, so know your table.