Import Notion Data To Google Sheets

Quick guide
Import Notion data to Google Sheets in a few steps:
1. Get Notion API key by creating an integration
2. Connect the integration to the page to import
3. Get the endpoint of the page/database
4. Launch Amigo Data→Custom API→enter the parameters
5. Preview the data and then import

Notion is a project management and note-taking software platform that helps members of companies or organizations coordinate deadlines, objectives, and assignments for greater efficiency and productivity. It offers a unified workspace, allowing users to comment on ongoing projects, participate in discussions, and receive feedback.

Notion lets you store structured data without the need to go full database. It allows you to create pages to manage content, tasks, and databases–all in one place. 

If you want to analyse the data and pages in your Notion workspace for better insights, however, Notion is not the best tool. For activities such as tracking the progress of a project, finding the percentage of tasks completed, visualising the data, and adding progress bars, Google Sheets is an ideal tool.

So we’ll learn in this tutorial how to get Notion API, integrate Notion to Google Sheets, and import Notion data to Google Sheets.

How to import Notion data to Google Sheets

Let’s learn how to create Notion Google Sheets integration and export Notion table to Google Sheets.

Step 1: Get the Notion API key

To get a Notion API key, follow these steps:

1. Go to the Notion Developers page and click View my integrations. The link can also be found at the bottom of the page under the Developers heading.

2. Click on Create new integration.

3. Fill in the information and click Submit.
4. The Notion API key will be created in a moment.

Note this key. We’ll use this later on.

Step 2: Connect Notion pages to the integration

In order for the integration to access Notion data, we need to give permission to the integration for each of the pages individually to that we can export Notion tables to Google Sheets.

Follow the steps below to connect Notion pages to the created integration:

• Select the page or database you want to connect.

• Click the three dots at the top right corner and click Add connections.

• Select the integration that you have created and click Confirm.

Step 3: Get the endpoint URL for page

Go to the Notion API Reference page. On the left of the documentation, we’ll find a list of data types that we can export from Notion to Google Sheets.

To retrieve a database and export the Notion database to Google Sheets, select Retrieve a database endpoint under DATABASES.

Replace the database ID with the ID of the Notion database to export to Google Sheets.

The database ID is the characters between the forward slash (/) and the question mark (?).

For example, the endpoint URL of the database “Content Tracker” database will be as shown below:

https://api.notion.com/v1/databases/122244d04d46409aaa265bd29118bf12

To retrieve a page, click the Retrieve a page endpoint under PAGES.

Step 4: Import Notion data to Google Sheets

We can now begin to import Notion data to Google Sheets. But before we can do that, we need to install an add-on in Google Sheets. It’s called Amigo Data. It’s a data integration and automation tool that lets us integrate various data sources with Google Sheets and which we’ll use to create a Notion Google Sheets integration.

Install it from the Google Workspace Marketplace with the link below.

Install Amigo Data

Alternatively, you can get it from Google Sheets.

• Open a new sheet
• Go to Extensions→Add-ons→Get add-ons
• Search for Amigo Data and install
  

Once installed, follow the steps given below to create a Notion-Sheets integration and export Notion database to Google Sheets.

• Launch Amigo Data to export Notion database to Google Sheets.
  Extensions→Add-ons→Amigo Data→Connect

• Choose Custom API from the list of sources.

• Paste the API endpoint URL of the Notion database to export to Google Sheets in the API URL field.

• Then expand the Details tab and add the following headers:
  
  Name: Notion-Version, Value: 2022-06-28
  Name: accept, Value: application/json
  Name: authorization, Value: Bearer your_bear_token
  
  Replace your_bearer_token with your secret token.

• Click PREVIEW to preview the Notion database to export to Google Sheets. Flatten the nested datasets. Then click the IMPORT button.

In a few seconds, the Notion database will be exported into Google Sheets. Shown below is a snippet of the data exported from Notion to Google Sheets.

Should you need or want to edit the data, you can do so by expanding the View Reports tab.

Then select the report you want to edit→Edit Report→Save & Run.

Setting refresh schedule

To get the information updated periodically, click the report you want to update automatically, toggle on the Refresh Schedule and select the schedule–hourly, daily, weekly, or custom days.

Then click Save & Run

Alerts via email or Slack

You can get the report sent to your email or a Slack channel if you want to.

To set up an alert, click Get Alerts→Add alert data+. Edit the details and click Set Alert.

Conclusion

Hope this Notion Google Sheets Integration guide is helpful. Following the same procedure you can export pages and databases from Notion to Google Sheets.

For information about how to import other types of data to Google Sheets, visit this Notion API guide and the API documentation.

FAQs

See also

You can import various other data from different sources using Amigo Data, such as Yahoo Finance, Shopify, HubSpot, and Facebook to name just a few.

You can visit our blog to find out more about importing data to Google Sheets.

Some related articles that may be of interest to you:

Connect HubSpot to Google Sheets

Connect Zoho CRM to Google Sheets

Connect Salesforce to Google Sheets