<commit_before># Streaming API for Google Spreadsheets

[![NPM version](https://badge.fury.io/js/google-spreadsheet-stream.png)](http://badge.fury.io/js/google-spreadsheet-stream)

A very basic streaming API for Google Spreadsheets.

Currently only read-only, supports only public spreadsheets.

## Installation

```
npm install google-spreadsheet-stream
```


## Basic Usage

``` javascript
const GoogleSpreadsheet = require('../index.js');

const testKey = '<KEY>';
const testSheetId = 'od6';

var spreadsheet = new GoogleSpreadsheet(testKey);

spreadsheet.getColumnHeaders(testSheetId)
  .on('data', function(data) {
    console.log('Column Headers: ' + data);
  })
  .on('end', function() {
    var currentRow = 1;
    spreadsheet.getRows(testSheetId)
      .on('data', function(data) {
        console.log('Row ' + currentRow + ': ' + data);
        currentRow++;
      });
  });
```


## TODO

- Allow authentication for private sheets<commit_msg>Change require() in basic usage to make it work<commit_after># Streaming API for Google Spreadsheets

[![NPM version](https://badge.fury.io/js/google-spreadsheet-stream.png)](http://badge.fury.io/js/google-spreadsheet-stream)

A very basic streaming API for Google Spreadsheets.

Currently only read-only, supports only public spreadsheets.

## Installation

```
npm install google-spreadsheet-stream
```


## Basic Usage

``` javascript
const GoogleSpreadsheet = require('google-spreadsheet-stream');

const testKey = '<KEY>';
const testSheetId = 'od6';

var spreadsheet = new GoogleSpreadsheet(testKey);

spreadsheet.getColumnHeaders(testSheetId)
  .on('data', function(data) {
    console.log('Column Headers: ' + data);
  })
  .on('end', function() {
    var currentRow = 1;
    spreadsheet.getRows(testSheetId)
      .on('data', function(data) {
        console.log('Row ' + currentRow + ': ' + data);
        currentRow++;
      });
  });
```


## TODO

- Allow authentication for private sheets
{'fraction_non_alphanumeric': 0.1473899692937564, 'fraction_numerical': 0.0020470829068577278, 'mean_word_length': 4.077922077922078, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6972831', 'n_tokens_mistral': 643, 'n_tokens_neox': 599, 'n_words': 141}