Welcome to Gmail Drafter
Sign in with Google to create email drafts from your Google Sheets data
Load Google Sheet
Your sheet should have column headers in the first row. These will be used as variables in your email template.
Important: Your sheet must include an "email" column containing recipient email addresses. These addresses will be used in the "To" field of your draft emails.
Sheet Data Preview
| No data available |
Email Template
Create your email template below. Use the variable buttons to insert data from your sheet. When you click "Create Drafts", a draft email will be created in your Gmail account for each row in your sheet.
How it works: Each draft will be addressed to the email address in the "email" column of your sheet. All variables in your template (like {name}) will be replaced with the corresponding data from each row.
Click the buttons above to insert variables into your template. Each variable will be replaced with data from your sheet.
This will create 0 draft emails in your Gmail account. You can review and send them later.