Showing results for 
Search instead for 
Did you mean: 
Find others in government and higher education solving problems with Google Cloud

Vaccine Distribution App Templates (AppSheet)

Vaccine Distribution App Templates (AppSheet)

Challenge: Local state and city agencies need better tools to help citizens understand vaccine availability and coordinate distribution based on eligibility.

Solution: AppSheet is a no-code app development platform that organizations use to help improve how employees, customers and the public interact with Workspace data.

Two app templates that connect to a single Google Sheet help provide local agencies a starting point for coordinating vaccine distribution to citizens.

Citizen-facing app template for submitting personal info & determining eligibility

Feature include:

  • SMS or Email confirmation based on preferred communication
  • Calculates citizen’s vaccination eligibility phase
  • Logs user details to Google Sheet

Internal employee-facing management app template for monitoring citizen inquiries and scheduling appointments

Features include:

  • Dashboard of inquiries broken out by eligibility Phase
  • Quick actions for calling, emailing or texting
  • Appointment scheduling - once scheduled, name gets crossed out
  • Calendar of appointments
  • Manual new inquiry form (for submitting via the phone with citizen)

These apps can be copied and used by anyone as a starting point for their own vaccine distribution efforts. Look for the ‘Copy app’ link in the upper-left of the editor while viewing the template.


These vaccine distribution template apps are meant to be copied and customized to your organization’s specific requirements before being deployed. Deployed applications require user licenses that vary based on app features included. If your organization is subscribed to a Workspace Enterprise Plus account, AppSheet Pro licenses are included, otherwise licensing can be obtained via the AppSheet account settings.

'Public Apps' can be made available to an unlimited number of visitors for $50/mo, with a 'Publisher Pro' subscription. This subscription requires a dedicated AppSheet account, separate from an account used to manage licensed users (internal use). More details are available at

If you are a larger organization and/or are looking for an integrated vaccine solution that includes forecasting, modeling, and sentiment analysis, the Intelligent Vaccine Impact Solution is also a great option.   

How to get support:

AppSheet community

Talk to sales

Labels (1)
Version history
Revision #:
4 of 4
Last update:
‎02-10-2021 03:53 PM
Updated by:
Community Manager