■Overview
Automatically register task information from the Notion task management database as all-day events in Google Calendar.
Only new tasks will be registered, and updated tasks will be excluded from the flow.
■Preparation
・Create a task management database in Notion in advance.
※For an actual example, please refer to this link: https://sulky-aftershave-b1d.notion.site/6729db5cf9ff4a26ae2156f44bc2b174?v=db2791f6600d429e9d7796834a753e30&pvs=4
■Setup Method
① Select Notion from the app triggers and press the action when a page is created or updated in a specific database.
② Enter the launch interval and database ID, then test and save.
※For common errors when integrating with Notion, please refer to here.
③ Press the + mark under the trigger and select "Branch".
④ Set the operation to the trigger set in ① and the output to the creation date.
⑤ Set the condition to "not equal to the value" and embed the last updated date obtained in ① as {{Last Updated Date}} in the output and save.
※For details on dynamically using outputs, please refer to here.
⑥ Press the + mark, select Notion from the operation to manipulate the database, and proceed to the next step by selecting "Retrieve Record (ID Search)" from the action and entering the same database ID as the trigger.
⑦ Set the search condition to "Record ID equals" and embed the object ID obtained from the trigger in ① as {{Object ID}}, then test and save.
⑧ Press the + mark, select the action to add or subtract dates from the operation to manipulate and transform data.
⑨ Embed the task's due date obtained in ⑦ as the target date, set the condition to +1 day, assign an arbitrary output name, and test and save.
⑩ Press the + mark, select Google Calendar from the operation to integrate with the app, and choose the action to create an event.
⑪ On the next page, set as follows, test, save, and complete the setup.
・Calendar ID: Enter your Gmail address directly
・Event Title: Embed the task name obtained in ⑦
・Event Start Date: Embed the task's due date obtained in ⑦
・Event Start Time: 00:00
・Event End Date: Embed the due date added in ⑨
・Event End Time: 00:00
・Event Details: Optional input
■Notes
・Be sure to register tasks by adding a new row.
※This is because using the default empty row after creating the database will cause discrepancies between the creation and update dates.
.avif)
.avif)
