Google Maps API Key Required
Configure your API key to enable the map
Configure your API key to enable the map
Get your API key from the Google Cloud Console. Enable the Maps JavaScript API, Geocoding API, and Places API.
Connect to a Google Sheet to sync providers across multiple computers.
Found in the URL: docs.google.com/spreadsheets/d/[SPREADSHEET_ID]/edit
Required to add/edit/delete providers. See setup instructions below.
ID | Type | TypeColor | Status | Facility | Provider | Phone | Address | Lat | Lng | Hours1 | Hours2
function doPost(e) {
try {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
if (!e || !e.postData || !e.postData.contents) {
return ContentService
.createTextOutput(JSON.stringify({ success: false, error: 'No data received' }))
.setMimeType(ContentService.MimeType.JSON);
}
const data = JSON.parse(e.postData.contents);
if (data.action === 'sync') {
const lastRow = sheet.getLastRow();
if (lastRow > 1) {
// NOW 12 columns (A:L)
sheet.getRange(2, 1, lastRow - 1, 12).clearContent();
}
if (data.providers && data.providers.length > 0) {
const values = data.providers.map(p => ([
p.id,
p.type,
p.typeColor || '', // TypeColor
p.status || 'Active', // Status
p.facility,
p.provider,
p.phone,
p.address,
p.lat,
p.lng,
p.hours1 || '8:00am - 5:00pm', // ✅ Hours1 (default)
p.hours2 || '' // ✅ Hours2 (optional)
]));
// NOW 12 columns (A:L)
sheet.getRange(2, 1, values.length, 12).setValues(values);
}
}
return ContentService
.createTextOutput(JSON.stringify({ success: true }))
.setMimeType(ContentService.MimeType.JSON);
} catch (error) {
return ContentService
.createTextOutput(JSON.stringify({ success: false, error: error.toString() }))
.setMimeType(ContentService.MimeType.JSON);
}
}
function doGet(e) {
return ContentService.createTextOutput('Web App is running. Use POST to sync data.');
}
Edit or delete provider categories. Deleting a category will move any providers in that category to Uncategorized.
Upload a CSV file with columns: Type, Facility, Provider, Phone, Address
Click to upload CSV file
or drag and dropImporting providers...
Are you sure you want to delete this provider?