How to send an email from a static HTML page with Google sheets Sometimes, you will have a simple static website created using Javascript, CSS, and HTML. It is possible too to create a contact form on the website.

As you are aware, the contact page accepts specific fields from users, such as their Name, Email address, and Message, and saves these contact details in the database.

In the backend of your site, you will see messages sent by users and can reply to users.

Perhaps you want to send a mail via your website but don’t want to operate any server-side language such as asp,php,node.js, and others. Or you would like to send a mail without an SMTP mail server.

In this short article or lecture, I’ll teach you ways to send mail from your static webpage with only Google sheets service and javascript.

Step By Step Instruction: How to send an email from a static HTML page with Google sheets

1. First thing to do is, click on the following link:

2. The spreadsheet will appear in front of you.

2. The spreadsheet will appear in front of you.

3. If you like, change the name of the file.

3. If you like, change the name of the file.

4. Click on Extensions> Apps Script.

4. Click on Extensions> Apps Script.

5. Click on line No: 8; change the “TO_ADDRESS” with the email address you want, and Save the “Script”.

5. Click on line No: 8; change the "TO_ADDRESS" with the email address you want, and Save the "Script".

6. Click on the Deploy > New Deployment.

6. Click on the Deploy> New Deployment.

7. Add any Description you want, change access to Anyone, and then Press “Deploy”.

7. Add any Description you want, change access to Anyone, and then Press "Deploy".

8. If it asks you to authenticate, click Authorize Access.

8. If it asks you to authenticate, click Authorize Access.

9. Copy the Web App URL you created and add it to your static web page.

9. Copy the Web App URL you created and add it to your static web page.

10. Download the HTML Contact page sample and navigate to the following part.

11. Paste the script’s link you copied from google sheets in step 9 into the “Action Value”.

11. Paste the script's link you copied from google sheets in step 9 into the "Action Value".

12. Open the file in your browser and try it out, complete the form, then click Send.

12. Open the file in your browser and try it out, complete the form, then click Send.

Check your email to see the magical work!  

Additionally, Google Sheets will record every email you or someone sends.

It was based on the GitHub tutorial. If you have any questions you can ask me in the comment section.

Read Also: 11 Top Free Blogger Templates For Any Niche – Download For Free

Read Also: How To Warm Up SMTP Server IP: Skyrocket IP Reputation By 90%