No-code tools to pull data from Front and Hubspot

Hey No-Code people!

I use some of the "simpler" no-code tools regularly (Airtable, Zapier, etc). I currently have a problem I want to solve with no-code tools, but I feel that I might need something a bit more powerful here. Would love recommendations for which tools to consider.

What I want to do
I want to create a simple report and share it to Slack once per day. To generate the report, I want to pull a set of emails from Front (front.com) and deals from Hubspot based on certain criteria (snoozed emails, deals assigned to me, etc). This information should all be available via their REST-APIs.

When I have pulled that data, then I want to do a few things with it (remove deals if there is a snoozed email with the same contact, for example).

Where should I look?
I would love to hear suggestions for which tools I would need to get something like this running.

Best wishes,
David