In WeezCrew, the API tab lets you export and synchronize all shifts and time slots for your event in real time into Microsoft Excel or Google Sheets. This dynamic data feed updates automatically whenever you add, edit, or delete a shift or time slot, providing continuous visibility into your operational staffing requirements.
Why Use the Shifts API Feed?
Real-Time Syncing: Eliminates manual CSV exports whenever schedules, locations, or headcount quotas change.
Complete Operational Visibility: Consolidates shift titles, categories, time slots, GPS coordinates (latitude and longitude), tags, and custom fields into a single live table.
Live Staffing Tracking: Automatically monitors required headcount, assigned volunteer counts, duration volume (in minutes), and fill rates per time slot.
Step 1: Access the Shifts API Feed
Log in to your event workspace on WeezCrew.
In the left navigation menu, open Options > API.
Scroll down to locate the Shifts section.
Step 2: Customize Export Parameters
Before copying your integration URL, tailor the dataset to match your reporting needs:
Spreadsheet Format: Select the output format designed for either Microsoft Excel or Google Sheets.
Include Assigned Members: Toggle whether to include detailed lists of volunteers currently scheduled on each shift.
Field Selection: Check the specific shift custom fields and metadata attributes you want included in your spreadsheet columns.
Step 3: Embed the Formula in Google Sheets
Copy the generated Google Sheets API URL from WeezCrew.
Open a blank spreadsheet in Google Sheets.
Paste the following formula into cell
A1(replacing the placeholder with your copied URL):=IMPORTDATA("VOTRE_LIEN_API_WEEZCREW")Press Enter. The spreadsheet populates automatically with shift IDs, titles, categories, time slots, and real-time fill metrics.
Step 4: Format Date and Time Columns (Google Sheets Tip)
As with other dynamic API data streams, start and end timestamp columns may initially display as raw serial numbers. To fix the display formatting:
Highlight the start date and end date columns.
Open the top menu and select Format > Number.
Choose Date time (or your preferred date/time display format).