【google sheet data insert into database】 前提需要下載后google sheet api，做對應的配置： ~~~ <?php require_once 'vendor/autoload.php'; $connect = mysqli_connect("localhost", "root", "", "test"); $keys = json_decode(file_get_contents("credential2.json")); $client = new Google_Client(); $cred = new Google_Auth_AssertionCredentials( $keys->client_email, array(Google_Service_Drive::DRIVE), $keys->private_key ); $client->setAssertionCredentials($cred); $service = new Google_Service_Sheets($client); $spreadsheetId = '1YTT5jalDj5HzspsNcx7qUmCxttUyKsQfNRO_XyKItoo'; $sheets = array('S1', 'S2'); foreach ($sheets as $number) { $range = ''.$number.'!A1:30'; $result = $service->spreadsheets_values->get($spreadsheetId, $range); $ranges = $result->getValues(); echo '<pre>'; print_r($ranges); echo '<hr/>'; if(is_array($ranges)) { foreach($ranges as $row => $value) { $data1 = mysqli_real_escape_string($connect, $value[0]); $data2 = mysqli_real_escape_string($connect, $value[1]); $data3 = mysqli_real_escape_string($connect, $value[3]); $sql = "INSERT INTO demo(list1, list2, list3) VALUES ('".$data1."', '".$data2."', '".$data3."')"; mysqli_query($connect, $sql); } } } ~~~ 選取google sheet的位置：S1表的A, B, D列：  S2表的A, B, D列：  插入數據表后的效果：