# How to Send RB2B Visitor Data to Google Sheets Using Make.com

---

RB2B tells you which people and companies are visiting your website. The data is useful, but it's only valuable if your team can actually use it. A Google Sheet is one of the easiest places to share, filter and review that data.

In this guide, you'll connect RB2B to Google Sheets using [Make.com](http://Make.com) so that every identified visitor is added as a new row in real time, with no copy-pasting and no CSV exports.

## What You'll Build

A two-module [Make.com](http://Make.com) scenario:

1. **RB2B Webhook, On RB2B Event:** fires every time RB2B identifies a visitor.
2. **Google Sheets, Add a Row:** writes that visitor's details into your spreadsheet.

## What You Need

- An RB2B account with the [Make.com](http://Make.com) integration available
- A [Make.com](http://Make.com) account
- A Google account and a blank Google Sheet

## Step 1: Install the RB2B App in [Make.com](http://Make.com)

1. In RB2B, go to **Integrations →** [**Make.com**](http://Make.com).
2. Click **Install RB2B's** [**Make.com**](http://Make.com) **App**. This opens Make and adds the app to your organization.
3. In Make, open **Organization → Installed apps** and confirm **RB2B Webhook** is listed.

## Step 2: Prepare Your Google Sheet

Create a new sheet and add these headers in row 1:

| Column | Example |
| --- | --- |
| Seen At | 2026-11-13T19:34:36 |
| First Name | Adam |
| Last Name | Robinson |
| Title | CEO |
| Company Name | [Retention.com](http://Retention.com) |
| Business Email | [adam@retention.com](mailto:adam@retention.com) |
| LinkedIn URL | [linkedin.com/in/](http://linkedin.com/in/)... |
| Website | <https://retention.com> |
| Industry | Internet Technology & Services |
| Employee Count | 1-10 |
| Estimate Revenue | $22M rev |
| City | Austin |
| State | Texas |
| Zipcode | 73301 |
| Referrer | <https://google.com> |
| Captured URL | <https://yoursite.com/pricing> |
| Tags | Hot Page, Hot Lead |
| Visitor Type | Person / Company |

## Step 3: Create the Scenario in Make

1. Click **Create scenario**.
2. Click the **+** and search for **RB2B Webhook**.
3. Choose the trigger **On RB2B Event**.
4. Click **Add** to create a new webhook, give it a name such as `RB2B Visitors`, and save.
5. Copy the **webhook URL** Make generates.

## Step 4: Connect RB2B to the Webhook

1. Go back to **RB2B → Integrations →** [**Make.com**](http://Make.com).
2. Paste the webhook URL into the **Webhook URL** field.
3. Turn the **Status** toggle on.
4. Click **Save**.

### Capture Company-Level Visitors Too

RB2B can identify a company even when it can't identify the individual. To receive those visits, enable **Sync company-only profiles** in the integration settings.

### Repeat Visitors

There is also a **Send repeat visitor data** option. When it's on, RB2B sends every return visit. Leave it off unless you're ready to handle duplicates (see the tips below), because otherwise you'll get repeated rows for the same person.

## Step 5: Teach Make the Data Structure

1. In Make, click **Run once** so the scenario is listening.
2. In RB2B, click **Send a Test Event**.
3. Make will receive the test payload and detect all available fields.

RB2B sends a fixed set of fields with every request: LinkedIn URL, First Name, Last Name, Title, Company Name, Business Email, Website, Industry, Employee Count, Estimate Revenue, City, State, Zipcode, Seen At, Referrer, Captured URL and Tags. The payload can't be customized, so any renaming has to happen on the Make side.

## Step 6: Add the Google Sheets Module

1. Click the **+** after the RB2B module and add **Google Sheets → Add a Row**.
2. Connect your Google account.
3. Select your spreadsheet and sheet.
4. Map each column to the matching field from the RB2B module.
5. For **Visitor Type**, use a formula such as: `if(First Name; "Person"; "Company")`

Company-only profiles arrive without personal details, so an empty First Name tells you the record is a company.

## Step 7: Test and Go Live

1. Click **Run once** and send another test event from RB2B.
2. Check that a row appears in your sheet.
3. Delete the test row.
4. Turn the scenario **ON** and set scheduling to **Immediately**.

From now on, each identified visitor lands in your sheet within seconds.

## Optional: Separate People and Companies

If you'd rather keep personal and company-level visitors on different tabs:

1. Add a **Router** after the RB2B module.
2. **Route 1:** add a filter where **First Name exists** and send it to the "People" tab.
3. **Route 2:** add a filter where **First Name does not exist** and send it to the "Companies" tab.

## Optional: Prevent Duplicate Rows

If you turn on repeat visitor data:

1. Add **Google Sheets → Search Rows** and match on LinkedIn URL or Business Email.
2. Add a Router. If a row is found, use **Update a Row**. If not, use **Add a Row**.

## Importing Your Existing Visitors

The webhook only delivers **new** visitors from the moment you enable it. It doesn't backfill history. To bring in past data:

1. In RB2B, open **Exports** and download your person-level and company-level visitors as CSV files.
2. In Google Sheets, use **File → Import → Append to current sheet**.
3. Rename the CSV headers first, if needed, so they match your webhook columns.

Do this before you switch the scenario on, and dedupe on LinkedIn URL or email to avoid overlap.

## Things to Watch Out For

- **Missed payloads can't be resent.** If your Make scenario is off, or your RB2B billing has a problem, RB2B won't replay those events. Keep the scenario active.
- **Credits add up.** Each run in this setup uses 2 operations (one per module), so high-traffic sites will use credits quickly. Monitor your usage in Make.
- **Fields can be empty.** Many fields can be null, so check your mappings and avoid making any of them required.
- **HTTPS only.** RB2B needs a secure webhook URL. Make's URLs already meet this.

## Wrapping Up

With one trigger, one Google Sheets module and a few minutes of setup, you now have a live feed of the people and companies visiting your site, ready for filtering, sharing and follow-up. From here you can extend the scenario by sending Slack alerts for hot leads, pushing contacts into your CRM, or enriching rows before they hit the sheet.