Been trying to send a couple of bits of data, once a day, to someone who lives in my house for them to create a spreadsheet. Tried the email node with my hotmail account but no joy and I have since read a bit about setting it all up and it would seem to be quite complicated.
Seeing as the person who will receive the messages is in the same house, maybe email is overkill anyway and maybe another node would be more suitable and above all, easier to configure.
Better than email would be a comms tool like Telegram. There are others of course such as WhatsApp and Signal but Telegram is really the easiest to get going with and there is a decent contributed set of nodes.
I don't know whether this would be of interest to you, but I use Google Forms and Sheets for entering and storing data in the cloud from a Node Red application using a node red http request node. So using this method the data can go directly into a spreadsheet for others to access. Probably overkill for your purposes, but maybe not. Google Sheets example