Today I'm going to show you how to create a survey form like this automatically using Google Forms and ChatGPT in less than 60 seconds. This is a very handy tool to collect leads and feedback and you can customize it for different events, marketing campaigns or in my case to understand more of my students in a training program. First go to chatgpt.com.
So for the very first round we can just start with a very simple prompt. Just say please create a survey form. for a data science workshop that I have conducted last weekend.
It was a two days workshop which I covered big data analytics, data visualizations and predictive analytics. Many AI beginners made the mistake by being too brief or write a prompt that is too short. They just simply say please create a survey form for me.
I mean it's okay but the result won't be too good. Here we want to set up the context so we want to be as specific as possible and let ChatGPT knows as much as what we want it to do so that the results can be more accurate. Alright once we are done just press enter and let ChatGPT does its work. So the first version that I got here is an 11 question survey form, which looks okay.
It covers the things that I'm expecting it to do. It asks about the workshop content, it asks about the overall experience, it asks about the delivery, the logistics, everything looks fine. So the second step is to ask ChatGPT to turn this survey form into a Google form. So my prompt will be, please write a Google script that turns this survey form into a google form simple and straightforward again press enter and let chatgpt does its magic and not only it turns the survey form into a google script for us it has also comes with a simple tutorial to teach us how to use this script so let's try to follow the steps here and see whether it works or not so i'm going to open my google sheet and then start the blank spreadsheet and it's here at the extensions and then app script section so once you click that you'll open up another new tab which looks like a programming environment which has a place for us to type our code here and this is where we are going to paste the code from chat gpt to run and create our google form so let's go back to our chat gpt and then you scroll all the way to the top here and you can see copy code and copy the code and paste it here and then give it a name say automatic survey form so we have a project name let's save our project and now you can see that the run button is enabled so we just need to click run the selected function and if there's anything it will appear in the execution log here and now it's requesting for the permission to access our data because it will need to access our google forms to create a new form so just click review permissions and then select your gmail account and you just say you want to access your google account to view and manage our forms in google drive okay so this looks normal just click allow and then after a few seconds it says execution completed and the form is created as this url so i can just copy the url open it now we can see a complete google form is created all well section so section 1 section 2 section 3 all the questions including the formatting the types of button the types of input are all set up properly so all you need to do now is just to click the send button copy the url and send it to whoever you want to get their feedback or ask more information to become your potential customers now we have a working form already so let's say we send it to our colleague boss or supervisor and ask for their feedback your colleagues think that the form is a bit too long and people might not want to fill out such a long window form just to give some feedback and your boss wants to ask some questions that's related to teaching quality so let's go back to chat GPT and then now we can say please reduce the questions to five questions only and add a question that is related to teaching quality okay so again let chat gpt does its magic and wait for the code to be generated completely and now we can go back to our browser go back to google sheets start a new spreadsheet same thing extensions app script copy the code paste it save and run it give the right permissions that's needed okay now it says our form has been created so let's take a look at the new form so it has now been reduced to one two three four five five questions and there's one question here that asks us to read our instructor knowledge and presentation skills and the other question still a good mix of long answer tags and also some of the survey questions like how satisfied are you how do you rate the quality so it becomes a more concise and only within five questions which means that people are more likely to fill up the form all right you can now customize the form like a normal google form add pictures change the colors to suit your corporate branding now if i'm feeling adventurous you can also look into the code that's generated by chat gpt it's pretty straightforward and you can edit it from there and run the code again, you will get another new Google Form. This is a technique that we teach in our AI Supercharged Bootcamp to boost your productivity.
Hope you find it useful. Go ahead, give it a try. Let me know if you have any questions. It's Dr Lau here.
I'll see you in the