{"repo":"ardislu/sheets-db","free":true,"listed":false,"github":"https://github.com/ardislu/sheets-db","clone":"git clone https://github.com/ardislu/sheets-db.git","description":"Minimal Google Apps Script (GAS) project intended to quickly transform a Google Sheet into a SQLite database.","language":"JavaScript","stars":21,"topics":["google-apps-script","google-sheets","sqlite"],"license":"MIT","category":"databases-storage","readme_excerpt":"sheets-db Minimal Google Apps Script (GAS) project intended to quickly transform a Google Sheet into a SQLite database. Click here to create a copy of the demo Google Sheet (the required GAS code will also be copied). Code repository mirrors: GitHub, Codeberg, git.ardis.lu Requirements - A Google Sheet to attach this Google Apps Script project to Initial setup These steps only need to be completed once. Setting up the Google Sheet 1. Create a new Google Sheet or create a copy of the demo Google Sheet. 2. Go to Extensions Apps Script to create a new Google Apps Script (GAS) project. The GAS project is automatically attached to the Google Sheet. 3. Copy Code.gs and sidebar.html into the GAS project and save. If you copied the demo Google Sheet, this code should already be there. (OPTIONAL) Setting up \"Upload .sqlite3 file to Backblaze\" If you use Backblaze as a storage provider, you can use the \"Upload .sqlite3 file to Backblaze\" button to upload the SQLite database directly to Backblaze. This setup is NOT necessary if you only want to generate SQLite databases. 4. In Backblaze, create a new application key with write access to the storage bucket where you want to upload the file to. 5. Note the keyID and applicationKey shown. 6. In the GAS editor, create the following Google Apps Script properties (environment variables) under Project Settings Script Properties : - BACKBLAZE ID - the Backblaze application key ID ( keyId ) from step 5. - BACKBLAZE KEY - the Backblaze applicatio","default_branch":null,"files":null,"tree":[],"storefront":"/r/ardislu","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ardislu/sheets-db/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}