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
Step 1: Get your API access token
To use Notion's API you'll need an access token, in the format
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.
Notion Database Please enter a valid key. Preview
Expand nested data, rename and delete columns
Get a live Google Sheet
your data to a google sheet, with the SyncWith Addon, or download to CSV
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