This is the second half of a 2 part recipe.With both recipes all SMS messages received and sent are recorded in a spreadsheet in Google Drive. Other half is here: https://ifttt.com/recipes/165475-sms-timeline
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 pvfPkiRJ
Explore more great ways to automate Google Sheets and Android SMS