Skip to main content

How to verify the Accreditations Matrix via the WeezCrew API (Excel & Google Sheets)

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.

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

  1. Log in to your event workspace on WeezCrew.

  2. In the left navigation menu, open Options > API.

  3. Locate the section titled Member Accreditations Matrix.

  4. 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

  1. Copy the generated Google Sheets API URL from WeezCrew.

  2. Open a blank spreadsheet in Google Sheets.

  3. Paste the following formula into the very first cell (A1), replacing the placeholder with your copied URL:

    =IMPORTDATA("YOUR_WEEZCREW_API_URL")

  4. Press Enter. The cross-referenced matrix populates automatically with the member roster and all corresponding zone and time slot access rights.

Did this answer your question?