Google Sheets: Issue with Formula in Table referencing value in same row by column name

I share here an issue I have faced with Google Sheets when using a formula in a Table that references a column by name.

Goodreads to Notion

This post is a WIP/ WOL. Please comment if you are interested for me to share quickly a final solution/ want to motivate me getting this done.

I have the idea to use Notion for tracking my reading and especially take reading notes.

I use mainly Goodreads to manage the books I have or plan to read/buy and also its community feature to share with other reading friends.

Now I would like a seamless handling between both tools i.e. avoid manually entering of books in Notion and automatic synchronization from Goodreads to Notion.

Moreover, I would like also to track my expenses related to books.