link from SQlite to GSheet ? Or GAS to import the data?

[Jean-Michel Nègre]

Dear all, I'd like to read or import updated data from a SQlite table to GSheet. Indeed, I'd like to build pivot table from data which are initialy located in a table from a SQlite DataBase.

Do you have some way to build the "connexion" or the "direct access" ? Or it's needed to use other script language like Microsoft PowerShell, Python etc...

Thanks in advance

[Clark Lind]

Ashton Fei did a video a couple years back connecting sheets with a mysql database. You may get something useful out of it.

video: https://www.youtube.com/watch?v=LCt7mRT0pBE
sheet/code: https://docs.google.com/spreadsheets/d/1Ph8tKTfYWkbXyFlO4bbqCa55LPv6Ex7V3yBMCzMppV8/copy

[Clark Lind]

The above is writing to the mysql DB, here is reading from:

video: https://www.youtube.com/watch?v=atCI3gqR-2E

code/sheet:  https://docs.google.com/spreadsheets/d/1Ph8tKTfYWkbXyFlO4bbqCa55LPv6Ex7V3yBMCzMppV8/copy

[Jean-Michel Nègre]

Sorry, it doesn't help me because it concern mysql database and not "SQlite" database. I tried to replace "mysql" by "sqlite" and it doesn't work too.

For the moment I don't see other "connectors" who talk about "SQlite".

[Alex]

Unfortunately, Apps Script don't have any port/connection for a file streaming for direct using SQLite DB.

You need to up a http-server for communication and data exchange. You have to use something like this https://github.com/olsonpm/sqlite-to-rest. This can cost you additional software maintenance or hosting costs.