English / 简体中文

Notion Regular Auto Backup to Google Drive

Introduction

By using the export function of the Notion API, this pipeline saves the contents of a workspace in Notion regularly as a zip file and uploads it to Google Drive for backup. This pipeline is based on the notion-up project and integrates with the gdrive v3.x project. There are some issues with the dump of databases, but text types are still acceptable. Currently, it only serves as a backup and there is no diff analysis. This is because the structure of my own Notion is too complicated and there is no need for analysis.

Step by Step Guide

flowchart LR
    A[(Notion token_v2)] --> A1[[Modify '.config_file.json']]
    B([gdrive download/add account/get file ID of the version to be updated]) --> B1[[Modify GFILEID in pipline.sh]]
    C([python virtual environment]) --> C1[/Execute create_python_env_in_new_machine.sh/]
    A1 & B1 & C1 --> D[/Execute pipline.sh/]
    D --> E[/Set crontab as a scheduled task/]

    style D fill:#ecdfb6,color:#0b111a
    
    click A href "https://github.com/dario-github/notion_backup#getting-notion-token_v2" _self
    click B href "https://github.com/dario-github/notion_backup/edit/master/README.md#gdrive-environment" _self
    click E href "https://github.com/dario-github/notion_backup#setting-up-scheduled-execution" _self

Loading

Obtaining Notion token_v2

Login to your Notion account on the notion.so website. Press F12 and find the token_v2 in the Cookies under the Applications tab.

gdrive Environment

Creating Google API

Refer to the method provided by gdrive for creating a Google API.

Adding Accounts

# Download/add account for gdrive

wget https://github.com/glotlabs/gdrive/releases/download/3.6.0/gdrive_linux-x64.tar.gz && unzip gdrive_linux-x64.tar.gz
mkdir -p /root/go/bin && mv gdrive -t /root/go/bin
/root/go/bin/gdrive account add

Obtaining ID of File to be Updated

Get the file link in Google Drive, and the string before "view" in the link is the file ID. Replace the GFILEID in pipline.sh with this ID.

For example:

https://drive.google.com/file/d/1C1SS2Uz8WV63uQkeovpnZAI71eNrAEdV/view?usp=share_link
Here, 1C1SS2Uz8WV63uQkeovpnZAI71eNrAEdV is the file ID

Setting Up Scheduled Execution

# Add a line to crontab to execute pipeline every Sunday at 3am and log the output.

0 3 * * 0 /bin/bash /xxx/notion-up/pipline.sh >> /xxx/notion-up/pipline.log 2>&1

Routine Maintenance

The notion_v2 token will become invalid every three months and will need to be obtained again.

Dependencies

• Notion API
  • Version changes
  • New elements' export may have formatting issues?
• Google OAuth client
  • Authorization methods may change for security reasons

Contributions

• Notion-up - https://github.com/kaedea/notion-up
• Gdrive 3.x - https://github.com/glotlabs/gdrive