Insert hundreds of rows into a Google spreadsheet using Zend Gdata?

Inserting rows one after another from a 600 records dataset takes almost an hour using the following method:

foreach($people as $person){
    $insert['name'] = $associate -> name;
    $insertedListEntry = $spreadsheetService->insertRow($insert, $spreadsheetKey, $worksheetId);
}

Can I insert multiple rows at once?

+3
source share
1 answer

No. See Google’s official answer to this.

They suggest parallelizing your queries to speed up the insertion process.

+3
source

Source: https://habr.com/ru/post/1740043/


All Articles