Aaj ham Complete project krege ki G-Form Submit hote hi Auto Email kaise bheje? Step by Step full guide Chalo shuru karte hai.
Alright guys, So bas ready ho jaiye kyuki aaj mein apko simple but real life project sikhane ja raha hun jisse apko kafi help milegi.
Maine pichle article mei Google apps script kya hoti hai detail mein samjhaya tha ab ham thoda project ki taraf chalte hai waise agar apko complete google apps script ki videos dekhni hai to ap mera youtube channel subscribe kar sakte ho.
Aaj kal ke technical zamane mein Automation har business and workflow ka hissa ban chuka hai, Agar App Google Form ka use kartey hai jaise ki (Survey Form, Enquiry Form, Booking Form or Registration Form) toh har bar manual check karna ya email bhejna kafi time consuming ho jata hai
G-Form Submit hote hi Auto Email kaise bheje?
Google Form Submit hote hi auto email bhejna bhot easy hai, ham esko Google apps script ke through krege, mein apko line by line code ko define kruga taki apko acche se samjh mei aa jaye.
Koi bhi project karne se pehle kuch importants points hote hai unko explain karna bhot zruri hota hai, yeh main apne 11 saal ke experince ke hisab se apko bata raha hun.
Maine neeche kuch points likhe hai jab bhi koi project banao toh enko hmesha mind mein set karlo, esse apko kafi help milegi and yahi ek professional way hai kisi project ko karne ka, Ab chahe project bada ho ya chota.
- Project Goal
- Use cases
- Project overview
- Project setup actual code and steps
- Project Testing
- Project SOP
- Final result / Impact
Auto Email Project Goal
Project Name: Google Apps script Auto email
Goal: Es Project ka goal hai ki jaise hi user Google Form ko submit kare, Client / Admin ko ek auto email send ho jaye taki client ko information receive ho ki koi new entry aayi hai, Notification ya Auto Email aate hi Client / Admin aware rhega ki usko kuch action lena hai.
Auto Email Project Use cases
Hamara project based hai Google Form par, Ab google form kisi bhi type ka ho sakta hai main point yeh hai ki jaise submit par click ho toh ek email ready ho jaye including (Suject line, body content, Information, Sender information ETC) so ab bat karte hai ki yeh project ka use cases kaha kaha ho sakta hai.
- School / Coaching Admission form
- Registration form
- Survey Form
- Doctor appointment form
- Turf booking / Slot Booking form
- Business enquiry form
- Event Form
Yeh kuch zyada use mein aane wale forms hai, apke case mein kuch dusre type ke bhi ho saktey hai ap unka bhi use kar sakte hai and auto email bhej sakte ho
Step-by-Step Process for Auto email Project
Sabse pehle ap ek Google form banao jisme ap yeh kuch fields add kro, Agar apko Google form banana nahi aata hai toh ap meri yeh video dekh saktey ho.
- Go To Google Drive
- Select Google Form
- Create new blank form
- Add Fields
- Name
- Number
- City
- Ab bat aati hai Response collection ki
- 1 New Google Sheets ko connect karlo taki apki Fields ki information Google sheets mein jati rhe
- Ab Google Apps Script ko open karo
- Google Sheet → Extensions → Apps Script
Jab ap above mentioned 4 points ko kar lenge then Code editor window show hogi, usme 2 lines ka already ek function likha hoga ap usko ignore karo and select karke delete kar dena.
Neeche mein apko ek code de raha hun ap usko copy karo and Code editor window mein paste kar dena
function sendEmailOnFormSubmit(e) {
var responses = e.values;
var name = responses[1];
var number = responses[2];
var city = responses[3];
var email = responses[4];
// Admin Email
MailApp.sendEmail({
to: "youradmin@gmail.com",
subject: "New Form Submission",
body: "New entry received:\n\n" +
"Name: " + name + "\n" +
"Number: " + number + "\n" +
"City: " + city + "\n" +
"Email: " + email
});
// User Confirmation Email
MailApp.sendEmail({
to: email,
subject: "Thank You for Submission",
body: "Hi " + name + ",\n\n" +
"Thank you for submitting the form.\n\n" +
"Your Details:\n" +
"Name: " + name + "\n" +
"Number: " + number + "\n" +
"City: " + city
});
}Code Explain for Auto email Project
G-Form Submit hote hi Auto Email kaise bheje es project ka code upper ap dekh sakte hai jaise hi ap yeh code paste kroge then apko save karna hai and run karana hai, After execution the above code apka email send ho jayega.
Chalye ab Google Apps Script form ke auto email code ko Line by Line samjhtey hai
1.Function kya kar raha hai?
function sendEmailOnFormSubmit(e)- Yeh function tab execute hoga jab koi form submit hoga
- e yha ek arugument hai, esme sara data jo form se aa rha hai yani hmare case mein 4 fields woh esme insert ho jaygi.
2.Data ko grab karna (Pakadna/ Store karna)
var responses = e.values;Jab data “e” mei aa jayega then e.values yani ki har fields ke data ko array list mein esne store kar liya hai, Simple way mein kahu toh (Name, Number, City and Email) ko esne catch kar liya and store kar liya array ki form mein.
Yah joh apko word dikh raha hai “var” It means Variable, Agar apko variable detail mein samjhna hai toh mein neeche ek video laga raha hun ap dekh saktey ho kitne easy way mein maine apko samjhaya hai pasand aaye toh Subscribe kar lena.
3. Har field ko alag alag variables mein dalna
var name = responses[1];
var number = responses[2];
var city = responses[3];
var email = responses[4];yha 1,2,3 and 4 indexing position hai for example Name-1, Number-2, City-3 and Email-4
3.Admin / Client ko Auto Email Bhejna
MailApp.sendEmail({yeh function email bhejne ke liye use hota hai.
to: "youradmin@gmail.com",Es email ko ap replace karo aur Client ka email id daal do, Yeh woh email hai jisko yeh information milegi.
subject: "New Form Submission",yeh apki subject line hai, ap apni requirement ke hisab se changes kar sakte ho.
body: "New entry received:\n\n" +\n ka matlab hai New line add karna , agar 2 bar \n\n hai so eska sidha matlab hai ki 2 lines ka gap liya gya hai
Ap meri youtube ki videos dekho jo maine hindi lang mei samjhai hai basic se advance level tak.
Trigger ka role in Auto Email
Trigger hi decide karega ki kab email ko send hona hai, esly make sure ki ap yeh important point na bhule
- Apps Script → Triggers
- Function select kro
- Event: Even ka logic lagao in trigger ki “On Form Submit”
Jitna maine apko abhi tak sikhaya hai agar woh ap step-by-step follow kar rahe hai toh mubarak ho apne hamara project “G-Form Submit hote hi Auto Email kaise bheje? 2026 guide” ko run kara liya hai and complete kar liya hai.
Conclusion
Yeh project apka skill level ko increase kar rha hai jo ki hmara mission hai, agar apko kisi tarah ka koi error aata hai toh ap mujhse direct contact kar sakte ho, Hope ki hmara project G-Form Submit hote hi Auto Email kaise bheje apko clear ho gya hoga,
FAQ
Kya coding knowledge zaruri hai?
Zaruri toh nahi hai lekin agar basic aati hai toh better way mein ap jaldi kar paogey.
Google Apps Script Kya hai?
Google apps script javascript based hai, Esme google ne kafi features add kiye hai jisse yeh Google drive, Google Sheets, Docs ETC par automation and manage karta hai
