specific number
If
New SMS received from phone number
This Trigger fires every time you receive an SMS on your Android device from a phone number you specify.
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 jcrQMwtp
Explore more great ways to automate Android SMS and Google Sheets