定时 Google Sheets 数据备份到 Google Drive

• •Google Drive API 凭证
• •Google Sheets API 凭证

{
  "meta": {
    "instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "c92f4d85-fd92-48ff-afc3-159b54ef8d54",
      "name": "每日备份计划（凌晨2点）",
      "type": "n8n-nodes-base.cron",
      "position": [
        -80,
        16
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fda053c6-5faa-4a13-b49d-6eca379f8a14",
      "name": "读取Google Sheets数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        352,
        16
      ],
      "parameters": {
        "operation": "getAll",
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_SOURCE_GOOGLE_SHEET_ID"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "jbsHmT1qCK9d35Ou",
          "name": "Google Sheets account 6"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "65ac2d1d-d51a-4193-b31b-fd62008af926",
      "name": "上传备份到Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        576,
        16
      ],
      "parameters": {
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "options": {},
        "folderId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_DESTINATION_GOOGLE_DRIVE_FOLDER_ID"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "IPz4dCJVFC8uaoHw",
          "name": "Google Drive account 2"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "23e8110e-a5ae-4265-aec2-24fed16b6f05",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        736,
        -384
      ],
      "parameters": {
        "height": 720,
        "content": "## 设置步骤"
      },
      "typeVersion": 1
    },
    {
      "id": "c7ab73c2-82e3-4325-a2f6-6be147c3f2f6",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -336,
        -336
      ],
      "parameters": {
        "height": 688,
        "content": "## 配置节点"
      },
      "typeVersion": 1
    },
    {
      "id": "ef4e8c84-1992-49a1-977f-3cb557e784b6",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -240
      ],
      "parameters": {
        "height": 416,
        "content": "## 定时将Google Sheets数据备份到Google Drive"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Read Google Sheet Data": {
      "main": [
        [
          {
            "node": "Upload Backup to Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Backup Schedule (2 AM)": {
      "main": [
        [
          {
            "node": "Read Google Sheet Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}