Import Notion Data To Google Sheets

How to import Notion data to Google Sheets
Reading Time: 6 minutes

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.

Creating a new integration to import Notion data to Google Sheets
  1. Fill in the information and click Submit.
  2. The Notion API key will be created in a moment.
Notion token key

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.
Notion table to export to Google Sheets
  • Click the three dots at the top right corner and click Add connections.
Connecting a page to the integration to export Notion table to Google Sheets
  • Select the integration that you have created and click Confirm.
Confirming the integration

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.

Notion API reference

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

Endpoint to retrieve a Notion database

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 (?).

The database ID in the URL

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
Launch Amigo to create Notion Google Sheets integration
  • Choose Custom API from the list of sources.
Select 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.
Notion API URL
  • 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.
Notion API headers
  • Click PREVIEW to preview the Notion database to export to Google Sheets. Flatten the nested datasets. Then click the IMPORT button.
Preview of the Notion data to export to Google Sheets

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.

Data 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


Yes, you can automate the export of Notion data to Google Sheets with Amigo. Create a Notion Google Sheets integration, export the data to Google Sheets and set a refresh schedule to automatically export the data from Notion to Google Sheets.

Yes, you can export specific pages or databases from Notion to Google Sheets. Connect the page or database you want to export to Google Sheets to the Notion integration you’ve created.

To schedule regular exports of Notion data to Google Sheets, set a refresh schedule and set the time when you want to export the data. Amigo will then regularly retrieve the data from Notion and export the data to Google Sheets.

Yes, you can export multiple databases from Notion to different tabs in one Google Sheets workbook. Open the workbook into which you want to pull the Notion databases and make successive imports from that workbook using Amigo.

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

Leave a Reply