Lecture Notes: Creating a Survey Form with Google Forms and ChatGPT
Introduction
Automatic creation of survey forms using Google Forms and ChatGPT.
Useful for collecting leads and feedback.
Applicable for events, marketing campaigns, and training programs.
Steps to Create a Survey Form
Step 1: Use ChatGPT to Generate a Survey Form
Website: Start at chatgpt.com.
Prompt: Example prompt: "Please create a survey form for a data science workshop conducted over two days covering big data analytics, data visualizations, and predictive analytics."
Importance of providing specific prompts to achieve accurate results.
Outcome: ChatGPT generates an 11-question survey covering workshop content, experience, delivery, logistics, etc.
Step 2: Convert Survey Form to Google Form
Prompt: "Please write a Google script to turn this survey form into a Google form."
Process:
ChatGPT provides a Google script with a tutorial.
Open Google Sheets, start a blank spreadsheet.
Navigate to Extensions > App Script.
Paste the script code from ChatGPT.
Name the project and save it.
Run the script and grant necessary permissions.
Copy and open the generated Google Form URL.
Step 3: Customize the Google Form
Feedback:
If the form is too long, reduce the number of questions.
Add new questions if needed (e.g., teaching quality).
Modification:
Request ChatGPT to adjust the form (e.g., reduce to 5 questions and add a teaching quality question).
Follow the same process to update the Google Form.
Customization Options
Add pictures, change colors to match corporate branding.
Edit the script code if desired.
Conclusion
This technique enhances productivity and is taught in AI Supercharged Bootcamp.
Encouragement to try the method and reach out with questions.