---
title: "Segmentation using Google Sheets"
slug: "segmentation-using-google-sheets"
updated: 2024-10-23T03:45:10Z
published: 2024-10-23T03:45:10Z
canonical: "support.whatfix.com/segmentation-using-google-sheets"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.whatfix.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Segmentation using Google Sheets

Whatfix enables you to segment content delivery to specific users based on attributes that you define, see [Segmentation Attributes](/hub/docs/segmentation-attributes). One way to achieve this is through Google Sheets integration, which enables content authors to manually manage and map User Attributes. Once the integration is complete, the Whatfix database stores user and enterprise data from the Google Sheet, which can then be used for content segmentation. This enables you to display specific content, such as Pop-ups, to selected users based on defined criteria.

## Steps for Segmentation using Google Sheets

> [!WARNING]
> Note:
> 
> Create a user attribute. These attributes will later be used to determine which users will see the targeted content. For more information, see [User Attributes](/hub/docs/user-attributes).

1. Create a new Google Sheet document.
2. Add the following columns to your sheet:

a. Laptop ID/ Device ID with user ID separated by a hyphen.

b. User Attributes - The value of this field must be a Yes or No. Use Yes against the Laptop IDs of Users you want to show the content to, and No for those you don’t want to.

![](https://cdn.document360.io/a268766e-d74d-4619-9613-e2472f809ffb/Images/Documentation/Gsheet_UserAttributes.png?sv=2026-02-06&spr=https&st=2026-11-12T10%3A17%3A56Z&se=2026-11-12T11%3A17%3A56Z&sr=c&sp=r&sig=mhbqPAhLzaDXsnYd0QslTpVI%2BooOhxMLkgj5cYYxkfs%3D)

1. Name and save your Google Sheet.
2. Once your Google Sheet is ready, you will need to integrate it with Whatfix to fetch user data.

> [!WARNING]
> Note:
> 
> Integrating Whatfix and Google Sheets required backend configuration that can only be done by Whatfix. Contact [support@whatfix.com](mailto:support@whatfix.com) to set up the integration. For more information, see [Google Sheets Integration](/hub/docs/google-sheets-integration).

1. Run or schedule the [integration.](/hub/docs/scheduling-an-integration)
2. Use User attribute as a Visibility Rule while configuring content.

User Attributes provide information about the characteristics of your users, like who they are, what their role is, which department they belong to, etc.