SUBSCRIBE BUTTON CREATION, AND AUTOMATIC NOTIFICATION IN EMAIL WITHOUT USING ANY 3RD PARTY SITES OR APPS

 

Topics

• Step 1: First create your google form(subscribe us form)
• Step 2: Link with it a Google sheets
• Step 3: Google sheets
• Step 4: Creatioon of tool that intervally check your "suscribers" list in google sheet and sent greeting new suscriber
• Step 5: Creation of tool that intervally check your website/blog for any new post/article and send it to respective suscriber
• Step 6: Add registry keys manually

Hello techy buddies! 👋

I have fulfilled my promise today — creating a Subscribe button, collecting subscriber email lists, and automatically sending email notifications whenever a new blog post is published — without using any third-party apps or websites.

When the idea of automatic notifications first came to my mind, I searched inside Blogger itself for a built-in widget that could do this work for me. Unfortunately, earlier this feature was available through FeedBurner, but Google has discontinued that service.

After that, I explored several third-party solutions that could do the same job. One popular option I found was Follow.it. It works well initially, but after using it for about a year in the free version, I noticed a issue.
The email notifications were sent to subscribers without showing my actual blog content. When a subscriber clicked the link, it redirected them to the Follow.it page first, where my post and link were displayed. This broke the direct connection between my blog and my readers.

then, i also explored other sites for the same, i also found zapier for this, but it demands for money, and also i found difficult to run it, as its steps are very much complicated and couldn't be understandable.

Then, At last I chose to build the entire system using Google’s own tools — to collect subscriber emails and send automatic notifications whenever a new blog post is published, all without depending on any external platforms.

If you have a little bit of coding knowledge, this method is perfect for you.
And even if you don’t know coding at all, you can still try it — because I have explained every step in a very simple way, so that even a complete beginner can follow along easily.

Without any unwanted talkings, we start our process from here.

You have to understand that for doing all of these things, we require 3 things, 

•     one google form, who collect your suscribers email and all of the things, 
•     then a google sheets, where all emails and other things are noted down automatically whenever any viewer click the submit button of google form, 
•     and the 3rd thing, a tool who repeatedly viewing your site for any new blogs and sent email to suscribers listed down in google sheet.

Step 1: First create your google form (subscribe us form)

• If you have multiple topics in your blog, and you want that your suscribers receive only its interested topic blogs 
• Then, you have to add a section  in the google form, for better understanding, see the below video.

Step 2: Link with it a Google sheets

• in google forms
• click on "Responses"
• click on"Link with sheets"
• Select on "Create a new spreadsheet"
• You can provide another name for it or keep as it is.
• Then after few moments, a new spreadsheet open and you can view the following headings like "timestamp" and other "questions" as headings given in google forms.
• Now whenever any suscribers enter his/her email or its details, it automatically note down here.

Step 3: Google sheets

• in same spreadsheet, click on Extensions
• click on Apps script
• you can view following headings in left hand side: "Files", "code.gs", "Libraries", "services"
• Click on "code.gs"
• paste the following code
• Enter your Spreadsheet Id and sheet name

• Generate Google Apps Script Code

  SPREADSHEET ID (To find it, see the web address, copy the dotted line for ex: https://docs.google.com/spreadsheets/d/-----/edit?gid=0#gid=0 ): SHEET NAME: 

• click on run button in google apps script, [this button present at the top, where you can see 'Run', 'Debug', 'doPost']

Step 4: Creatioon of tool that intervally check your "suscribers" list in google sheet and sent greeting new suscriber

go to drive

• click on +New in left hand side
• click on more
• click on "Google Apps script"

  CREATE YOUR OWN CUSTOM NEWSLETTER FOR GOOGLE APPS SCRIPT

Step 5: Creation of tool that intervally check your website/blog for any new post/article and send it to respective suscribers

• go to drive
• click on +New in left hand side
• click on more
• click on "Google Apps script"

• EMAIL NEWSLETTER, AUTOMATIC NOTIFICATION WHENEVER ANY NEW POST CREATED INSIDE YOUR BLOG/WEBSITE