How to record a macro in Google Sheets

Hopefully it makes sense why we want to take a measurement over time