Chameleon's Google Sheets Custom reader is a great way to use a shared, cloud base Sheet to populate your custom stats
To start, build a regular spreadsheet. ![](https://bannisterlake.atlassian.net/wiki/download/attachments/516521985/image2018-6-20_10-29-22.png?version=1&modificationDate=1529501368365&cacheVersion=1&api=v2)
- The reader will create different topics for every tab you have. Any hidden tabs will be ignored.
- The reader will also read every column and row until there's an empty one. So if you're using empty columns as spacers, make sure you label the column with a blank name.
Share your document so that it becomes accessible and editable to the Reader and your colleagues.
![](https://bannisterlake.atlassian.net/wiki/download/attachments/516521985/share%201.PNG?version=1&modificationDate=1529501247457&cacheVersion=1&api=v2) ![](https://bannisterlake.atlassian.net/wiki/download/attachments/516521985/share2.PNG?version=1&modificationDate=1529501247748&cacheVersion=1&api=v2) ![](https://bannisterlake.atlassian.net/wiki/download/attachments/516521985/share%203.PNG?version=1&modificationDate=1529501248044&cacheVersion=1&api=v2)
Install the Reader on your Chameleon server. You will be asked to authorize your google account.
Enter the Database Information ![](https://bannisterlake.atlassian.net/wiki/download/attachments/516521985/image2018-6-20_10-32-22.png?version=1&modificationDate=1529501547384&cacheVersion=1&api=v2)
- You can have as many instances as you want, pointing to the specific content group that you want.
Insert the ID from your Google Sheet. ![](https://bannisterlake.atlassian.net/wiki/download/attachments/516521985/link.PNG?version=1&modificationDate=1529501249105&cacheVersion=1&api=v2)
![](https://bannisterlake.atlassian.net/wiki/download/attachments/516521985/image2018-6-20_10-34-40.png?version=1&modificationDate=1529501685698&cacheVersion=1&api=v2)
Run the reader. ![](https://bannisterlake.atlassian.net/wiki/download/thumbnails/516521985/image2018-6-20_10-35-28.png?version=1&modificationDate=1529501733437&cacheVersion=1&api=v2&width=400)
The results will come in as topics in the custom content type. ![](https://bannisterlake.atlassian.net/wiki/download/thumbnails/516521985/image2018-6-20_10-36-21.png?version=1&modificationDate=1529501787085&cacheVersion=1&api=v2&width=500)
|