Use Zapier for a direct row-to-message Zap
Start with the published new-row template and map the recipient and message. Add the eligibility filters and status update described below before enabling the complete workflow.
Zapier's current Google Sheets integration lists new-row, new-or-updated-row, updated-row, and row-update operations.