How to automate Notion Database using Siri Shortcuts + Notion API | Notion Series [Part 1]
HTML-код
- Опубликовано: 9 июл 2024
- To get quick help on your shortcuts join my Discord server - / discord
Support my work through BuyMeaCoffee - buymeacoffee.com/kpp667rmpr7 or Patreon - www.patreon.com/NazarNotionAu...
The full guide on how to set up Notion Integration with Siri Shortcuts.
api.notion.com/v1/pages/
[Shortcut demo](www.icloud.com/shortcuts/6db2...)
My Telegram: @NazarForReal for work suggestions.
nazar i just want you to know this video is still the only video i have used religiously and followed and it never fails - i come back here every time i want to make a new shortcut and you made it so simple and easy to understand! this video is actually a saved bookmark for me. thank you for your work and your impact. when i am earning, i will not forget you
What’s crazy is that this is the only explanation of how to do this with the API I’ve found online.
I hope this tutorial helped you.
Thanks for all your help Nazar. This was an amazing video but your help on discord was even better. Thank you so much buddy, can't wait till you hit 1000 subs and beyond.
Thank you for watching!
This is awesome, I followed you step by step, and it works!
From where we get the url link? Please help here...
This is so great. Thank you so much!!
Great video here man, well explained and demonstrated. Not tried it yet but it seems easy enough
Whoah this is amazing. Will definitely give this a go, thanks!
Thank you brother! this is sick. worked like a charm
Awesome video! I spent ages looking for the answer and your video summed it up perfectly. The volume of the backing music was a bit too loud to begin with but perfect walkthrough! Now just to figure out how to add in the multi-selects!
Thanks for the feedback! I will take it into account.
Thank you very much. The tutorial was excellent, and I was able to adapt it to my "market list" database. (Brazil)
This is awesome! 🎉
Super helpful. Thanks!
really nice, thanks!
Назар, большое спасибо! Все очень четко и понятно. Искал подобное решение, т.к. недавно купил себе Apple Watch 7 и одновременно являюсь активным пользователем NOTION. Еще раз благодарю !!! Андрей
Всегда пожалуйста.)
What about sending pictures? is that possible too? (a page with a picture in it for example)
Niceeeeee
This is sweet, and super helpful, thank you! I'm working on building a shopping list using Siri and verbal command / Notion. I'm thinking to make it simple, and uncheck the item if it is called.
The part I'm stuck, is trying to validate the input response with a specific Name property. Would you just use a dictionary list of the Name property? Then how do I validate that it exist or fail otherwise? Any ideas/examples?
Sorry, I don't clearly understand your question. Can you explain, what do you mean by "validating" action?
what do you think of using nautomate then? this tutorial is hella useful but a bit complicated
This is awesome! Do you know of a way where the shortcut could also add text to the body of the notion page? From what it looks like, it can only fill out the title, and other information like the category and date, but if additional text for note taking purposes could be added to the body of the notion page that would be amazing 🤩
Yeah, you definitely can.
Hey Nazar! Thanks for the amazing tutorial. It was very informative. However, when I tried it, there was no items added into my notion. Did any of the texts change with the notion update? Or should I still stick to the same URL and version date in the video?
Hey! There are no changes for the most part, except for the Notion-Version parameter. You can try to put 2022-06-28 instead.
Подскажи пожалуйста как добавить ссылку🙏🙏🙏🙏
Hi, nice video. I follow all steps but i have this error Obtener contenido de URL falló porque Atajos no pudo convertir de Formato RTF a Dirección URL. Can you help me? thanks
If you have any questions, feel free to write them down below:) I will reply to you as soon as I will have the answer for your question. If you haven't got an answer for a long time, it means that I'm still searching for the proper solution.
will be automated to apple calendar? if we make sync notion among shortcuts
@@gerasista1927 I haven't tried it yet. What is your purpose of syncing Notion and Apple Calendar?
Is there a way to instead of a number, do a link from a share sheet input? If so, under properties - dictionary - what would I put? Text?
I made the shortcut similar like your's, but when I am running the shortcut and start to type anything in name it just cancels the th shortcut. However when I just tap on done without any input while running siri shortcut it takes me to the end iput that is Notes but nothing is created in my Database.
When i run the program, i get this error:
{"status":400,"object":"error","code":"validation_error","message":"body failed validation: body.parent should be defined, instead was `undefined`."}
My category property is a relation - how do I include a relation property into this when selecting a category?
Save this shortcut and read the comment along the script saying where you need to swap names with your properties… have 2 properties already… if you get a message of error saying that status properties do not exist--> in the final is a text in json with the configuration of the body with a propertie called “ status “ --> remove this part
thank you for that great video. Everything works very well. Execpt one thing. I cant use a mulit select porperity. Do you habe any advice? The only thing I receive back is: {"status":400,"objekt":"error","code":"validation_error",message":Tag is expected to be mulit_select."}
I would appreciate an answer. Thank you very much in advance 😄
It is indeed possible. Get the options from multi-select property. Then, choose from them as from list. Combine multiple items with commas in json format with title of your multi-select property in head of it(keeping in mind how the property schema is structured). Add this piece of text to the general request json text. You can check out how to work with json format in my most recent video. You can contact me later if you still will not understand this.
Fantastic video, so psyched I have this automation on my phone now! I tried to add a user ID to the payload for a "Person" field on a database to assign a task to a specific person but couldn't figure it out. Any ideas? Maybe it's because it's effectively a multi-pick rather than a single pick?
I heard multi picks dont work
I figured out a newer method, to send requests to the api and multi-select now actually work!
Thank you so much for this tutorial! I followed step by step but I'm a little bit stuck.
I keep getting this error: {"status":400,"object":"error","code":"validation_error","message":"Date is expected to be date."}
I Think it has to do with the fact that I'm trying to set a start and end time with the date. Within the Date property, I put in an extra one called "end" underneath the "start". not sure if this is what's causing the issue. Would appreciate any help!
Thanks :D
Whoops! I figured it out haha Basically I missed a step exactly at the moment you were cautioning us to be careful not to miss a step hahaha
@@MubarakMarafa yeah, this is a bit tricky but I am sure you will figure it out:)
hi, thanks for your videos, any idea why my shortcut says:"body.parent.page_id should be defined, instead it was 'undefined'"? (I inserted my id in the proper way I think) thank you!!
hi, make sure the "parent" parameter in request body is a dictionary containing a key named "database_id" and a text value(your database id). You can also check the demo of my shortcut provided in the description.
It says that either the database ID is incorrect or that it doesn't have permission or can't find it {"status":404,"object":"error","code":"object_not_found","message":"Could not find database with ID: (The ID I pasted). Make sure the relevant pages and databases are shared with your integration."}
Update: Fixed it by pressing the 3 dots on the database page, then in Connections type the Integration name and add the Integration
Hi Nazar, have you worked out how to add page content to a database entry using the "children" key yet? Struggling to make it work using the Notion API
Hi, yes, you can check out this demonstration where shortcut puts definitions for a word as page children blocks: www.tumblr.com/nazarforreal/704293262378369024?source=share
You can use this Notion API Reference page if you're stuck somewhere: developers.notion.com/reference/patch-block-children
@@nazarzhmurko6461 This is awesome, but what parameters did you use in the Shortcut app for it to populate inside children, as that's where I'm failing... keep returning a never ending list of errors. Maybe you have an example?
www.icloud.com/shortcuts/df4a7713a3f04104a1af460529b534d5 Here you can see the example of append children JSON request.
Did Notion change the share sheet action described at 2:42? I can only use the three dot menu in the top right and say "add connections". Is that the same?
Yes. By adding “connection” you can add integration.
Thanks for this video! What about if I want to add to this database a link type property? What should be the kind of value for this? A Dictionary? Array? Text? Thanks!!
If you mean Relation to the page, you should use at first the dictionary [Custom name of the property]. Inside of this dictionary insert an Arrary called “relation”. Inside of it create dictionary and, after all, text field called “id” and near it the value should be an id of the page, you want to relate to.
@@nazarzhmurko6461 thanks for the fast answer! I actually wanted to add a url link. I tried many until I found the right one. But is good to have a way to ad a relation too!! Thanks a lot. It would be nice if you create more videos with more possible scenarios that take advantage of this approach. I haven’t found any videos about this and I think it’s very powerful being able to connect Shortcuts and Notion in this way. I would love to have a Shortcut that with a RUclips video url, retrieves the information about the video (title and description) using the RUclips API and stores it in a notion database. I’m all the time doing research about different subjects and I’m all the time saving RUclips videos in a notion database under different categories and tags.
@@GeremyDeMelo Thank you for the nice feedback, Geremy!) I was thinking about doing a video on how I quickly insert a new idea 💡 and new wishlist item records to the specified Notion databases. So sure, maybe, I’ll do the tutorial on this one, if you are interested.
Hey. It would be amazing if you could share your approach with me, how you managed it to create the link / url property. I cant find the right solution. Greetings from Germany :)
@@juliushasenzahl128 Hello! Thank you for watching. Actually, at first you should add a dictionary named after your URL property value in the "properties" dictionary. inside of the url dictionary put a text field called url and url itself in the relative field.
Hi, It seems the materias mentioned in the description are no longer available, Is there a change to re-post?
Hi, what specific material would you like to get?
Thanks for sharing, finally had the chance to test. Not quite there, but it seems to work. May I suggest blurring your secret code? As it is called secret...
Thank you for suggestion but this integration setup is just a show-off of how the shortcut works. I don't use the database created in this video. Thank you for watching!
Thanks for making this! Excited to try it out. One thing I want to figure out is how to make a good habit tracker update shortcut. So say I have a daily tracker database with 5 check box properties. It would be cool if the Shortcut could show what is currently checked, but also allow you to check off anything new. This seem possible?
Nice idea, Dan! Seems like it will be possible to make a handy habit tracker shortcut. I’ll try to do it and share my own tutorial, if I figure out how to do it.
@@nazarzhmurko6461 awesome :)
@@Guchumpas Great news! I’ve managed to make a nice shortcut to control your habits in Notion database. Stay tuned for the upcoming video this month.)
@@nazarzhmurko6461 Nice! Good news. I’m getting closer to figuring it out lol. Look forward to the video.
Hello, can you explain how, through an iOS shortcut, we can edit a data from the table, in this case an expense. ? thank you.
Hi, sure.I’ll work on one example.
Hi, try this one: www.icloud.com/shortcuts/2e2266fb3b8544449df331560864a174
Hey, really helpful content there, thank you! Is there a way to upload media (photos, PDF) for recipes into the database? Greetings from Germany
Sadly, there is no option for this at the time. Thanks for the feedback, Julius.)
Did anyone come across a solution for the media upload (.e.g select from iOS photos) to a database?
Greetings!
What do I do??
This video is one of the best things I’ve found this year. Do you have a Patreon or something to support you?
I’ve already done my version and now I’m trying to do a task shortcut, but I’m having trouble with “date and hour” because even when i’m formating with ISO 8601 I keep having the error “Due.date.start should be a valid ISO 8601 date string”.
Any advice?
Could you please share the link to your shortcut so I can better see the problem?
www.icloud.com/shortcuts/13f20ba9fcd34734ba51c5030020f9d6 Try this one. I added some setup steps for your convenience. Let me know, how it worked. You can support the channel through PayPal.
I’m glad it worked for you. It’s in the description of this video.
You should get a discord channel!
I’m trying to add reminder to date and time. Any idea in how to do it?
Unfortunately, there’s no way to add reminders through the shortcut.
Does the Notes property in Shortcuts work with URL's too? I'm getting the error "{"status":400,"object":"error","code":"validation_error","message":"URL is expected to be url."}"
Stay tuned for the upcoming tutorial.
hello, why I can see integration in share when I wanna invie it, can you help me, pls.
Hello, you need to navigate to three dots menu -> Connections -> Add Connection.
Hi, how do i know my notion version? Or all notion version is 2021-05-13 ? Thank you
Hi, you should use version 2022-06-28 as of right now.
А можно на каждый раздел таблицы создавать отдельный properties? Потому что provided input перекрывает строчку и я не могу работать с остальными в properties
Может быть только один словарь “properties”, внутри которого словари для отдельных свойств(Name, Date, Select, Notes).
@@nazarzhmurko6461 я не знаю из за обновления это или из за того что это shortcuts на айфон, но я не могу даже зайти в properties после того как настроил для name, потому что перекрывает provided input
@@nazarzhmurko6461 то есть идет строка properties, а в след поле provided input (то есть моя variable), но я ее ставил только для name, в другие я не могу зайти из за того что оно перекрывает
@Nazar Zhmurko , Hi.., awesome video, thanks for sharing, would you please explain how to update the shortcut so when open a file and use the share sheet and choose the shortcuts, it gets all the described information but also get the file it self and save it to the corresponding column titled "Files & media" in Notion database within the same row of the collected information
Hi, thank you for watching. Unfortunately, it is not possible yet to upload file though the Notion api.
@@nazarzhmurko6461 Thanks for replying, okay is there any way around so i can get the file URL (using google drive or so) and it to Notion ?
This workflow is possible: Get File -> Upload to Google Drive -> Get File Link -> Use it in File property. I’m currently working on the Google Drive API in Siri Shortcuts. Still couldn’t get to upload the file to the drive.
@@nazarzhmurko6461 Thanks for your response. unfortunately i couldnt find the "Get File" or "Upload to Google Drive" actions in iOS 16 Shortcuts version. Using the "Get File" link always resulted in an error because the file was not uploaded to iCloud Drive. Hopefully, there is another way around this, and I'll keep you updated on any new APIs.
@@amadomax I didn't mean "Upload to Google Drive" as a Shortcuts action. It generally requires some work with Google Drive API. Sorry for not making it clear.
Hello Nazar, this is a great content thanks a lot, but I'm facing a problem; I can't see the integration button while I press invite, just "Add emails or people" there is no integration option to choose the new integration that I made. Your support is highly appreciated.
Hi! I faced this problem too. So instead of “share” click “three-dots” button (…) in the right upper corner, than “add connections” and choose your integration
OMG you'd saved my life, thanks a lot !!! i was starting to give up, but you saved me@@fedorgoncharov7528
Hello there. I can’t insert text in the database_id Text Field. Instead it creates like another dictionary element with cutoff versions of the word database_id. Is someone else facing with this issue?
{"status":400,"object":"error","code":"validation_error","message":"body failed validation. Fix one:
body.parent.database_id should be a string, instead was `{\"\":\"DATABASE ID STRING\"}`.
body.parent.page_id should be defined, instead was `undefined`."}
Hi, yes, I know what you are talking about. Watch my most recent tutorial. I used other method there. You may find it helpful.
It says my 'Name' is undefined, but I did all the steps. Do you have any idea??
Did you provide input for the title property on your shortcut?
Hi, how does this change for Notion's new API?
I know Notion-Version is 2022-06-28, but anything else?
Hi, nothing really changes in the shortcut building workflow. New api version may add some additional features but it does not change the way you interact with api.
@@nazarzhmurko6461 Yes, figured it out. Had to tinker with the JSON a bit to adapt to my database. Nothing changed except the Notion-Version Data. (Old Date won't work anymore)
By the way, what should I do to add a time property? I've selected data & time but what property value should i add to the date dictionary outside of start?
@@abirershad9762 to begin with, you should format the provided date value. But, as a Notion property, it acts as a piece of text.
My API integration doesn't work like in the video now.
what should I do?
Find three dots menu in the top right corner -> On the bottom of the menu, you will see the “Connections” section. From there you can add your integration to the database.
how to select a property type (relation) by other table?🙇🏻♂️ use text or select as category?
Okay, if I understood you right, you want also to create a relation in your new record to another page. In this case, you should create a new dictionary in “request body”. It can be “Relation”, for example. Inside of this dictionary you should create an array called “relation”. Then empty dictionary and inside of it create a text key called “id” and value this time will be the id of the wanted page(with which you want to relate your record).
I haven’t tried to include into my workflow the relation property. Seems like it is easier to do this in the app sometimes. I will research more on it.
@@nazarzhmurko6461 solved. Can we select by property_name instead of id? And how can we create a new page on relation with api and edit it both? 🙇🏻♂️
@@chunhin Hey, how did you solved it? the solution of nazar somehow doesnt work ... How did you do it? Greetings from Germany
@@chunhin Nevermind i fixed it, was my mistake :)
is there a way to say it with a direct instruction like "Hey siri, add 100 dollars for tech" or "Hey siri, i've just paid 100 dollars for tech" ?
Interesting. I will try to figure out how to teach Siri to do this.
My Shortcut Crashes every time i add a new property... :/
Please, check out my latest tutorial, where I showed a newer way to add properties.
Братан , как ты к этому дошёл ? Это просто восхетительно!!! Я бы хотел с тобой пообщаться на тему Ноушина , сам сейчас уже хорошо разбираюсь в нём , есть пару вопросов.Надеюсь ты увидишь это сообщение и отпишешь . Это видео просто ОГОНЬ ! P.S Стоит поработать над звуком .
Привет. Спасибо за отзыв! Сразу после появления api от команды Notion я сразу подумал об автоматизации процессов через Siri Shortcuts. До этого то же самое делал с Airtable. Конечно, на вопросы, на которые смогу ответить, отвечу. Если вопросы по самому api, можете посетить страницу документации самого Notion. Ссылка на документацию Notion и мой телеграм есть в описании видео. Совет по поводу качества звука учту.
What structure is needed to add a URL to a database using Apple Shortcuts?
Url property item is basically a text field named “url” with url as it’s content. This goes inside the URL property dictionary:
{
"properties": {
"Website": {
"url": "developers.notion.com/"
}
}
}
Thank you! I wasn’t able to get it to work in Shortcuts, but I’ll keep trying!
I have to find the right mix of Dictionaries, Arrays, and Text, labeled properly.
{} - dictionary
[] - array
Good luck!
@@nazarzhmurko6461 can I pay you to teach me or to make a video about how to do it?
@@fromdonwithlove sure, I can teach you.
how to configure it for checkbox?
Wait for the upcoming video, where I'll describe how to do it based on the specific example. Stay tuned.)
@@nazarzhmurko6461 great!
Hi , very nice tutorial thanks !
However it doesn’t work for me , I did everything as you showed , but it give me an error message in the shortcut app saying that my API token is invalid , and I don’t know why . Can you help me please ?
Thanks a lot 🙏🏻😊
Hi, try to create a new integration.
@@nazarzhmurko6461 I did create a new integration in notion with a brand new API key but I got the same result , error 401 : API token is invalid . Do you know what is going on ?
I’ve change the version and I got a different result . Now he says error 400 saying body failed validation .
That means there is something wrong with request body structure. Try to go through the properties again.
@@nazarzhmurko6461 thanks I’ll try to do that
where do you get the URL from?
Hi, you mean request url in “Get Contents of URL” action?
hi nazar, something is not working on my side. do you have the shortcut somewhere available for download?
Hello! I've updated the video description and added the link for the demo shortcut.
@@nazarzhmurko6461 many thanks for the demo, downloaded and installed it. when i run it it gives me a status 404 error, can't find the database, although i am pretty sure i am using the correct 32 digits and letters data base id from the share menu in notion. any ideas would be greatly appreciated.
@@athanasiosdestanis1333 make sure you've inserted your database id correctly. Also, check if you added the right integration to the database.
@@nazarzhmurko6461 yes, i have checked and double checked. to no avail. i has checked my notion version number and updated it in the shortcut to 2021-08-16. now the shortcut tells me that it can "not parse response". do you know what that means?
@@athanasiosdestanis1333 The Notion-version value should be the same as before(i've no issues with the 2021-05-13). Look at the the integrations page.As far as I know, and, as said in Notion's api documentation, the only reason for "error 404" is the conflict with database id. Here is the formula for database id. Here is a database_id formula just in case: www.notion.so/myworkspace/(database_id)?v=...
Hey bro. My shortcut says api token invalid. All the time.
Hi, seems like the API token was written incorrectly. Please make sure it’s in the secret_xxxxxxxxxxxxxxxxx(the number of symbols after _ is variable). Also, check, whether or not you have inserted the API twice in the same field(if there are multiple “secret_” in the same field).
Very helpful thank you, but Im getting an error that says invalid API token. Checked all the steps 2 times over. Any ideas?
Hello! Did you include the "Bearer" word and your API with the secret_... in the beginning in Authorization's text field? If it won't help, you can view the shortcut once more directly on your device using this link: www.icloud.com/shortcuts/c310f9a1bdcc42d585ff55d6bdd3abff
Подписался на ваш канал)))
Thank you for the tutorial. Does it still work?
😀
You're welcome. Yes, except for the Notion-Version variable. This should be 2021-08-16.
Not sure what I’m doing wrong. I followed all the steps and keep getting this error message: {"status":401,"object":"error","code":"unauthorized","message":"API token is invalid."}
same;-(
Do you set up your shortcut on Mac?
@@nazarzhmurko6461 Nope, via Iphone
upd: I still don't get why it didn't work, but I decided to go another way: I copied your shortcut from icloud, substituted my api and database id, removed all parameters and scripts and started to add and test step by step. Now it's working;-) But I still have a question, is it possible to automatically set a reminder through date selection in shortcut?
Hi! Could you please describe more about what you mean by setting a reminder?
I’ve found some ways of how to export reminds from Apple reminder to the another places for example to the Notion API by means of shortcuts. Maybe it can be helpful. ruclips.net/video/vJVO4h76aZE/видео.html Unfortunately we can’t export completed tasks but we complete them already on the Notion for example
thanks for the tutorial! I'm the only one who get this as response?
{"status":401,"object" :"error" "code" :"unauthorized" "message": "API token is invalid."}
Hi, make sure you share the database with the integration and you pasted the APIs token correctly in the text field after “Bearer”.
@@nazarzhmurko6461 thanks for your response! Yes, i shared the db with the integration and i copied and pasted again the api token after "Bearer" just to be sure, but the shortcut give me the same response. I can't figure out what i did wrong yet. Any help is appreciated ☺
Do you setup your shortcut on Mac?
I got this! The api token wasn't working. I regenerate it again and now it works. Thanks for your video and your help! It's very interesting. Now I will try to use DB's relation with shortcuts 😁
There’s updated tutorial on my channel that includes automating relations.
I’ve found some ways of how to export reminds from Apple reminder to the another places for example to the Notion API by means of shortcuts. Maybe it can be helpful. ruclips.net/video/vJVO4h76aZE/видео.html
That sounds interesting.👍
Привіт, чи є в тебе україномовний канал? Дякую але чи буде?
{"status":400,"object":"error","code":"validation_error","message":"body failed validation: body.parent should be defined, instead was `undefined`.","request_id":"5c71012e-8414-4f93-a30c-4d7e10b9651c"}
I have this error Please help
I have the same error
@@spylol24 mine is ok already lol