9 Google Forms

9.1 Section title

As spring break approached, the club planned its first official meeting, The Spring (Ground) Break kickoff, where students and community members could tour the garden site, meet one another, and choose the roles they were most excited about. To keep things organized, you and the team decided to collect sign‑ups ahead of time using a simple online form, shared through flyers and posters around campus with a QR code that linked directly to it. People could still sign up in person at the event, but having most volunteers register beforehand would help you estimate attendance, prepare materials, and group people by interest. It was the perfect moment to introduce a tool that would soon become essential to the club’s workflow: using Google Forms to gather clean, structured information that could flow straight into your spreadsheets, and eventually, into your automated systems.

Along with other contact information, the club wants to know what people are interested in learning about, so the sign up form also needs a section where people can mark their interests.

• Home Food Growing: Turning patios, balconies, and backyards into productive mini‑gardens.
• Community Gardening: Learning collaborative growing techniques while contributing to shared harvests.
• Sustainable Living: Everyday practices that reduce waste, conserve resources, and support local ecosystems.
• Teaching Through Gardening: Gaining skills you can pass on to friends, family, and future students.
• Nutrition & Wellness: Understanding how fresh produce supports a healthy lifestyle.
• Houseplant Care: Keeping indoor plants thriving using light, soil, and watering strategies.
• Organic Gardening: Growing without synthetic chemicals using compost, mulch, and natural amendments.
• Hydroponics Basics: Raising herbs and greens in water‑based systems at home.
• Responsible Pest Management: Using safe, targeted methods to protect plants without harming the environment.
• Microgreens & Sprouts: Growing nutrient-dense greens on a windowsill.
• Vertical Gardening: Using pallets or trellises for those with small plots.
• Container Gardening: Best vegetables for pots and buckets.
• Hydroponics 101: Growing plants in water without soil.
• Organic Pest Control: Using neem oil, ladybugs, and companion planting instead of chemicals.
• Composting & Vermiculture: Turning kitchen scraps into "Black Gold" using worms.
• Rainwater Harvesting: How to set up barrels to save on the garden's water bill.
• Native Plant Restoration: Attracting local birds and butterflies.
• Heirloom Seeds: The history and art of seed saving for next year’s harvest.
• Pollinator Gardens: Specifically designing plots for bees and monarch butterflies.
• Mushroom Cultivation: Growing oyster or shiitake mushrooms in shaded areas.
• Medicinal Herbs: Growing a "healing garden" with lavender, echinacea, and mint.
• Farm-to-Table Cooking: What to do with a massive harvest of zucchini.
• Canning & Preservation: Pickling, drying, and fermenting the garden’s bounty.
• Garden Photography: Capturing the beauty of the College Community Garden.
• Therapeutic Horticulture: Gardening for mental health and stress relief.

You need to make a form for the Spring event, let’s do that.

Start with a short text box for the first name, and one for the last name, then add one for an email and one for a phone number. Finally, make a set of checkboxes asking about the things the person filling out the form might be interested in, feel free to use the examples above. [SO LETS SHOW YOU HOW TO BUILD THE FORM]

Although it is possible to create a form independently from a Google sheet, we are going to build this one from inside our sheet so the form is already linked to the sheet.