Krishn157/NodeIntoGoogleSheets

Google Spreadheets and Node JS

The script creates a Node JS endpoint which will save data to a Google Sheets spreadsheet.

Setting Up

1. Clone the repository.
2. Run npm install.
3. Update SPREADSHEET_ID in index.js to your desired spreadsheet.
4. Go to the documentation and follow Step 1 to turn on the Google Sheets API. Save the resulting credentials.json file in your project root.
5. Run node .. You will be asked to visit a URL and paste the resulting code into your command line.
6. Success. You can now send POST requests to your endpoint (e.g. localhost:3000) and the data will be saved to your Google Sheets spreadsheet. Below is an example JSON POST request and the resulting update:

{
	"data": [[1,2], [3,4]]
}