Sheets to Sender.net Email Automation

Whenever a new row appears in my Google Sheet I need an automated message to go out through Sender.net. The trigger is simple—add a row and fire the workflow—no manual clicks, no time-based checks.

Only the content of Column A is required in the email body for now; the script should be written so I can extend it later to pull Column B or C if I decide to. The email can have a fixed subject line that includes the sheet name, but the body must dynamically insert the Column A value.

I am comfortable granting you access to the sheet and a fresh API key from Sender.net. I expect clean, well-commented Apps Script (or another secure method you prefer) that:

• Detects the onEdit or onChange event specifically for a newly appended row
• Prevents duplicate sends if the row is edited later
• Authenticates to Sender.net via their API and posts the email payload immediately
Update DNC List automatically

Please include a brief hand-off note so I understand where to tweak column mappings or the Sender.net template ID. A short test with a dummy row that lands in my inbox will serve as acceptance.