背景：最近在网上找了一个很好用notion的记账模板，也坚持记账了一个月。但这个模板不方便分析，也没有预算管理的功能。
所以我提了两个业务需求：

  1. 按照支出的category结算总额，并更新到budget table
  2. 为了可视化当前预算的支出状态，我要把notion里的budget table里的数据同步到了google sheet，在google sheet里添加图表进行分析

Technically，这个项目里的技术feature有：

  1. 分页查询一个notion database里的所有数据
  2. 更新notion database里的data
  3. 用Google Sheet API更新Google Sheet里指定区域的数据

项目地址: https://github.com/flipped895/Notion-Table-Sync

Project Overview

Background

Recently, I found a easy-to-use Notion bills tracker template online and have been diligently tracking my expenses with it for a month. However, the template lacks convenient analysis features and does not support budget management. To address these issues, I have defined two key requirements:

  1. Calculate the total amount spent by category and update it in the budget table.
  2. To visualize the current budget expenditure status, synchronize the data from the Notion budget table to Google Sheets, where charts can be added for analysis.

Project Requirements

  1. Category Total Calculation: Automatically calculate the total amount spent in each category and update the results in the Notion budget table.
  2. Data Synchronization and Visualization: Synchronize the data from the Notion budget table to Google Sheets and add charts in Google Sheets for visual analysis of expenditure status.

Technical Features

This project implements the following technical features:

  1. Paginated Query of Notion Database: Implements paginated queries to retrieve all data from a Notion database, which is useful for handling large datasets.
  2. Updating Notion Database: Provides functionality to update specific data in the Notion database, ensuring the latest budget data is synchronized.
  3. Google Sheets API Update: Utilizes the Google Sheets API to update specific ranges of data in Google Sheets, facilitating data analysis and visualization.

Future Improvements

  • Waiting for requirements to be raised…