Skip to main content

How to Export and Synchronize Member Accreditations via the WeezCrew API (Excel & Google Sheets)

In WeezCrew, the API tab lets you export and synchronize all member accreditations for your event in real time into Microsoft Excel or Google Sheets.

In WeezCrew, the API tab lets you export and synchronize all member accreditations for your event in real time into Microsoft Excel or Google Sheets. With this dynamic data stream, your spreadsheet updates automatically whenever a profile is accredited, modified, or scanned on site, eliminating repetitive CSV exports.


Why Use the Accreditations API Feed?

  • Dynamic Synchronization: Every newly approved accreditation appears immediately in your external spreadsheet.

  • Complete Status Visibility: Monitor approved, pending, and processed requests live.

  • Access & Check-In Tracking: Verify granted access rights and time slots alongside real-time scan status at entry checkpoints.


Step 1: Access the Accreditations API Feed

  1. Log in to your event workspace on WeezCrew.

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

  3. Locate the Member Accreditations section.

  4. Click the export customization button.


Step 2: Customize Export Criteria and Columns

Tailor the dataset so your spreadsheet retains only the information essential for on-site coordination:

  • Spreadsheet Format: Select the output format designed for Microsoft Excel or the dynamic formula for Google Sheets.

  • Date Filter: Isolate accreditations valid for a single event day or a specific operational window.

  • Application Statuses: Choose to display only confirmed/accredited members or expand the feed to include pending and received applications.

  • Custom Fields: Check the profile attributes you want included as columns (contact information, organization, job title, etc.).

  • Accreditation Scope: Select all event accreditations or filter by specific categories and access time slots.


Step 3: Embed the Formula in Google Sheets

  1. Once configured, copy the generated Google Sheets API URL from WeezCrew.

  2. Open a blank spreadsheet in Google Sheets.

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

    =IMPORTDATA("YOUR_WEEZCREW_API_URL")

  4. Press Enter. Your complete accreditation roster populates instantly across the workbook.


Step 4: Format Dates and Monitor Live Scans (Google Sheets Tip)

  1. Fix Date Display: Because timestamps may initially appear as plain text or raw serial numbers, select the relevant date columns, then open Format > Number > Date time.

  2. Live Access Control: Monitor the dedicated scan status column to track real-time on-site entries during your event.

Did this answer your question?