Source: https://nishanth-fern-test.docs-staging.pageloop.ai/web/google-sheets-integration

# Google Sheets Integration

- [Overview](/web/google-sheets-integration#overview)
- [Use cases](/web/google-sheets-integration#use-cases)
- [How it works](/web/google-sheets-integration#how-it-works)
- [Authentication](/web/google-sheets-integration#authentication)
- [Integration process](/web/google-sheets-integration#integration-process)

Note:

Integrating Whatfix and Google Sheets requires backend configuration that can only be done by Whatfix. Contact [support@whatfix.com](mailto:support@whatfix.com?Subject=Integrate%20Whatfix%20and%20Google%20Sheet%20for%20my%20account\&Body=Hello%20Team%2C%0A%0AKindly%20provide%20assistance%20to%20integrate%20Whatfix%20and%20Google%20Sheet%20for%20my%20account.%0A%0AMore%20information%3A%0A%0AThanks%20and%20regards.) to set up the integration.

---

## Overview

Google Sheets and Whatfix integration enables you to import your support articles from any Knowledge Base application and export Whatfix reports to a Google Sheet.

---

## Use cases

Here are some use cases that are possible using this integration:

- Import support articles from any Knowledge Base application. This can be useful if your organization is using a custom support site or app.
- Import all your FAQs, which are in text format, to Self Help for easy access and usage.
- Export Whatfix reports to Google Sheets. For example, export reports, such as:
  - Most run Flows.
  - Most searched terms on Self Help as a Google Sheet.
- Add end-user data to Google Sheets and use it for content segmentation to show content to a specific group of users. This can be helpful if your app has no API to share the data. For more information, see [Segment Whatfix content using User Attributes and Google Sheets](/web/google-sheet-integration-with-user-attribute).

Note:

- To modify end-user data in Google Sheets for content segmentation, you need to update the file manually and rerun the integration for the changes to take effect.
- To avoid manual updates, [create Cohorts in Whatfix Product Analytics](/analytics/create-a-cohort) and use them as Visibility Rules. Cohorts refresh automatically whenever a user meets the Cohort criteria (for example, joins a new country, performs an action in the application, or interacts with Whatfix content), they’re added to the Cohort and immediately see the relevant Whatfix content. For more information, see [Add Cohorts as Visibility Rules](/desktop/add-cohorts-as-visibility-rules).

---

## How it works

![googlesheets\_import\_integration\_how\_it\_works1](/images/da/googlesheets_import_integration_how_it_works-1-daf39020.png)

---

## Authentication

Google Sheets uses **OAuth 2.0** for authorizing its REST APIs. Whatfix uses Google Sheet Connector, through which users get authorized when calling Google Sheet APIs.

---

## Integration process

![googlesheets\_import\_integration\_process1](/images/0b/Google_Sheets_Integration_Process_Whatfix-0bb4e789.svg)

Note

This integration is not available for [Self Hosted](/web/self-hosting-whatfix-content) mode of deployment.

## Related

- [Segment Whatfix content using User Attributes and Google Sheets](/web/google-sheet-integration-with-user-attribute)
