Here’s how to connect Notion with PowerQuery.
There are quite a lot of steps you need to perform before you get there, but I’ve explained everything in the video:
– Choose a Notion Database to get the data from
– Create a Notion Integration
– Connect the Notion Integration to the database
– Get the integration API key and store it in Excel
– Get the Notion database ID
– Perform the requests
– Unwrap the data in PowerQuery
I’ll be really happy to answer any of your questions. If you’d like to see me connecting to more Web services, just write a comment and I’ll make a video on that as well.
Also – Merry Christmas to all of you!