A Github Action regularly query Notion Database & send review reminder.

First, Fork this repository

Set GitHub Action Secrets

1. DATABASE_ID # Your Notion Database ID
2. TOKEN # Your Notion Integration Token
3. MAIL_USERNAME # Your E-Mail Sender adress
4. MAIL_PASSWORD # Your E-Mail SMTP Authorization code
5. MAIL_RECIPIENT # Your E-Mail recipient adress

In .github/workflows/reviewHelper-action.yml

• If you're not using Gmail as the sender, change the server_address in line 44.
• This action default runs per 12 hours, if you are not satisfied with that, change the cron setting.
  • for instance, run every 6 hours in every day: cron: "0 */6 * * *"

In index.js

• This action default sends 3 notes everytime. You can change that by setting const QUERY_NUM in line 12
• You need to change the const QUERY_KEYS to fit your database column names.
• Change or remove your sort setting in line 27. Need to match your target column name.

see this blog.