Notion to Google Sheets: Rich text export stops at hyperlink

How To
,
1

I am coming back to a question someone else has asked before (see Notion: Rich Text export stops at hyperlink), but did not follow up on:

In my case, I am trying to set up a scenario to export Notion data to a google sheet, but when sending a rich text field from a database the link stops in the middle of an inserted hyperlink.

For example:

Input from Notion:
This value is automatically adopted from the following input and can be changed there: A2.1 – “Average duration of the business relationship with direct suppliers”.

Output to Google Sheets:
This value is automatically adopted from the following input and can be changed there: <a href="/balances/aspect/

(I tried adding screenshots, but I keep getting error messages when trying to do so. Will try again later)

2

Screenshot: Input from Notion:

notion
notion800×416 29.5 KB

Screenshot: Output to Google Sheets:

google
google1572×432 42.2 KB

(Upload reliably failed in Firefox, had to switch to Google Chrome to upload files, very annoying.)

3

Update: The problem is not the hyperlink, but the change of text color mid-cell. (Apparently I cannot change my original post to reflect this). This issue reliably causes me a headache, particularly since I just found a random place where the export was cut short, to then realize that I seem to have colored characters in my data.