Cisco Switch Automation

Looking to have a web based tool which can be used to configured Cisco switches based on port templates on a drop down list and also based on information stored in a Google Spreadsheet. Would be great if it could also discover online switches