On the old Google Sites product, adding an RSS feed was as simple as installing a widget, providing the url and away you go. But the new Google sites have dropped support for widgets, so you're left with some much more difficult options as outlined in this forum post. I haven't tried it yet. When I do, I'll update this post.