Send a Gmail email when a new row is added in Google Sheets (Make.com)

Description and use

<p>A form response, a lead from a landing page or a manual entry lands in a Google Sheet, and you want an email sent to that person without copy-pasting. The part that goes wrong is not the sending: it is sending the same email twice, or not at all, when rows get sorted, edited or deleted.</p> <p>This guide contains affiliate links, marked “affiliate link”.</p> <h2> Short answer </h2> <p>Use explicit ready and sent states when eligibility can change after row creation. Choose <code>Search Rows</code> for a status-based work queue. Keep uncertain outcomes for inspection before releasing a row a

Problem

<p>A form response, a lead from a landing page or a manual entry lands in a Google Sheet, and you want an email sent to that person without copy-pasting. The part that goes wrong is not the sending: it is sending the same email twice, or not at all, when rows get sorted, edited or deleted.</p> <p>This guide contains affiliate links, marked “affiliate link”.</p> <h2> Short answer </h2> <p>Use explicit ready and sent states when eligibility can change after row creation. Choose <code>Search Rows</code> for a status-based work queue. Keep uncertain outcomes for inspection before releasing a row a

Outcome

<p>A form response, a lead from a landing page or a manual entry lands in a Google Sheet, and you want an email sent to that person without copy-pasting. The part that goes wrong is not the sending: it is sending the same email twice, or not at all, when rows get sorted, edited or deleted.</p> <p>This guide contains affiliate links, marked “affiliate link”.</p> <h2> Short answer </h2> <p>Use explicit ready and sent states when eligibility can change after row creation. Choose <code>Search Rows</code> for a status-based work queue. Keep uncertain outcomes for inspection before releasing a row a

Evidence

Send a Gmail email when a new row is added in Google Sheets (Make.com)

Source