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

# Google Sheets Integration

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

To integrate Whatfix and Google Sheets, 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.).

---

## Overview

With Google Sheets and Whatfix integration, you can 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, etc.
- Add end-user data in 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.

---

## 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)
