Skip to content
EmailSheets

Getting started

Overview

EmailSheets “Send Email with =EMAIL()” is a Google Sheets Extension that lets you send email simply with =EMAIL() formula. You only need to buy the license once for lifetime usage ($19), no subscription needed.

This is a much cheaper alternative (buy once, use forever) than subscribing to Mail Merge.

Getting Started

  1. Activate License (Buy $19 once for lifetime use): https://terrydjony.lemonsqueezy.com/buy/60362b93-6d5d-463e-89e5-1dc72d96fe00

  2. Insert your Resend API Key

  • Sign up on Resend.com ( https://resend.com )
  • Set up your domain (if you haven’t already) in the Dashboard > API Key alt text
  • and create API key in Dashboard > API Key alt text
  • Get the API key you just created, and then go to Google Sheets> Extensions > EmailSheets > Insert Resend API Key, then insert the API key
  1. Use =EMAIL() to send text via email, use =EMAIL_HTML() to send text via html

Guides

Send Email

You can mass email to your targets using this add-on.

Formula

=EMAIL(from, to, subject, body)

Example

alt text

=EMAIL("[email protected]",A4,C4,D4)

Send HTML Email

HTML Email is supported as well.

Formula

=EMAIL_HTML(from, to, subject, html_body)

Example

alt text alt text

=EMAIL_HTML("[email protected]", A2,C2,D2)

Tips

You can browse free html email templates on search engine. In the example above, I found one from Github

Contact

Contact [email protected] if you need any help.