## Google Sheets Rate Assistant

### Instructions

First fill out the config.json with the required information.


### Run
*Node must be installed on your system*

Download the .zip of the repository and extract into a folder.

1. Open Powershell in the directory
2. run `npm install`
3. run `node index`

### Config Extract

```
{
    "apiKey": "--- API key ---",
    "documents": [
        {
            "googleDocId": "--- Google Sheet ID ---",
            "sheets": [
                "-- Sheet Name ---",
                "-- 2nd Sheet Name ---"
            ],
            "pollRate": 1500
        },
        {
            "googleDocId": "--- 2nd Google Sheet ID ---",
            "sheets": [
                "-- Sheet Name ---"
            ],
            "pollRate": 10000
        }
    ]
}
```

+ Lowest PollRate for a single API key is recommended at 1200 to keep these under the free tier of 60 per minute.
+ Each API key should be different, this is not checked.
+ Multiple documents can be polled from a single key and the rate will be calculated.
+ Multiple sheets can be included under each 'googleDocId' and will not add to each APIKey rate limit.