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:
- Go to My Integrations. The link can be found at the bottom of the page under Developers heading.
- Click Create new integration
- Fill in the information and click Submit.
- The 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 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
- Click the three dots in 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 a page
The API endpoint URL for all data must start with the base endpoint, which is
For a page endpoint, the URL is of the format
For a database, the endpoint is
The database ID is the characters between the forward slash (/) and the question mark (?).
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:
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
- Choose Custom API from the list of sources
- Paste the API endpoint in the API URL bar
- 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.
- Click PREVIEW. Then flatten all the data. Then click the IMPORT button.
In a few seconds, the spreadsheet will be populated with data from Notion. Shown below is a snippet of the exported 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.
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.
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