Ask Your Question

Can I create a 'shared' database for my small team that connects to Google Sheets as the source? [closed]

asked 2018-05-25 17:51:55 +0100

learningasigo gravatar image

updated 2020-08-18 17:04:29 +0100

Alex Kemp gravatar image

I work on a small team of 3 people (myself included) and I am trying to build a database to track serial numbers for our products, as well as a few other things. We don't have an internal server or dedicated database, and rely on Google Sheets a lot. I am wondering if I can create a database that I can share with my team and they can access the database source through the front end (Base).

What I had in mind was setting up a database that connects directly to Google Sheets on my laptop. When I have the database front end completed in Base I can send the file to my team, set up the connection to Google Sheets on their machine, and then we can all access Google Sheets through the database.

Would something like this actually work?

Can I edit information in Google Sheets via the LibreOffice Base application I make? i.e., will any changes any of us make while we are in the database be synced with Google Sheets and we can all view the changes?

If I create this, can my team access the database at the same time and make changes to the Google Sheet? We would all have the 'same' database in LibreOffice Base because I would create it and share it with the team, but they would access Google Sheets from their own computer. Google Sheets allows multiple people to edit and change the document at the same time.

We are all using Mac.


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-18 17:04:53.700632

1 Answer

Sort by » oldest newest most voted

answered 2018-05-25 19:30:15 +0100

Ratslinger gravatar image


Don't know of any method to connect to Google Sheets from Base. While Base has the ability to use data from a spreadsheet, this is a local setup. There have been instances of using Base on Google Drive. This does also require careful attention to who is doing what with the database and when. In other words it is not for multi-user processing. For this you would need a database server and a completely different approach.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-05-25 17:51:55 +0100

Seen: 229 times

Last updated: May 25 '18