Streaming floating profit into Google Sheets

Quite simply, I want to securely and efficiently stream the floating profit and balance of each of my MT4 and MT5 accounts into a Google Sheet. I have approx 20 trading accounts across both platforms and I’d like specific cells in a Google Sheet to securely receive the live floating profit and balance values of each of my individual accounts, updated approx. every 30-60 seconds or as close to realtime as possible. I believe this will involve a simple EA for MT4 and MT5, and an intermediate application that connects to the Google Sheets API. My terminals are running on a Windows VPS. I would like the ability to customise the frequency of updates as well as which specific cell each value streams into and the format in which they do so (e.g. “$2,000”). I would appreciate the ability to test the output and discuss changes and improvements after the first version to achieve the optimal result. The solution should comply with best practices for data security and privacy. Happy to discuss.