➤ Product: OfficeRnD Flex with the Visitor Hub add-on
➤ Who: Admins with the 'Owner' role
➤ Where: In Zapier. You do not configure anything on the Admin Portal
➤ Availability: Start, Grow, and Scale plans. Essentials does not include Zapier or Visitor Hub.
Without Zapier, your team must manually copy each checked-in visitor into your CRM. Each person on a pre-registration spreadsheet must also be typed into the Visitor Log. The OfficeRnD app in Zapier sends each visitor check-in to your CRM. The app also creates visitors in Flex from spreadsheet rows.
The Visitor Hub steps use the same OfficeRnD connection as every other Zap in Zapier. Connect Flex to Zapier before you build these Zaps →
In this article:
Send checked-in visitors to HubSpot
Send only the visitors who opt in
Pre-register visitors from Google Sheets
Prerequisites
Before you build these Zaps, ensure that you have these items:
Visitor Hub in your Flex 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 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 flow in the Visitor Flow field. The trigger data includes answers to the visitor flow's custom fields. Flex sends every custom field answer as text.
The Create Visitor action creates a visitor in Flex. 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.
Create Visitor is the only Visitor Hub action. A Zap cannot check out a visitor or change an existing visit in Flex.
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 Flex.
Trigger: OfficeRnD | Action: HubSpot |
New Visitor Check-In starts the Zap when a visitor checks in. In the Visitor Flow field, select the 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. |
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
A Zap with only a trigger and an action sends every checked-in visitor to HubSpot. 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 visitor flow custom fields. For example, the question 'Do you want to opt in to our newsletter?' with the answer 'Yes'. A Zap with a filter step has 3 steps. Zaps with 3 steps need a paid Zapier plan.
Open the Zap that sends checked-in visitors to HubSpot.
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.
In the filter condition, select the custom field of the opt-in question from the trigger data.
Select the (Text) Contains condition. Flex sends every custom field answer as text. Only a text condition can match the answer.
Enter
Yesas the value. The Zap continues only for visitors whose answer contains 'Yes'.Test the filter step. The test shows whether a sample check-in continues or stops.
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 Flex 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. The location and the visitor flow can be 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 Flex. Select the location in the Location field and the 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
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 application in Flex 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. Flex 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 Flex 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 Flex?
A Zap cannot check out a visitor or change a visit in Flex. Create Visitor is the only Visitor Hub action in Zapier. The action creates a new visitor. To check out a visitor, use the Visitor Log or the Visitor app.
