Hi there,
at first I have to apologize. Maybe, there is a obvious solution, but I am absolutely new to databases in general and i have very limited programming skills and I am not a native english speaker.
I created a website for a private Soccer-Manager-Game a few years ago. I managed the data with google sheets and created a fetch function to call the data to the website. This solution works, bute the problem is, that the data has high latency and so it is not very satisfying to use.
Because of that I try to switch to MongoDB. I would like to connect my spreadsheet to mongoDB, so that I can sync my data with my cluster.
But after one week of research I still didn’t manage to find a solution. Some solutions like connecting over “Realm” or “Mongo Stitch” seem to be outdated or no longer available. Third party automations or integrations like “Zapier” are too expensive for our small private project. (small means we have about 30.000 rows and about 350.000 data cells :-))
I would be very grateful if someone could help me with struggle.
Thank you und kind regards