Halloween coordination without the group-text chaos

A free trick-or-treat map for getting candy to every house.

Create your Halloween candy map from a prepared Google Sheet, enter the participating addresses, and publish a volunteer-ready delivery map. Your Sheet stays private. The map is free to run.

About 10 minutes. No AI, coding, GitHub, Vercel, API key, or payment required. The optional kit includes the implementation files.

Your own copyThe spreadsheet and software belong to your Google account.
Private databaseVolunteers see the map, not the organizer’s Sheet.
Shared progressEveryone sees which deliveries are complete.

Setup

Four things to do.

Everything is already built. You are making your own copy and adding your town’s information.

  1. 1

    Make your private copy

    Click Make my Candy Map, then choose Make a copy on Google’s screen. The prepared tabs and Candy Map software are included automatically.

  2. 2

    Enter your town and addresses

    In Settings, enter the town, state, ZIP code, and year. In Locations, add one house per row using Street, Number, Amount, and optional Notes. Leave the hidden coordinate columns alone.

  3. 3

    Prepare the map

    Choose Candy Map → Set volunteer access code, then Candy Map → Prepare / validate map. The first time, Google asks permission to run the software attached to your Sheet. Choose Review permissions, confirm your primary account, and continue.

  4. 4

    Publish the volunteer website

    Choose Extensions → Apps Script. In the Apps Script page choose Deploy → New deployment → Web app. Leave Execute as set to Me, choose Anyone, deploy, and copy the URL ending in /exec.

The unfamiliar Google screen

Why Google asks permission

Google Apps Script is the private back end that creates the map, places the addresses, hosts the volunteer website, and records deliveries. It runs inside the Google account that owns your copied Sheet.

The permission should say it can view and manage spreadsheets where this application is installed. Candy Map does not need access to every spreadsheet in your account.

Common questions

What you should know

Do I need ChatGPT, Claude, Gemini, or Codex?

No. AI was used to build Candy Map, but the finished template works on its own.

Does this cost anything?

No paid service is required. It uses Google Sheets and Google Apps Script within Google’s standard account limits.

Should I share my spreadsheet with volunteers?

No. Keep the spreadsheet private. Share only the final website URL and your volunteer access code.

What address format should I use?

Put the street name in Street, the house or building number in Number, a whole number of candy pieces in Amount, and any short delivery instruction in Notes.

Ready to make yours?

Make my Candy Map Get the complete leverage kit