WeChat and Alipay bills are sent to emails, and email attachments are extracted and imported into Notion
微信和支付宝账单发送至邮箱,邮件提取附件导入Notion
It is recommended to find a related accounting template to achieve better results when using this tool.
This project does not use the official APIs of WeChat Pay and Alipay. The official APIs are only available to merchants, and ordinary users currently cannot use them. For more details, click: Introduction - Interface Rules | WeChat Pay Merchant Platform Documentation Center Query Bill Interface - Alipay Documentation Center (alipay.com)
This project was inspired by this article from SSPai. Thanks to SSPai for providing the idea.
-
Enable the IMAP protocol for your email account. You can search the internet for instructions. Here is an example of how to enable it for a 163.com email account: Help Center - Common Questions about IMAP (163.com)
-
Export the bills and send them to your email.
-
Copy the sample database. It is recommended to
duplicate
this Bill Import to Notion Template. After getting familiar with it, you can modify it as needed. -
Customize the Notion Integration
-
Download this project
-
Run the
config_duplicate.py
file -
Fill in the
config_private.yaml
file as follows:email_config: imap_url: "l3*********@163.com" password: "HZ************TG" username: "imap.163.com" notion_config: database_id: "c1a348********************4c7" # Database ID token: "secret_OHvKVP*******************Lq" # Token
Details about database_id
https://www.notion.so/tsinglin/68111a1sssssss487a884cafcd5333310c?v=3d0c405e7cae405599aed2fe0f5233cc
database_id: 68111a1sssssss487a884cafcd5333310c