Automation workflows
Connect SMTP email to your Google Sheets workflows
Send confirmation emails from a Google Sheets webhook via SMTP — log inbound data to a sheet and notify by SMTP in one workflow. Buy proven workflow files, download instantly, and launch with optional expert setup help.
What are connect smtp to google sheets?
Connecting SMTP to Google Sheets pairs a spreadsheet with your own outbound mail server so a workflow can both record data and send a real email from your domain — without relying on Gmail's send limits or a marketing tool. AutomationMart templates take an inbound trigger (a webhook, a new Sheets row, or a form submission), write or read the row in Google Sheets, and then send a confirmation, receipt, or internal alert through any SMTP server: Amazon SES, SendGrid SMTP, Mailgun, Brevo, or your host's mail relay. This is the pattern behind 'log the order and email the customer', 'capture the lead and notify the rep', and 'new row in the sheet → send the templated reply'. Because it uses SMTP, mail is sent from your own address with your own deliverability, and there are no per-send platform fees. The setup guide covers the common providers and their ports, and the email body supports merge fields so every message is personalised with data from the row that triggered it — a customer name, an order total, or a reference number — without a separate mail-merge tool.
Instant download
Get reusable workflow files immediately after purchase.
Built for operators
Use templates for sales, support, marketing, ecommerce, and reporting.
Expert setup available
Book live help when you want someone to configure it with you.
How it works
Trigger
An inbound webhook, a new Google Sheets row, or a form submission
Action
A Google Sheets read/write module plus an SMTP 'Send an Email' module using your mail server
Set it up in 5 steps
- 1
Download the SMTP + Sheets template for Make.com, n8n, or Zapier.
- 2
Connect the trigger — paste the webhook URL into your form or app, or point the trigger at a Google Sheet.
- 3
Add your SMTP credentials (host, port 587/465, username, password) from SES, SendGrid, Mailgun, Brevo, or your host.
- 4
Write the email subject and body, inserting sheet fields as merge tags (customer name, order number, amount).
- 5
Send a test row through, confirm the email arrives from your domain and the sheet updates, then activate.
The outcome
One workflow logs the data and sends the email — a receipt, confirmation, or internal alert — from your own domain over SMTP, with your deliverability and no per-send platform fees.
Common use cases
New order row → SMTP receipt email
When an order lands in the sheet, sends the customer a templated receipt from your own domain via SES or SendGrid SMTP, with order number and total merged in.
Lead captured → notify rep by SMTP
Logs a new lead to the tracker and emails the assigned rep instantly through your mail server, including the lead's name, company, and message.
Webhook → Sheets + branded confirmation
Receives an inbound webhook, appends the payload to a sheet, and sends a branded confirmation email over SMTP — replacing a marketing tool's transactional send.
Explore related integrations
Frequently asked questions
Why use SMTP instead of the Gmail action?
SMTP sends from your own domain and mail server, so you keep your deliverability and avoid Gmail's daily send limits and shared-sender reputation. It's the right choice for transactional email like receipts and confirmations.
Which SMTP providers work?
Any standard SMTP server: Amazon SES, SendGrid, Mailgun, Brevo (Sendinblue), Postmark, Zoho, or your web host's relay. You just need the host, port, username, and password.
Can I personalise the email with data from the sheet?
Yes — the email body supports merge fields. Any column in the sheet or field from the trigger payload can be inserted into the subject or body, as the setup guide demonstrates.