Open the tool: https://go.tejitpabari.com/tejit-np-auto-emailer
Nothing to download. It is a web page that runs inside your own Google account.
Sends one personal email to many people at once. You write the email once in Gmail, mark the parts that change (like {{Full Name}}), and the tool fills in each person’s details from your Google Sheet. Emails go out from your own Gmail address.
| You need | What it means |
|---|---|
| A Google account | Gmail, personal or Google Workspace. |
| A Google Sheet | Your list. One row per person, with a column of email addresses. |
| A Gmail draft | An email saved in Gmail but not sent. It is your template. |
Google daily limits: about 100 emails (personal Gmail), about 1,500 (Workspace). Send bigger lists in batches over several days.
Full Name, Email). One person per row from row 2..xlsx or .csv. For an Excel file: File → Save as Google Sheets.| Full Name | Personal Note | |
|---|---|---|
| Donor A | donor.a@example.com | Nice meeting you at the fundraiser. |
| Donor B | donor.b@example.com | |
| Donor C | donor.c@example.com | Great to see you at the gala. |
Example file: sample-sheet.csv (File → Import → Upload).
Subject: Thank you, {{Full Name}}
Dear {{Full Name}},
{{Personal Note}} Thank you for your support this year.
{{Full Name}}, not {{ Full Name }}.{{...}} is also in the body.
Open the tool link. Google shows an “unverified” warning because the tool has not paid for Google’s public review. It is safe if you trust the person who shared it. Safety check: continue only if Google shows the developer as tejitpabari99@gmail.com. If not, click Back to safety.
Click Review permissions.

Click Advanced (small link, bottom left).

Click Go to NGO Mailer (unsafe).

Tick Select all. The tool will not work if any box is left unticked.

Scroll to the bottom of the screen and click Continue.
| Google asks to… | Why |
|---|---|
| See your Google Drive files (read only) | To list your spreadsheets and read the one you pick. |
| View your email messages and settings (read only) | To find your draft. Nothing else is read. |
| Send email on your behalf | To send the emails from your address. |
| See, edit, create and delete your spreadsheets | To read your list and write “Email Sent” results back. |
| See your primary Google Account email address | To send the test email to you. |
| Connect to an external service | Only used to send anonymous usage counts to ping.tejitpabari.com. Never your emails, drafts or sheet content. |

{{...}} was replaced; if not, see Troubleshooting.With Store results in spreadsheet on (default), your tab gets new Email Sent and Email Error columns.

Click Advanced (Optional) on the dashboard. Everything in it is optional.

| Option | What it does |
|---|---|
| Store results in spreadsheet | Writes Email Sent and Email Error results into your tab (new columns with date and time by default). Turn off to send without touching the sheet. |
| Conditional Column | A column saying who already got the email. TRUE = skip. FALSE or empty = send. Other values stop the run. |
| Email Sent column / Email Error column | Only available when Store results in spreadsheet is on. – New Column – (default) adds a new column. Or pick one of your existing columns to write the result there instead (rows already marked sent by the Conditional Column are left alone; blank-email rows get FALSE / “No email address”). Pick two different columns, and not the email column. |
| Start from Row | Starts at this person (1 = first person, row 2). Blank = from the top. |
| Limit Emails | Stops after this many tries. Blank = no limit. |
| Stop After Errors | Stops after this many failed rows in a row. Blank = 5. Whole numbers from 1. |
The tool pauses a random 0.5 to 1 second between emails. If Google says you hit the daily limit, it slows to 1 to 2 seconds and retries that person once. If the limit is hit again, it stops and shows “Too many emails sent in a day via automation. Try again in 24 hours”.
If 5 emails in a row fail (or the number you set in Stop After Errors), the tool stops. Rows with a blank email cell are skipped: they are not counted as sent or failed, and do not affect this count. To continue after stopping:
Already Sent), copy TRUE values into it after each run, and use it as the Conditional Column.Do not use the newest Email Sent column alone as the Conditional Column. People skipped in that run are not in it, so they would be emailed again. After changing columns, refresh the page and re-pick your spreadsheet.
| Problem | What to do |
|---|---|
| Sheet not in the list | Only 50 sheets are shown. Copy it (File → Make a copy) or remove old sheets, then refresh. Make sure it is not .xlsx. |
| “Draft … not found” | Check it is still in Gmail Drafts and no other draft shares its subject. Refresh. |
{{...}} came out blank |
Name does not match row 1 (check spelling, no inner spaces), the cell is empty, or it is only in the subject. |
| “Too many emails sent in a day via automation” | Daily Google limit reached. Wait 24 hours, then continue (set Start from Row to where it stopped). |
| “Authorization required” | Open the tool link and repeat Step 3. Tick Select all. |
| Stopped after 5 errors | Read the last error and the Email Error column, fix it, then continue. |