{"id":53,"date":"2025-12-24T17:17:42","date_gmt":"2025-12-24T09:17:42","guid":{"rendered":"https:\/\/lmn516.com\/?p=53"},"modified":"2026-03-01T16:12:52","modified_gmt":"2026-03-01T08:12:52","slug":"%f0%9f%93%88-%e3%80%90%e6%95%88%e7%8e%87%e6%8f%90%e5%8d%87%e3%80%91google-apps-script-%e8%84%9a%e6%9c%ac%e6%89%b9%e9%87%8f%e8%bf%bd%e8%b8%aa-tiktok-%e5%b8%a6%e8%b4%a7%e8%a7%86%e9%a2%91%e6%92%ad","status":"publish","type":"post","link":"https:\/\/lmn516.com\/?p=53","title":{"rendered":"\u4e00\u79cd\u7edf\u8ba1 TikTok \u5e26\u8d27\u89c6\u9891\u64ad\u653e\u91cf\u7684\u65b9\u6cd5\ud83d\udd0e"},"content":{"rendered":"\n
\u75db\u70b9\uff1a\u5982\u4f55\u4fbf\u6377\u7edf\u8ba1 TikTok \u89c6\u9891\u6570\u636e\uff1f<\/h5>\n\n\n\n

\u4f5c\u4e3a TikTok \u8fd0\u8425\u3001\u8fbe\u4ebaBD\u6216 MCN \u673a\u6784\uff0c\u6211\u4eec\u5728\u8ddf\u8fdb\u8fbe\u4eba\u5efa\u8054\u8fdb\u5ea6\u65f6\uff0c\u9891\u7e41\u9700\u8981\u76d1\u6d4b\u5408\u4f5c\u89c6\u9891\u7684\u64ad\u653e\u91cf<\/strong>\u8868\u73b0\u3002<\/p>\n\n\n\n

\u76ee\u524d\uff0c\u6211\u4eec\u4e3b\u8981\u4f9d\u8d56\u4ee5\u4e0b\u65b9\u5f0f\uff1a<\/p>\n\n\n\n

    \n
  1. \u624b\u52a8\u5728 TikTok \u9875\u9762\u9010\u4e00\u67e5\u770b\u3002<\/li>\n\n\n\n
  2. \u5728 TikTok Affiliate \u540e\u53f0\u67e5\u770b\u90e8\u5206\u6570\u636e\u3002<\/li>\n<\/ol>\n\n\n\n

    \u7136\u800c\uff0c\u8fd9\u4e9b\u65b9\u5f0f\u90fd\u6548\u7387\u4f4e\u4e0b\uff0c\u65e0\u6cd5\u5b9e\u73b0\u6279\u91cf\u3001\u5b9e\u65f6\u7684\u8ddf\u8fdb<\/strong>\u3002\u90a3\u4e48\uff0c\u6709\u6ca1\u6709\u4e00\u79cd\u65b9\u6cd5\u80fd\u591f\u5c3d\u53ef\u80fd\u4fbf\u6377\u5730\u7edf\u8ba1 TikTok \u5e26\u8d27\u89c6\u9891\u7684\u64ad\u653e\u91cf\u6570\u636e\u5462\uff1f<\/p>\n\n\n\n

    \u6211\u4eec\u901a\u8fc7 Google Sheets + Google Apps Script<\/strong> \u7684\u7ec4\u5408\uff0c\u5feb\u901f\u5b9e\u73b0\u4e86\u8fd9\u4e00\u81ea\u52a8\u5316\u6570\u636e\u76d1\u6d4b<\/strong>\u7684\u60f3\u6cd5\u3002<\/p>\n\n\n\n

    \n\n\n\n
    \ud83d\udee0\ufe0f \u64cd\u4f5c\u6d41\u7a0b\uff1aGoogle Apps Script \u5feb\u901f\u5b9e\u73b0<\/h5>\n\n\n\n
    \u6b65\u9aa4\u4e00\uff1a\u521b\u5efa Google Sheet \u8868\u683c\u7ed3\u6784<\/h6>\n\n\n\n

    \u65b0\u5efa\u4e00\u4e2a Google Sheet \u8868\u683c\uff0c\u8bbe\u5b9a\u4ee5\u4e0b\u4e24\u5217\uff1a<\/p>\n\n\n\n

    A\u5217<\/strong><\/td>\u89c6\u9891\u94fe\u63a5 (Video Link)<\/strong><\/td><\/tr><\/thead>
    B\u5217<\/td>\u89c6\u9891\u64ad\u653e\u91cf (Play Count)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \u6b65\u9aa4\u4e8c\uff1a\u65b0\u5efa Google Apps Script<\/h6>\n\n\n\n
      \n
    1. \u5728 Google Sheet \u83dc\u5355\u680f\u4e2d\uff0c\u70b9\u51fb “\u62d3\u5c55\u7a0b\u5e8f<\/strong>” > “Apps Script<\/strong>“\u3002<\/li>\n\n\n\n
    2. \u5c06\u4ee5\u4e0b\u811a\u672c\u590d\u5236\u7c98\u8d34\u5230\u4ee3\u7801\u7f16\u8f91\u5668\u4e2d\u5e76\u4fdd\u5b58\uff08\u6587\u4ef6\u540d\u79f0\u53ef\u81ea\u5b9a\u4e49\uff09\u3002<\/li>\n<\/ol>\n\n\n\n

      JavaScript<\/p>\n\n\n\n

      function getTikTokViews(url) {\n  \/\/ \u5b9a\u4e49\u7b2c\u4e09\u65b9 API \u5730\u5740\uff0c\u7528\u4e8e\u89e3\u6790 TikTok \u89c6\u9891\u4fe1\u606f\n  var api = \"https:\/\/www.tikwm.com\/api\/?url=\" + encodeURIComponent(url);\n\n  \/\/ \u4f7f\u7528 Google Apps Script \u7684 UrlFetchApp.fetch \u53d1\u9001 HTTP \u8bf7\u6c42\u83b7\u53d6\u6570\u636e\n  var response = UrlFetchApp.fetch(api);\n  \n  \/\/ \u5c06\u8fd4\u56de\u7684 JSON \u5b57\u7b26\u4e32\u89e3\u6790\u4e3a JavaScript \u5bf9\u8c61\n  var data = JSON.parse(response.getContentText());\n\n  \/\/ \u8fd4\u56de\u6570\u636e\u5bf9\u8c61\u4e2d\u5bf9\u5e94\u7684\u64ad\u653e\u91cf\u5b57\u6bb5 (play_count)\n  return data.data.play_count;\n}\n<\/code><\/pre>\n\n\n\n
      \u3010\u539f\u7406\u7b80\u6790\u3011<\/strong><\/p>\n\n\n\n