L-a-r-t / chatgpt-to-notion

ChatGPT to Notion brings the cleverness of ChatGPT right into your Notion workspace!
https://chrome.google.com/webstore/detail/chatgpt-to-notion/oojndninaelbpllebamcojkdecjjhcle
332 stars 64 forks source link

bug: cannot add database #30

Open dyhn78 opened 1 year ago

dyhn78 commented 1 year ago

I added integration on my databases and they appears on list like following image. but they are unclickable - nothing happens on click.

alykhan commented 5 months ago

I managed to add the database but after i closed the browser and tried again, it wouldn't allow me to add the database again.

OleOla123 commented 2 months ago

Hello @dyhn78, @alykhan and @L-a-r-t,

I had the same problem as you described, but I just found a solution to be able to connect the unresponsive database.

Here's how I did it (but I don't know if the solution will hold up over time):

  1. In Notion: duplicate your database (to keep the data in case it bugs)
  2. Remove all properties except, Title, Creation Date, URL and a select property. If your database does not already contain such properties, create them to meet the criteria for connecting a database with the extension.
  3. Try connecting the Notion database again with the ChatGPT to Notion plugin. It should work now (possible to export chatgpt text to the Notion database).
  4. Return to your Notion database and undo the changes (I used the Cmd + Z shortcut) to reappear the deleted properties. The integration should continue to work.

I hope it works for you too!

Have a good day

@L-a-r-t I did a lot of trials and tests today to achieve this, I documented my tests and results quite a bit. If you're interested in the details, let me know. The problem seems to come mainly from the first select or multi-select property in the database. It seems that if it is too complex (e.g. too many response possibilities), the integration does not work at first glance.