How to Send Zoom Attendance Data Anywhere Using BlueSky and Zapier

Send Zoom Attendance Data Anywhere Using BlueSky and Zapier

You can easily send attendance data from your Zoom meetings to other applications—like Google Sheets—by using the BlueSky Attendance Taker and connecting it to Zapier. Here's a step-by-step guide to set it up:

1. Install the BlueSky Attendance Taker App in Zoom

First, make sure the BlueSky Attendance Taker is installed in your Zoom account. Once installed, it will appear in the apps bar within any Zoom meeting. This app automatically tracks who joins your meetings and for how long.

INSTALL THE APP HERE: https://marketplace.zoom.us/apps/VFbMBZjDRh6cofA7CmN5bQ

2. Connect the App to Zapier

1. Open the Attendance Taker inside a Zoom meeting.
2. Scroll to the section labeled "Connect to Zapier" and click it.
3. This will open a new window in Zapier, where you’ll start creating a new automation (Zap).

3. Set Up the Zap Trigger in Zapier

1. In Zapier, search for and select Videoconference Attendance Taker by BlueSky as the app.
2. Choose the trigger event: “Zoom Meeting Attendance Taker Record.”
3. When prompted to connect your account, return to the BlueSky app inside Zoom.
4. Copy the ID and Access Key provided.
5. Paste those into Zapier to authorize the connection.
6. Continue, and test the trigger to make sure it pulls in a sample attendance record.

4. Choose a Destination App (Example: Google Sheets)

Once the trigger is set, choose what you want to do with the attendance data. For example, you can send it to a Google Sheet:

1. Select Google Sheets as the action app.
2. Choose the event “Create Multiple Spreadsheet Rows.”
3. Connect your Google account if it’s not already connected.
4. First create a worksheet where you want the data to go, with a cell labeled for each type of data (eg Name, Email, Time in Meeting, Meeting Date).
5. Select this spreadsheet and worksheet where you want the data to go.

5. Map the Attendance Fields

Create or select a Google Sheet with columns such as:

• Name
• Email
• Time in Meeting
• Meeting Date

Then, map each field from the attendance record to the corresponding column in your sheet:

• Display Name → Name
• Attendee Email → Email
• Time in Meeting → Time
• Timestamp → Meeting Date

Additional fields are available if you want to capture more data.

6. Test and Publish

After mapping, run a test in Zapier to make sure the data shows up correctly in your sheet. If everything looks good:

1. Click Continue, then Test Step.
2. Check your Google Sheet to verify the test data was added.
3. Click Publish to activate your automation.

From now on, every time a Zoom meeting ends, attendance data will automatically flow into your spreadsheet (or any other app you choose). This setup saves time, reduces manual work, and ensures your records are always up to date.