javanile
diff --git a/‎src/Drivers/Google/Google.php
Lines changed: 65 additions & 2 deletions b/‎src/Drivers/Google/Google.php
Lines changed: 65 additions & 2 deletions
diff --git a/‎tests/Drivers/Google/GoogleTest.php
Lines changed: 5 additions & 1 deletion b/‎tests/Drivers/Google/GoogleTest.php
Lines changed: 5 additions & 1 deletion
@@ -294,6 +294,23 @@ public function getTables()
 		return $tables;
 	}
 
+    /**
+     *
+     */
+    protected function getTableHeader()
+    {
+        $header = [];
+        $headerRow = $this->getRow(0);
+        foreach ($headerRow as $colIndex => $colName) {
+            if (empty($colName)) {
+                continue;
+            }
+            $header[$colName] = $colIndex;
+        }
+
+        return $header;
+    }
+
     /**
      * @param $row
      * @param $col
@@ -422,8 +439,11 @@ public function insert($row)
     {
         $this->requireSheet();
 
-        $sheetTitle = $this->sheet->getProperties()->getTitle();
+        if (self::isKeyValueRow($row)) {
+            $row = $this->convertKeyValueRow($row);
+        }
 
+        $sheetTitle = $this->sheet->getProperties()->getTitle();
         $range = $sheetTitle.'!A:A';
         $requestBody = new \Google\Service\Sheets\ValueRange([
             'values' => [
@@ -480,12 +500,43 @@ public function getTranskey() {
     public function getRow($row)
     {
         $this->requireSheetTitle();
-        $range = '\''.$this->sheetTitle.'\'!'.$row.':'.$row;
+        $range = '\''.$this->sheetTitle.'\'!A'.($row + 1).':'.($row + 1);
         $response = $this->service->spreadsheets_values->get($this->spreadsheetId, $range);
 
         return $response->values[0];
     }
 
+    /**
+     *
+     */
+    protected function convertKeyValueRow($row)
+    {
+        $tempRow = $row;
+        $size = count($tempRow);
+        if (!isset($row[$size - 1])) {
+            $row[$size - 1] = '';
+        }
+        $header = $this->getTableHeader();
+        foreach ($tempRow as $key => $value) {
+            if (isset($header[$key])) {
+                if (isset($row[$header[$key]])) {
+                    $row[] = $row[$header[$key]];
+                }
+                $row[$header[$key]] = $value;
+                unset($row[$key]);
+            }
+        }
+        $maxKey = max(array_keys($row));
+        for ($index = 0; $index < $maxKey; $index++) {
+            if (!isset($row[$index])) {
+                $row[$index] = '';
+            }
+        }
+        ksort($row);
+
+        return $row;
+    }
+
     /**
      * @return int
      */
@@ -697,4 +748,16 @@ protected static function transformArrayToOneBased($values)
 
         return $newValues;
     }
+
+    /**
+     *
+     */
+    protected static function isKeyValueRow($row)
+    {
+        if (array() === $row) {
+            return false;
+        }
+
+        return array_keys($row) !== range(0, count($row) - 1);
+    }
 }
@@ -150,7 +150,11 @@ public function testInsert()
     {
         $this->driver->setDatabase('test');
         $this->driver->setTable('test');
-        $this->driver->insert(['A', 'B', 'C']);
+        $header = ['A', 'B', 'C', 'D', 'E'];
+        foreach ($header as $index => $column) {
+            $this->driver->set(1, $index + 1, $column);
+        }
+        $this->driver->insert(['B' => 1, 'C' => 2, 'D' => 3]);
     }
 
     public function testAll()
Original file line number	Diff line number	Diff line change
`@@ -150,7 +150,11 @@ public function testInsert()`
`150`	`150`	`{`
`151`	`151`	`$this->driver->setDatabase('test');`
`152`	`152`	`$this->driver->setTable('test');`
`153`		`- $this->driver->insert(['A', 'B', 'C']);`
	`153`	`+ $header = ['A', 'B', 'C', 'D', 'E'];`
	`154`	`+ foreach ($header as $index => $column) {`
	`155`	`+ $this->driver->set(1, $index + 1, $column);`
	`156`	`+ }`
	`157`	`+ $this->driver->insert(['B' => 1, 'C' => 2, 'D' => 3]);`
`154`	`158`	`}`
`155`	`159`
`156`	`160`	`public function testAll()`