views:

145

answers:

1

Inserting rows one by one from a 600 record data-set is taking almost an hour, using the following method:

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

Is it possible to insert multiple rows at once?

+2  A: 

No. See the official Google response on this.

They do suggest parallelizing your requests to speed up the insertion process.

David