Import Notion Data To Google Sheets

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

Quick guide
Import Notion data to Google Sheets in 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
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 – Step by step

Let’s see how to import notion data to google sheets step by step…

Step 1: Get the Notion API key

To learn how to get Notion API key, follow these steps:

  1. Go to My Integrations. The link can be found at the bottom of the page under Developers heading.
  2. Click Create new integration
Creating a new integration to import Notion data to Google Sheets
  1. Fill in the information and click Submit.
  2. The 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 the data, we need to give permission to the integration for each of the pages individually.

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

  • Select the page or database you want to connect
Notion pages
  • Click the three dots in the top right corner and click Add connections
Connecting a page to the integration
  • Select the integration that you have created and click Confirm
Confirming the integration

Step 3: Get the endpoint URL for a page

The API endpoint URL for all data must start with the base endpoint, which is

https://api.notion.com/v1/

For a page endpoint, the URL is of the format

https://api.notion.com/v1/pages/{page_id}

For a database, the endpoint is

https://api.notion.com/v1/databases/{database_id}

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

The database ID in the URL

Copy the database id and append it to the end of the endpoint.

The complete endpoint for the Content Tracker database will be as shown below:

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

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.

Install it from the Google Workspace Marketplace. Here’s the installation link: https://workspace.google.com/marketplace/app/amigo_data/274781802717

Alternatively, you can get it from Google Sheets itself.

  • 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 import Notion data to Google Sheets.

  • Launch Amigo Data

    Extensions→Add-ons→Amigo Data→Connect
Launching the Amigo Data addon in Google Sheets
  • Choose Custom API from the list of sources
Select Custom API from the list of sources
  • Paste the API endpoint in the API URL bar
Pasting the database endpoint in Amigo Data  Custom API connector
  • 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 secret_u1vlTtQjbLFs3t084K0uNjekdjKZjlQNjYrwVdDgPhkv

    Replace the key with our own token.
Header values in Amigo Data
  • Click PREVIEW. Then flatten all the data. Then click the IMPORT button.
Preview of the data

In a few seconds, the spreadsheet will be populated with data from Notion. Shown below is a snippet of the exported data.

The imported data

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 our notion google sheets integration guide helped you. Because it is easy to import Notion data to Google Sheets. You can import any kinds of data to Google Sheets after creating and integration and giving permission to the pages and databases you want to import.

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

See also

You can import various other data from different sources using Amigo Data, such as Yahoo Finance, Spotify, Binance, and Google Trends. 

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

https://blog.tryamigo.com/import-data-from-google-search-console-to-google-sheets/

https://blog.tryamigo.com/export-google-ads-data-to-google-sheets/

https://blog.tryamigo.com/youtube-analytics-to-google-sheets/

https://blog.tryamigo.com/import-coingecko-data-to-google-sheets/