I think that a markdown hyperlink provided by the user will result in a malformed hyperlink in the output spreadsheet if the text portion contains parentheses (and possibly other characters?).
For example the source statement provided in the demo: providing '[Motor Trend (1974)](https://www.google.com)' results in the output hyperlink '1974)%5d(https:\www.google.com', whereas '[Motor Trend, 1974](https://www.google.com)' works as expected.
This will be due to regex handling. Maybe a case for raw strings with r"{}"?
I think that a markdown hyperlink provided by the user will result in a malformed hyperlink in the output spreadsheet if the text portion contains parentheses (and possibly other characters?).
For example the source statement provided in the demo: providing '[Motor Trend (1974)](https://www.google.com)' results in the output hyperlink '1974)%5d(https:\www.google.com', whereas '[Motor Trend, 1974](https://www.google.com)' works as expected.
This will be due to regex handling. Maybe a case for raw strings with
r"{}"
?