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 app.abyssale.com & 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 🎉.

How to import my Notion database now?



Once your API key has been successfully added to your Abyssale account.

Go to My templates
Click on one of your Template
Select the Spreadsheet generation method
There are multiple creation methods 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: 18/01/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!