I 🔨 things. Interested in plain text productivity (ObsidianMD) & engineering. If you want to talk about this mail me.

Home

how to integrate notion with telegram

This article desribes how to integrate notion with telegram. I needed to send a daily notification with all my overdue contacts from my notion CRM table. The article assumes you understand the basics of how to manage infrastructuremanage infrastructure
This article describes how you setup your work environment to be productive. I'm a knowledge worker so, at the core at what I do is writing. Therefore, this setup focuses on my writing environment....
with CDK. The article focuses on the telgram / notion specifics.

Requirements

I have a Notion database with people I stay in touch. Inside the table I have a field Last Contacted and Cadence days. The formula in Status checks if the today is later than last contect + Cadence days. In cases that today is later it contains "Time to reach out!".

if(dateBetween(now(), prop("Last Contacted"), "days") > prop("Cadence days"), "Time to reach out!", "👍")

Everday at 8 I want to recieve a list of all overdue contacts to reach out in Telegram. The solution be cheap.

Solution

The solution is a serverless cron job that triggers a lambda fuction that get the overdue contacts through the notion api and send the notifications to the telegram bot and the bot then sends this to me.

Project Setup

Follow manage infrastructuremanage infrastructure
This article describes how you setup your work environment to be productive. I'm a knowledge worker so, at the core at what I do is writing. Therefore, this setup focuses on my writing environment....
up to "Implement Code and Use Level 2/3 Contructs (Add an AWS Lambda Function to Your Stack)" to:

  • init repo,
  • create cdk template,
  • authenticate and bootstrap

chore: init cdk

Implement the Cron Job

Next remove the sample cdk resources and add the cronjob based on AWS Eventbridge:

feat: add cron job

Add Integration Lambda Function

Next add an Lambda function that contains the integration, including stubs for the function to get theget_contacts_overdue (from Notion) and send_message (to Telegram). Trigger this lambda function from the cron job. First install a new new dependency with pip install aws_cdk.aws_lambda_python_alpha && pip freeze > requirements.txt

feat: add integration lambda to cron job

Then Get the Overdue Contacts From the Notion Api (registration, Code, query)

Next register and api client ("integration") with notion and write down the api key

Then give the app permission to access the table: Find the table id

Then add the notion client implement the business logic to query the database for the overdue contacts. In this cases this means that the collumn Status contains Time to reach out!1

pip install pytest notion-client && pip freeze > requirements.txt

feat: query overdue contacts from notion

Then Send the Overdue Contacts to Telegram (registration, Code to Build requests)

Register a bot, as a result you get a botKey, find out the userId you want to send to and then create an REST request to send a message to the bot that is then send to the user.2 Then you implement this into the integration lambda function. After the function collected the overdue contacts with names and links, create a text to send to the telegrambot. In that request add the botKey and the userId and telegram then sends the message to the user.

feat: send message to telegram

Replace Environment Variables with AWS Systems Manager Paramter Store

Replace the environment variables with paramters from AWS SSM. SSM has the benefit you can encrypt. To access SSM you need to boto3:

pip install boto3 && pip freeze > requirements.txt

Then you manually create the paramters in SSM (currently you can create encrypted SSM paramter with CDK): See manage infrastructuremanage infrastructure
This article describes how you setup your work environment to be productive. I'm a knowledge worker so, at the core at what I do is writing. Therefore, this setup focuses on my writing environment....
(Store Credentials Securly Using SSM).

feat: store credentials in parameterstore

Footnotes & Resources