Google Form Data Link to Google Sheet

 

Google Form Data Link to Google Sheet

नमस्‍कार दोस्‍तो,

इस ब्‍लॉग में हम आपको बहुत ही सरल भाषा में बतायेगें की किस प्रकार गुगल फॉर्म के Response को Paticular गुगल शीट में स्‍टोर कर सकते है ा

In this blog we will tell you Google Form Data Link to Google Sheet so read the complete blog carefully and learn Google Form Data Link to Google Sheet according to given guidelines.

Google Sheet Data show :- See Data

 

 Practical - Click to Practical

Step 1 :- Create Google Form

Step 2 :- Click Script Editor

Step 3 :- Create 1 file Name Given Below

Code.gs

Step 4 :- Copy of Code.gs Code Given Below

function onFormSubmit(event) { record_array = [] var form = FormApp.openById('Paste Google Form ID'); // Form ID var formResponses = form.getResponses(); var formCount = formResponses.length; var formResponse = formResponses[formCount - 1]; var itemResponses = formResponse.getItemResponses(); for (var j = 0; j < itemResponses.length; j++) { var itemResponse = itemResponses[j]; var title = itemResponse.getItem().getTitle(); var answer = itemResponse.getResponse(); Logger.log(title); Logger.log(answer); record_array.push(answer); } AddRecord(record_array[0], record_array[1], record_array[2],record_array[3]); } function AddRecord(Name, Father_Name, Mobile_no,village) { var url = 'Paste Google Sheet Link'; //URL OF GOOGLE SHEET; var ss= SpreadsheetApp.openByUrl(url); var dataSheet = ss.getSheetByName("Sheet1"); dataSheet.appendRow([Name, Father_Name, Mobile_no,village, new Date()]); }

Step 5 :- Add Form Trigger On Form Submit