Reader - Google Sheets Closings

The Google Sheets Closings Reader is used to get updates of closings from a shared Google Sheet. The precise format of the google sheet is mandatory and should be a copy of the template which is available at:

https://docs.google.com/spreadsheets/d/1SnwdDHWxaDeun5W5q-aRPPTC6VlpTBTkAit-502rqzg/edit#gid=0

The format of the sheet has strict formatting where all 3 fields need to be entered. For the status field, you can optionally limit the available statuses that are supported in your sheet by creating a data validation on the row and providing a list of items.

The google sheet id is what the reader uses to identify the google sheet. You can get that id from the sheet url or by going to the sheet's share option.

Once the reader is running, it'll automatically add closings from the sheets. If institutions and statuses don't exist in the database, the reader will add them.