In WeezCrew, the API tab lets you generate a dynamic data stream formatted as an accreditations matrix that connects directly to Microsoft Excel or Google Sheets. This cross-referenced grid provides a panoramic overview, allowing you to verify at a glance who is accredited, for which zones, and during which specific time slots.
Why Use the Accreditations Matrix?
Instant Cross-Referenced View: See every member's (first and last name) complete set of access permissions mapped across zones and time slots in one unified grid.
Dynamic Updates: Any permission modification, addition, or revocation in WeezCrew automatically propagates to your external spreadsheet without manual re-exports.
Security and Access Control: Streamline credential verification with security teams and restricted-zone managers before and during your event.
Step 1: Access the Accreditations Matrix Feed
Log in to your event workspace on WeezCrew.
In the left navigation menu, open Options > API.
Locate the section titled Member Accreditations Matrix.
Click the button to customize your export parameters.
Step 2: Filter and Customize Matrix Data
Adjust your export filters to display only the permissions required for your audit:
Spreadsheet Format: Select the output format designed for Microsoft Excel or the dynamic formula for Google Sheets.
Date Filters: Set a start date and end date to restrict the matrix to a single operational day or a specific highlight window of your event.
Field Selection: Check the supplementary profile attributes you want displayed alongside each member's first and last name.
Access Scope: Filter by accreditation categories or select the exact accreditations and time slots you need to verify.
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 the very first cell (
A1), replacing the placeholder with your copied URL:=IMPORTDATA("YOUR_WEEZCREW_API_URL")Press Enter. The cross-referenced matrix populates automatically with the member roster and all corresponding zone and time slot access rights.