Articles on: Task & Spreadsheet

How to import my Notion database into Abyssale ?

Your Notion database can now be quickly and easily imported on Abyssale! Let's dive into it:

Add your Notion API key

First go to Notion & log in
On the left panel at the top click on settings and member :

On your Account Settings page, you'll find an My connection area. Click on develop or manage integrations

You are now redirected to the developer Notion page. You must now add a new manual integration. Click on New integration

Let the default parameters for this new integration, name it and select you workspace
Copy the API key from your new notion integration

Go to & log in.
Go to your Abyssale account Settings > Connect > Notion; Paste your Notion API Key in the input field and click the Save your key button.

Your Notion account is now connected to Abyssale 🎉.

Connect my Notion Database with Abyssale

Once your API key has been added to your Abyssale account, you need to connect your Abyssale extension created on Notion to your database before importing it.

Open the Notion page where your Database is
Click on the page settings on the top right ...
Click on "Add a connection" and find the connection you created earlier and add it to this database.

You'll need to connect the app you've created on Notion to each Notion Database you want to connect, otherwise you'll get an error when trying to import a Notion database on Abyssale.

How to import my Notion database now?

Go to Automate
Select the "Spreadsheet" automation
Follow instructions
There are multiple spreadsheet import available including Notion base import. To import your notion data click Select

A popup window will appear asking for your Notion database url or the Notion database id.

Notion database url

Go to your Notion database page
Copy the url and paste it in the appropriate field

Beware, each Notion "Database" has a dedicated page with a unique ID

Notion database ID

Go to your Notion database page
In the url of your database page, get the id

If everything has been done properly, a mapping will be displayed in the popup window (all checkboxes are unselected by default).

Here you need to check your Abyssale layers (from your template) that you would like to populate with a column extracted from your Notion Database. To do that, just enable the desired layers, and select on the right side which columns you would like to map.

When fetching your data, Abyssale is guessing which kind of column you have. That's why you don't see all columns on all selected fields. "image_urls" will only contain image fields, "color" & "background_color" only hexadecimal (#FFFFFF) color fields...

Once you have done your mapping, click on Create Spreadsheet.

Your Spreadsheet will be created and you will be redirected to it.

You can now edit all your data & start generating visual from them 👏.

Updated on: 29/06/2023

Was this article helpful?

Share your feedback


Thank you!