Skip to main content

I need to create multiple rows in google sheet in a single hit via zapier.

Basically I need how to send request to zapier which can further use that to create multiple rows in google sheet problem I am facing is it is treating request a separate or first row is considered as request. 

For example, I use array in post to create rows: 

$new_arr=array();
$new_arrr0]0'contact']''Name']='test1';
$new_arrr1]1'contact']''Name']='tst1';
 

but Zapier take it as two request which allow me to create single row in google sheet.

Please help in making proper request or recognizing multiple rows request in zapier.

Thanks 

Hi @VarinderK 

Try using the GSheets Create Spreadsheet Rows action.

OR try using the Looping app to handle line item arrays: https://zapier.com/apps/looping/integrations


Thank you@Troy Tessalone for your reply. 

I tried google sheets rows action but I am facing problem in sending to request to zapier. Zapier taking my request as multple. For example I send array like this:

$new_arr=array();
$new_arrr0]0'contact']''Name']='test1';
$new_arrr1]1'contact']''Name']='tst1';

It take this request as two request and accept only first Name variable or second Name variable but I want to 

send both and create multiple rows.

Thanks
Hi @VarinderK 

Try using the GSheets Create Spreadsheet Rows action.

OR try using the Looping app to handle line item arrays: https://zapier.com/apps/looping/integrations