[{"branchName":"Chattanooga","city":"Chattanooga","country":"US","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":116,"fieldName":"WorkingHours"},{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":116,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Chattanooga.jpg"}],"distance":0.0,"email":"chattanooga@mayerelectric.com","faxNum":"","latitude":"35.039787","locality":"Chattanooga, TN 37403-3100","longitude":"-85.297664","note":"Please contact your outside account manager after hours and on weekends for your emergency needs or our counter associate at (423)-355-8821","phone":"(423) 800-7750","state":"TN","street":"799 E 11th St","tollFreeNum":"","warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Chattanooga.jpg","workHour":"Monday-Friday 7:00am-5:00pm","zip":"37403-3100"},{"branchName":"Knoxville","city":"Knoxville","country":"US","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":77,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Knoxville.jpg"}],"distance":0.0,"email":"knoxville@mayerelectric.com","faxNum":"(865) 549-5757","latitude":"35.91206","locality":"Knoxville, TN 37917","longitude":"-84.15549","note":"Please contact your outside account manager after hours and on weekends for your emergency needs or our Branch Manager, Brad Weaver, at (423) 440-9489 or Operations Manager, Greg Keller at (865) 661-6114.","phone":"(865) 524-5566","state":"TN","street":"1501 Linden Avenue","tollFreeNum":"","warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Knoxville.jpg","workHour":"Monday-Friday 7:00am-5:00pm","zip":"37917"},{"branchName":"Nashville","city":"Nashville","country":"US","customFields":[{"customFieldID":0,"locCustomFieldValueID":0,"userCustomFieldValueID":0,"id":26,"fieldName":"WAREHOUSE_IMAGE","customFieldvalue":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Nashville.jpg"}],"distance":0.0,"email":"nashville@mayerelectric.com","faxNum":"(615) 913-4189","latitude":"36.10724","locality":"Nashville, TN 37204-3783","longitude":"-86.75556","note":"Emergency Number:(615) 416-2735","phone":"(615) 242-1100","state":"TN","street":"2944 Kraft Drive","tollFreeNum":"","warehouseImage":"/ASSETS/IMAGES/CMS/STATIC_IMAGES/static_images/Mayer-Nashville.jpg","workHour":"Monday-Friday 6:00am-4:00pm","zip":"37204-3783"}]

database

$googleSpreadSheetUrl