This recipe will retrieve the weather each day and populate a new row on your spreadsheet.
If
Today's weather report
This Trigger retrieves today's current weather report within 5 minutes of the time you specify. NOTE: Pollen count available only in the USA.
Then
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
ID JNQtrsD5
Explore more great ways to automate Google Sheets and Weather Underground