Overview
Do you use notion? Have you setup tables with lots of data? Using the SyncWith Google Sheets Addon, you can easily create a live connection to pull all the rows in a table live into Google Sheets using the Notion API.
Step 1: Get your API access token
To use Notion's API you'll need an access token, in the format
secret_x1BBlsE5pEV5gi5avoaW3NNywenxBHMHLCtP6qvurzn
To get an access token, you need to create an Integration at Notion. I created an internal integration. You can read more here: https://developers.notion.com/docs/authorization
Step 2: Share page(s) with your integration
Before your integration can access any pages (which contain the tables you're interested in), you'll need to share those pages with the integration.
To do this click
Share
on the top right of the page in Notion that has the table you want to connect to Google Sheets, then in the invite box click to find the integration you setup in Step 1.Step 3: Use SyncWith to query the table
Paste your API key into the form below. Your list of tables will then load. Note that in Notion’s API, a table is called a database.
Once you’ve picked your table, pick the fields you’d like to retrieve and press Run.
Preview
Expand nested data, rename and delete columns
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
---|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets