Skip to main content

Connect Visitor Hub to other apps through Zapier

Send each check-in to your CRM and pre-register people from a spreadsheet without manual entry.

Written by Yasen Marinov

➤ Product: OfficeRnD Flex or OfficeRnD Workplace, with the Visitor Hub add-on

➤ Who: Admins

➤ Where: In Zapier. You do not configure anything on the Admin Portal

➤ Availability:

-> Flex: Start, Grow, and Scale plans. Essentials does not include Zapier.

-> Workplace: All plans.

Without Zapier, your team copies each checked-in visitor into your CRM by hand. Your team also types each pre-registered person into the Visitor Log. The OfficeRnD app in Zapier sends each visitor check-in to your CRM, and it creates visitors from spreadsheet rows.

OfficeRnD Flex and OfficeRnD Workplace use the same OfficeRnD app in Zapier. The Zaps in this article work the same way in both products. Connect Flex to Zapier before you build these Zaps →


In this article:

  • Which OfficeRnD products the Visitor Hub steps in Zapier work in

  • Why the HubSpot Zap also sends visitors who did not opt in

  • Which spreadsheet columns pre-registration needs

  • What a Zap cannot change on an existing visit

  • Not covered here: how to connect OfficeRnD to Zapier. Connect Flex to Zapier →


Prerequisites

Before you build these Zaps, ensure that you have these items:

  • Visitor Hub in your OfficeRnD Flex or OfficeRnD Workplace organization. The Visitor Hub steps use Visitor Hub check-ins and visitor flows.

  • An OfficeRnD connection in Zapier, made with the email and password of an organization owner. Zapier does not accept the account of an admin who is not an organization owner.

  • A paid Zapier plan for the opt-in workflow. The opt-in workflow has 3 steps. Zapier allows Zaps with more than 2 steps only on paid plans.

  • A HubSpot account for the CRM workflow.

  • A Google account with a Google Sheets spreadsheet for the pre-registration workflow.


How the Visitor Hub steps in Zapier work

The OfficeRnD app has 1 trigger and 1 action for Visitor Hub. Both steps work the same way in OfficeRnD Flex and OfficeRnD Workplace. Both steps use the same OfficeRnD connection as every other OfficeRnD step.

The New Visitor Check-In trigger starts a Zap when a visitor checks in. To limit the trigger to 1 location, select the location in the Location field. To limit the trigger to 1 visitor flow, select the visitor flow in the Visitor Flow field. The trigger data includes the answers to the custom fields of the visitor flow. OfficeRnD sends every custom field answer as text.

The Create Visitor action creates a visitor in OfficeRnD. The action requires values in the Location, Visitor Name, Visitor Flow, Start Time, and End Time fields. The Visitor Email, Visitor Company, Visitor Phone, and Host fields are optional.


Send checked-in visitors to HubSpot

This Zap creates a HubSpot contact for each visitor who checks in. Your marketing team then has every visitor in HubSpot, with no manual copy from OfficeRnD.

Trigger: OfficeRnD

Action: HubSpot

New Visitor Check-In starts the Zap when a visitor checks in. In the Visitor Flow field, select the visitor flow to send. For example, select Meeting Attendee.

Create or Update Contact creates a HubSpot contact or updates the contact with the same email. Map the visitor email from the trigger data to the HubSpot email field. HubSpot uses the email to find an existing contact.

This Zap sends every visitor in the selected visitor flow to HubSpot. The Zap also sends visitors who did not agree to marketing emails.


Send only the visitors who opt in

To send only the visitors who agree to marketing emails, add a filter step between the trigger and the action.

This workflow uses an opt-in question in the custom fields of the visitor flow. For example, the visitor flow asks Do you want to opt in to our newsletter?, and the visitor answers Yes. A Zap with a filter step has 3 steps. Zaps with 3 steps need a paid Zapier plan.

  1. Open the Zap that sends checked-in visitors to HubSpot.

  2. Add a Filter by Zapier step between the New Visitor Check-In trigger and the HubSpot action. The filter decides which check-ins continue to HubSpot.

  3. In the filter condition, select the custom field of the opt-in question from the trigger data.

  4. Select the (Text) Contains condition. OfficeRnD sends every custom field answer as text. Only a text condition can match the answer.

  5. Enter Yes as the value. The Zap continues only for visitors whose answer contains Yes.

  6. Test the filter step. The test shows whether a sample check-in continues or stops.

  7. Click Publish. The filter applies only after you publish the Zap.


Pre-register visitors from Google Sheets

If your team lists expected visitors in a spreadsheet, this Zap creates each visitor in OfficeRnD from a new row. The visitor is then on the Visitor Log before the visit starts.

The spreadsheet needs a column for each value that changes from visitor to visitor: visitor name, start time, and end time. For example, use the columns Name, Email, Arrival, and Departure. If all visitors on the spreadsheet come to the same location with the same visitor flow, select the location and the visitor flow as fixed values in the Zap.

Trigger: Google Sheets

Action: OfficeRnD

New Spreadsheet Row starts the Zap when your team adds a row to the spreadsheet.

Create Visitor creates the visitor in OfficeRnD. Select the location in the Location field and the visitor flow in the Visitor Flow field. Map the name, start time, and end time columns to the Visitor Name, Start Time, and End Time fields.

If the spreadsheet has an email column, map the email column to the Visitor Email field too. The visitor record then has a contact email.


FAQs

Does Zapier for Visitor Hub work in OfficeRnD Workplace?

The Visitor Hub steps in Zapier work in OfficeRnD Workplace and in OfficeRnD Flex. Both products use the same OfficeRnD app in Zapier, with the same New Visitor Check-In trigger and the same Create Visitor action.

Do the Visitor Hub steps in Zapier still need a Client ID and Client Secret?

The Visitor Hub steps do not need a Client ID and Client Secret. The New Visitor Check-In trigger and the Create Visitor action use the same OfficeRnD connection as all other OfficeRnD steps. You connect with the email and password of an organization owner. You do not create an API application in OfficeRnD for Zapier. You also do not grant API scopes to Zapier.

Why does my filter stop every visitor, even when the answer is Yes?

Your filter stops every visitor because the filter condition does not compare text. OfficeRnD sends every custom field answer as text. To fix the filter, select the (Text) Contains condition, and enter Yes as the value.

Why does my Zap start some minutes after a visitor checks in?

Your Zap starts later because New Visitor Check-In is a polling trigger. Zapier checks OfficeRnD for new check-ins every 1 to 15 minutes, based on your Zapier plan.

Can a Zap check out a visitor or change a visit in OfficeRnD?

A Zap cannot check out a visitor or change a visit in OfficeRnD. Create Visitor is the only Visitor Hub action in Zapier, and it creates only new visitors. To check out a visitor, use the Visitor Log or the Visitor app.

Did this answer your question?