{"repo":"ErickWendel/nodered-google-sheets-to-json-stream","free":true,"listed":false,"github":"https://github.com/ErickWendel/nodered-google-sheets-to-json-stream","clone":"git clone https://github.com/ErickWendel/nodered-google-sheets-to-json-stream.git","description":"This Node-RED custom node lets you consume google sheets spreadsheets on demand.","language":"JavaScript","stars":47,"topics":["etl","google","google-auth","gooogle-sheets","nodered"],"license":null,"category":"data-pipelines","readme_excerpt":"nodered-contrib-google-sheets-to-json-stream This Node-RED custom node lets you consume google sheets spreadsheets on demand. Why My inspiration for creating this module was that the popular node-red-contrib-google-sheets puts all the spreadsheet data in memory overloading Node.js and causing crashes while working with big sets of data (such as 10K+ sheets lines). It also doesn't automatically set the sheet range nor parse data to JSON nor allow you to filter only the columns you want. Solution and features This module nodered-contrib-google-sheets-to-json-stream came to solve these problems by processing data on demand and providing a good developer experience. Once you add your google sheets credentials and put the spreadSheetId, it: - auto completes fields listing all sheets in the spreadsheet - automatically sets the range of lines and columns available in the sheets - parses the available columns (using the sheet's first line) into JSON - processes items on demand (currently process 500 items per time if the range is bigger than 500) - in the status, shows how many lines were processed vs how many is missing - if you trigger this module twice, stops the current processing Demo Configuration Auth To setup auth this node uses a google service account: Create a new service account from This Page Download a JSON credentials object for the service account. Give that account access to the sheets API. Share your sheet with the email address of the service account eg nodered@nod","default_branch":null,"files":null,"tree":[],"storefront":"/r/ErickWendel","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ErickWendel/nodered-google-sheets-to-json-stream/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."}