Automate personalized SendGrid emails for new Google Sheets rows
This template watches a Google Sheet for new rows, reads name, email, and the columns you map, and sends a personalized message through SendGrid. JavaScript calls the SendGrid mail API. Connect Google Sheets. Put the SendGrid API key in that JavaScript node, then point the trigger at the worksheet that collects contacts.