Send Personalized Emails to Leads from Google Sheets via SendGrid

This n8n workflow sends personalized marketing or outreach emails using predefined templates stored in Google Sheets, delivered via SendGrid. It reads lead data (business name, location, email, category) from a 'Leads' tab, selects a random template from an 'Email Template' tab, replaces placeholders like [BusinessName] with actual data using a Set node, and sends the email. A 1-second wait between sends prevents rate limits and spam flags.

Key benefits include faster execution without AI calls, total control over content tone and structure, easy customization via variables, and zero extra cost per email. Ideal for freelancers, agencies, startups, or SMBs managing lead outreach from Sheets.

Use cases: Automate cold email campaigns, nurture leads with tailored messages, or scale personalized follow-ups. Setup involves configuring Google Sheets credentials, SendGrid API, and authenticating the sender email for seamless operation.