Reputation: 1857
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?
Upvotes: 3
Views: 1254
Reputation: 7153
No. See the official Google response on this.
They do suggest parallelizing your requests to speed up the insertion process.
Upvotes: 3