michaelgriscom / dream-assistant Goto Github PK

Calling sheets.append with a range equaling a free column from the last entry (e.g. C1) will append to the last row, but the hard part will be figuring out what the last free column is, and it might also always go into the first row that has that cell empty

https://developer.amazon.com/docs/alexa-voice-service/notifications.html
Looks like you can provide an audio asset, so it might be possible to play a cue like "you're dreaming" at a set time after the user goes to sleep, when they're most likely to be in REM

Force user to reauth when the access token is invalid

Rather than creating a new sheets/drive object with each invocation, store the access token and reuse the instance. Maybe do jwt parsing and if it's expired than use whatever access token is passed in