Google Sheets Integration

• Overview
• Use cases
• How it works
• Authentication
• Integration process

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.

How it works

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