Hello! I'm trying to save a value (which can be one or multiple links) from Zapier to Notion. The field in Notion is of text type, but when testing the 'Create database item' action from Zapier, the data is saved as plain text instead of URL links. What should I do to ensure that those URLs are saved as hyperlinks?
The expected result should be like the second option, but the result we get is the first option
+14
Hi
Good question.
Try sending the value as formatted HTML (reference)
Otherwise, you may need to format as JSON.
Notion API reference: https://developers.notion.com/reference/rich-text#text
I tried to do HTML formatting, but whenever I try the 'Create Database Item in Notion' action it creates a text element in the notion
+8
Hi
In that screenshot it looks like the link still isn’t HTML formatted.
Can you try, as a test, in that step above entering:
<p>API: <a href=”https://github.com/everything_else”>https://github.com/everything_else</a></p>
And then just test the step and see if it shows up in Notion the way you’d like?
Hi
Zap
Notion
+8
Lilo,
Can you send a screenshot of all of your field setting on the Create Database Item step? Please make sure to redact and personal information.
I’ll be happy to take a closer look at that!
+14
You can try this…
Add a TEMP Zap step to find an existing database item that has the URL formatted properly.
The results may help you understand how the URL needs to be formatted.
Thank you
even if I try to update the notion with the results of the Find action, it gets rewritten as plain text
+8
Hi
I’m playing around with this myself, and when I enter a hyperlink in a text field from the web interface it appears as plain text and not a link. Is it the same for you?
I was able to get it to work by adding hyperlinks to the Content field
Scott
Hi
+8
So it works when you copy/paste, but not when you type it in directly, right? Because I’m seeing the same behavior as you with a copy/paste, but when I type it in it does not get converted into a link in the text
+11
Hi
I’ve been testing this on my end as well and I can’t get it to render the links correctly either. I tried changing the field I was testing with, in Notion, to use the URL property type and that was then able to create the link, but it only works for a single link, not multiple links.
I did some further digging and couldn’t find any existing bug reports for this but this feels like a bug to me. So I’d recommend reaching out to our Support team here: https://zapier.com/app/get-help. They’ll be able to investigate further and open up a bug report on your behalf.
As a workaround, perhaps you could try using the API Request (Beta) action for Notion to see if that allows you add the links into that Pull Request(s) field correctly? It’s a bit more advanced but if it’s something you’d be interested in exploring you can find out more here: Set up an API request action
Hope that helps. If you manage to find an alternative solution in the meantime please let us know!
+8
I think Sam’s right that the API Request action is the best you’ll be able to do here.
I did some work to get a manual POST request set just right and I was able to do it by setting up my property like:
"PropertyName": {
"type": "rich_text",
"rich_text": [
{
"type": "text",
"text": {
"content": "https://www.example.com",
"link": {
"url": "https://www.example.com"
}
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "https://www.example.com",
"href": "https://www.example.com"
}
]
}
I haven’t tried this in Zapier using the API Request action myself, but I think the fact that the manual request worked shows promise for getting the API Request action to work. Let us know if you have any questions
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.