How to Copy Zendesk Articles Using Awesome Table in Google Sheets (No API Required)

Zendesk Help Center is a great platform for hosting knowledge base articles, but there is no easy way to export articles with just a click of a button. If you need to migrate, back up, or simply analyze your Zendesk articles, the lack of a straightforward export option can be frustrating.

Thankfully, Awesome Table provides a simple, no-code solution to copy all your Zendesk Help Center articles directly into Google Sheets—without requiring manual CSV exports or API integrations.

In this guide, we'll walk you through installing Awesome Table, connecting it to Zendesk, and automatically transferring all your articles into Google Sheets in just a few clicks.

Install Awesome Table in Google Sheets

Before copying your Zendesk articles, you'll need to install the Awesome Table add-on in Google Sheets.

How to Install Awesome Table

You can install Awesome Table directly from the Google Workspace Marketplace:
👉 Click here to install Awesome Table

Alternatively, you can install it from within Google Sheets:

1. Open Google Sheets.
2. Click on Extensions → Add-ons → Get add-ons.
3. In the Google Workspace Marketplace, search for Awesome Table.
4. Click Install and grant the necessary permissions.
5. Once installed, you will see Awesome Table under the Extensions menu.

Connect Awesome Table to Zendesk

Now that you have Awesome Table installed, it's time to connect it to your Zendesk Help Center.

How to Authorize Zendesk in Awesome Table

1. Open your Google Sheet.
2. Click on Extensions → Awesome Table → Connectors.
3. In the Awesome Table Connectors menu, select Zendesk.
4. Click Authorize and log in to your Zendesk account.
5. Allow Awesome Table to access your Zendesk articles.

Once authorized, you can now extract all your articles into Google Sheets.

Copy Zendesk Articles into Google Sheets

With the connection established, you can now copy all articles from Zendesk into your Google Sheet.

How to Import Zendesk Articles

1. In Awesome Table, after connecting Zendesk, select Articles.
2. Choose the Help Center from which you want to extract articles.
3. Click Run
   
4. Awesome Table will now automatically pull all articles into your Google Sheet, including the following fields or more:
   • ID
   • URL
   • Html URL
   • Author ID
   • Comments disabled
   • Draft
   • Promoted
   • Position
   • Vote sum
   • Vote count
   • Section ID
   • Created at
   • Updated at
   • Name
   • Title
   • Source locale
   • Locale
   • Outdated
   • Outdated locales
   • Edited at
   • User segment ID
   • Permission group ID
   • Content tag IDs
   • Label names
   • Body

This process might take a few minutes depending on how many articles you have.

Organize and Format the Article Data

Once your articles are copied into Google Sheets, you can clean and organize the data by following the steps from this KB