Created
July 30, 2024 19:48
-
-
Save greenido/663ce331983a599b8c7bef0a839a4350 to your computer and use it in GitHub Desktop.
convert a good doc (with questions) to a google form you can share and collect data
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function createSecurityToolsSurvey() { | |
| // Create a new form | |
| var form = FormApp.create('Security Tools Survey for SMB CTOs'); | |
| // Set the form description | |
| form.setDescription('We are conducting a survey to understand the security tools used by startups and SMBs. Your input is valuable in helping us assess current trends in cybersecurity practices. Please select the option that best describes the tools your organization is currently using for each category. If you aren\'t using a tool - please feel free to skip the question.\n\nThank you for taking the time to help us!'); | |
| // Add questions to the form | |
| addMultipleChoiceQuestion(form, 'Which Endpoint Protection (Antivirus/Anti-Malware) solution does your organization primarily use?', ['CrowdStrike Falcon', 'Symantec Endpoint Protection', 'McAfee Endpoint Security', 'Other']); | |
| addMultipleChoiceQuestion(form, 'What Endpoint Detection and Response (EDR) tool do you employ?', ['Carbon Black (VMware)', 'Microsoft Defender for Endpoint', 'SentinelOne', 'Other']); | |
| addMultipleChoiceQuestion(form, 'Which Mobile Device Management (MDM) solution do you use?', ['Microsoft Intune', 'Jamf Pro', 'VMware Workspace ONE', 'Other']); | |
| addMultipleChoiceQuestion(form, 'What Virtual Private Network (VPN) does your organization rely on?', ['Cisco AnyConnect', 'Palo Alto GlobalProtect', 'OpenVPN', 'Other']); | |
| addMultipleChoiceQuestion(form, 'Which Data Loss Prevention (DLP) tool have you implemented?', ['Forcepoint DLP', 'Symantec DLP', 'Digital Guardian', 'Other']); | |
| addMultipleChoiceQuestion(form, 'What Disk Encryption solution do you use?', ['BitLocker (Microsoft)', 'VeraCrypt', 'McAfee Complete Data Protection', 'Other']); | |
| addMultipleChoiceQuestion(form, 'Which Patch Management tool does your organization employ?', ['ManageEngine Patch Manager Plus', 'Ivanti Patch for Endpoints', 'Microsoft SCCM (System Center Configuration Manager)', 'Other']); | |
| addMultipleChoiceQuestion(form, 'What Secure Web Gateway solution have you implemented?', ['Zscaler Internet Access', 'Cisco Umbrella', 'Symantec Web Security Service', 'Other']); | |
| addMultipleChoiceQuestion(form, 'Which Password Management tool does your organization use?', ['LastPass', '1Password', 'Bitwarden', 'Dashlane', 'Other']); | |
| addMultipleChoiceQuestion(form, 'What Remote Desktop Access solution do you primarily rely on?', ['TeamViewer', 'AnyDesk', 'Chrome Remote Desktop', 'Other']); | |
| // Add a thank you message at the end | |
| form.addSectionHeaderItem().setTitle('Thank you for your participation in this survey. Your responses will help us better understand the cybersecurity landscape for SMBs.'); | |
| Logger.log('Form created. You can access it at: ' + form.getPublishedUrl()); | |
| } | |
| function addMultipleChoiceQuestion(form, title, choices) { | |
| var item = form.addMultipleChoiceItem(); | |
| item.setTitle(title) | |
| .setChoices(choices.map(choice => item.createChoice(choice))) | |
| .showOtherOption(true); | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment