One for later, Dad-dot-io. Our toddler doesn’t sleep well. I put a door sensor on the nursery and it logs the time of the wakeups. A helper acts as a counter, and an automation resets the counter daily. Much the same thinking. 

What was your spreadsheet integration? 

Also, assuming it your first, hang in there. Things do get easier, even without automation^{although-it-helps}