There are quite a few competitors in this space, trying to figure the best way about this. I've been recently playing with the Jentic MCP server[0] that seems to do it quite cleanly and appears to be entirely free for regular usage.

[0] https://jentic.com/

We offer volume discounts on all metrics.

Email me on robin @ <domain> and happy to find a solution for your use case