【Google sheet script link】 google json fotmat link: https://script.google.com/macros/s/AKfycbygukdW3tt8sCPcFDlkMnMuNu9bH5fpt7bKV50p2bM/exec?id=SheetID&sheet=Sheet1 google drive下的文件demo_data1.xsl共享鏈接為： https://docs.google.com/spreadsheets/d/1Zp62yxz4Bv3sNWwyeYABm5MqAkxt9nHI5Gj7H1iKLwI/edit?usp=sharing id: 1Zp62yxz4Bv3sNWwyeYABm5MqAkxt9nHI5Gj7H1iKLwI sheet: demo_data_sheet1 demo_data1.xsl的demo_data_sheet1顯示為json格式為： https://script.google.com/macros/s/AKfycbygukdW3tt8sCPcFDlkMnMuNu9bH5fpt7bKV50p2bM/exec?id=1Zp62yxz4Bv3sNWwyeYABm5MqAkxt9nHI5Gj7H1iKLwI&sheet=demo_data_sheet1 demo_data1.xsl的全部顯示為json格式為： https://script.google.com/macros/s/AKfycbygukdW3tt8sCPcFDlkMnMuNu9bH5fpt7bKV50p2bM/exec?id=1Zp62yxz4Bv3sNWwyeYABm5MqAkxt9nHI5Gj7H1iKLwI 【google sheet api】 https://cloud.google.com/video-intelligence/docs/quickstart#set_up_your_project 要點： 1.添加生成的client_email，分享鏈接的email 2.$spreadsheetId指文件id，$range中T1指Sheet123的名稱，A1:17，是指A1表格，到第17行所有的文字 ~~~ $spreadsheetId = '1CUo2lG9nSifitJ3M9j1RUSf0PSTYMAu3Umlenf-N_dI'; $range = 'T1!A1:17'; ~~~