{"repo":"harunou/SheetsDB","free":true,"listed":false,"github":"https://github.com/harunou/SheetsDB","clone":"git clone https://github.com/harunou/SheetsDB.git","description":"SheetsDB is a simple tool to read and write data from/to Google spreadsheet as JavaScript objects","language":"JavaScript","stars":26,"topics":["google-apps-script","spreadsheet","json","database"],"license":null,"category":"databases-storage","readme_excerpt":"SheetsDB - Database Operations for Google Sheets The code reads data from Google spreadsheet into JavaScript Objects AND writes data from JavaScript Objects to the spreadsheet. Examples Spreadsheet with data table and attached script: Apps Script project with the code: How to include SheetsDB into your project To include SheetsDB as library into your Google Apps Script project use the next Script ID: Installation Steps 1. Open your Google Apps Script project 2. Click \"Libraries\" 📚 in the left sidebar 3. Add Library ID: 1O3oDa3J8VEqasvJmVAOHLcL4shovmqF3PItdIgFC0ehIRhTZjBnQH84k 4. Select the latest version 5. Click \"Save\" Note: Ensure your project uses V8 runtime (default for new projects) for optimal performance. Spreadsheet Requirements - Spreadsheet should be owned or granted view (to read) or edit (to write) access - All cells recommended to be formatted as plain text - Sheet's first row is for column headers - Column header may contain white spaces and should be unique - First digit in the header will be ignored - Columns without headers within the data table range are ignored - Empty rows are ignored as well Header Transformation Examples - \"First name\" → \"firstName\" - \"1 title whatever\" → \"titleWhatever\" - \"Timestamp\" → \"timestamp\" Data Types Data in each column is converted to the specified data type, if the type conversion declared for the column. Default type for reads and writes is string. Type Codes - N - Number - S - String (default) - O - Object (JSON) - A - Arra","default_branch":null,"files":null,"tree":[],"storefront":"/r/harunou","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/harunou/SheetsDB/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."}