Configuring AP's on a Cisco 9800 Controller using a Google Sheet

Using Ansible to configure AP’s on a Cisco 9800 Controller using a Google Sheet I work for a university with nearly 10000 AP’s and growing. There is a steady amount of new construction in addition to replacing older technology on a ~ 5 year cycle. I recently discovered Ansible and have been using it to upgrade ios on switches and build some utilities for provisioning ports. Spending a lot of time configuring AP’s I thought I would try to build some efficiencies using Ansible. I started building some scripts to apply tags, but eventually I got ambitious and thought maybe I could apply all the configuration options from a Google Sheet without even accessing the controller gui. I am going to detail and document the process. BTW, thanks to all those who post examples, youtube videos, and the like. It has been very helpful and motivated me to share this process. This Ansible script will read information from a Google sheet and make the following changes: Apply Names Apply Locations Change t...