Chameleon's Google Sheets Closings is a great way to collaborate and use a shared, cloud base Sheet to populate your closings.
To Start, use this template and duplicate to make your own: Google Sheet Template ![](https://bannisterlake.atlassian.net/wiki/download/thumbnails/63406123/MainPage.PNG?version=1&modificationDate=1475500927889&cacheVersion=1&api=v2&effects=drop-shadow&width=800)
Add some status. ![](https://bannisterlake.atlassian.net/wiki/download/attachments/63406123/Add%20results.PNG?version=1&modificationDate=1475501080336&cacheVersion=1&api=v2&effects=drop-shadow)
Share your document so that it becomes accessible and editable to the Reader and your colleagues.
![](https://bannisterlake.atlassian.net/wiki/download/attachments/63406123/share%201.PNG?version=1&modificationDate=1475500737306&cacheVersion=1&api=v2) ![](https://bannisterlake.atlassian.net/wiki/download/attachments/63406123/share2.PNG?version=1&modificationDate=1475500737530&cacheVersion=1&api=v2) ![](https://bannisterlake.atlassian.net/wiki/download/attachments/63406123/share%203.PNG?version=1&modificationDate=1475500737822&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/thumbnails/63406123/Reader.PNG?version=1&modificationDate=1475501638366&cacheVersion=1&api=v2&effects=drop-shadow&width=500)
Insert the ID from your Google Sheet. ![](https://bannisterlake.atlassian.net/wiki/download/attachments/63406123/link.PNG?version=1&modificationDate=1475500738905&cacheVersion=1&api=v2)
![](https://bannisterlake.atlassian.net/wiki/download/attachments/63406123/Reader2.PNG?version=1&modificationDate=1475501710315&cacheVersion=1&api=v2&effects=drop-shadow)
Run the Reader. ![](https://bannisterlake.atlassian.net/wiki/download/attachments/63406123/Flow%20capture.PNG?version=1&modificationDate=1475502056702&cacheVersion=1&api=v2&effects=drop-shadow)
If an institution is already in the database, the content will push to the specific content group. |