Need help On how to Connect Json website with Google sheets.

Hi, There Fellow developers I am Not a developer nor a Geek. So Forgive me for the Silly question

So I track my Expenses and Incomes in the Google sheet to Track all the things. But the issue I have stumbled on is One of my clients I deal with Keeps the records in "Khatabook" and shared me a Link. But every time I have to manually edit the Remaining Or payable amount. cause the site is rendered in Json so google sheet can't fetch it directly. Then I tried to automate it using AI codes that did give me a solution with the help of Node js+Puppeteer+Ngrook. The downside with that is I have to Keep the connection alive in my Dekstop. I want to Run it in Cloud so it can run 24 × 7 Or any Other way So I can get the values from the Link directly.

I tried Railway As claude suggested but it didn't work also it has a 5$ free credit system. I can't 🥲pay right now in this situation for this simple task.

GitHub+vercel was also suggested but it has to change the whole code to Api model. But that too didn't work.

Please help me, I can share the Khatabook link in Dm cause the number is showing there.