Can I get some feedback on my scenario please - I feel like I'm missing something

:bullseye: What is your goal?

I am building my first automation using something practical - my running program, I want to receive an SMS every morning for my specific run work out for that day, I want to both automate the way I receive my run workouts and learn make

:thinking: What is the problem?

My scenario works - between to google sheet modules and the twilio send message module, is this the optimal scenario? is anyone in the community able to suggest a better scenario to perform the same task - send a sms once per day from a set of data (different workout each day)

:camera_with_flash: Screenshots: scenario setup, mod

ule configuration, errors

Hi @Glenn_Thompson,

Overall the scenario looks good. To avoid errors or empty SMS messages, you can add a filter after the Google Sheets – Search Rows module so the scenario only continues when a workout is actually found.

1. Google Sheets – Search Rows

  • Filter by today’s date

  • Set “Maximum number of returned rows” to 1

2. Add a Filter module between Google Sheets → Twilio

  • Condition: Total number of bundles > 0

This ensures the Twilio module only runs if the search returned a valid row.

If this helps, feel free to mark the answer as a solution :+1:

1 Like

I was originally using a filter for the date - but it started giving me trouble / i was trying to use this code formatDate(now; “dddd”) - and it wasn’t working - so I tried to simplify it by switching - to just search rows for empty cells / and add rows by populating “senbt” nexct to the work out and it started working