Export g sheet to suitable format - csv for example.
Than import csv file to database.
How to fetch login and password from the base txt (many lines of "user:pass" format)
-
Use javascript
.split(":")method. Example : https://community.bablosoft.com/post/68709
