Multiple APIs requests, transformations using Python and finally a dataset. What's the best way to bring the data?

Hello to everyone!

I will start explaining my process which is like workaround and later on what I need to achieve.

Process

I need to create an analysis. That analysis requires data both from multiple APIs and my database.

The data that I need from my database are fine!

The API data needs transformation before I load them in Tableau. For that reason, I have created a Python script which do all the requests and the transformations I need. Then my script writes that data to a Google Sheet using the Google API.

I load that Google Sheet on Tableau and I combine them with the database's data.

I create the desired Dashboard and I upload it to Tableau Server. I have my script running on a lambda function, so it's scheduled to run every day. My Tableau Workbook uses Extract connection and I 've set to refresh that workbook on tableau server daily, because my database gets data every day.

The above mentioned process isn't actually desirable since the data aren't loaded directly into Tableau. Also the refresh of the API data are independent from the refresh of the extract and that's also not desirable.

What I need to achieve?

I try to get my data directly and have the refresh of API data and database data dependent.

Till now, I've checked the Web data connection approach but I am not sure if it can help since I make a transformation on multiple API data. Also does it support the dependent refresh?

Any other suggestion? What's the best solution for this?

Thank you!