If you revieve a new sms, the number it was sent from, the contact name, the date and time and the message content are saved to a new row in a google spreadsheet.
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.
Explore more great ways to automate Android SMS and Google Sheets