Customer base on google spreadsheets?

Question

Google Sheets

Hello.
I work as a manager in an online store and I am fond of programming.
We have a customer base in google sheets, because general access is convenient.
There are about 5000 records. The boss asked me to make a script that will put regular customers in a separate table. In the first, only "loners" should remain.
I go through a cycle, add repeaters to one array, singles to another. Then I fill tables with these arrays.
It works fine on a small table - for some reason it is buggy for 5000 rows and adds the same ones twice. Plus it works for a long time. Partial processing will not work, because it is necessary to compare the entire 5000 for repetitions.
I ask for your advice - maybe there are other options for solving this problem? Paid bases will not work :(

Answer 1

databases should be stored in databases, sorry for the taftology, but that's exactly them
. And the reasons for this are not even that you have a large database, but that it must support transactions.
Parallel reading record, subordinate subtables and so on and so forth and so on.
The free version and how millions of people store it is a database
. Any of your choice and the way you interact with it.
In your case, perhaps you should connect to the Bitrix24 website so that it is free for up to 12 users.
And process them in the CPM, so that there are leads and funnels and phone statuses for customers, active, not active, goods purchased by them.
Well, or just harnite everything in mysql and Google tables in my opinion are able to work with them.

Answer 2

https://chrome.google.com/webstore/detail/groupro/...