{"repo":"fulldecent/google-sheets-etl","free":true,"listed":false,"github":"https://github.com/fulldecent/google-sheets-etl","clone":"git clone https://github.com/fulldecent/google-sheets-etl.git","description":"Live import all your Google Sheets to your data warehouse","language":"PHP","stars":22,"topics":["data-warehouse","data-vault","etl"],"license":"MIT","category":"data-pipelines","readme_excerpt":"Google Sheets ETL Import all your Google Sheets to your data warehouse, including periodic delta loads See example.php how to use this library. Install Via Composer Next, create a Google Service Account. This requires 20 steps so we made a a step-by-step illustrated guide. Testing Google Sheets limitations We found several problems with using Google Sheets as a database, even though we continue to use it: - Cannot restrict editing the first row (headers) to certain people - If you try protecting the cells it will prevent everyone from using a filter which is unacceptable - Sometimes the page will load slowly and your collaborators will accidentally overwrite the first row, which is default-selected, and it will cause your ETL to error until fixed - Cannot restrict that any formatting must apply to the entire column (including new rows) - Inevitably, any conditional formatting you try to set up will apply to a disjoint set of cells throughout your sheet over time - Cannot restrict that formulas must apply to the entire column (including new rows) - Inevitably, over time your calculated \"status\" column will turn into the text literal \"DONE\" as people copy-paste-values to new rows - Cannot limit people from using formatting in cells (which comes by default when they paste into cells) - Cannot enforce a unique column - Creating a custom data validation formula is cumbersome and not reliable, plus other collaborators can defeat it - Cannot create a sheet-level comment to document ","default_branch":null,"files":null,"tree":[],"storefront":"/r/fulldecent","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fulldecent/google-sheets-etl/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."}