Question

Create rows in google sheet from post request

  • 15 September 2021
  • 2 replies
  • 98 views

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_arr[0]['contact']['Name']='test1';
$new_arr[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 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

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_arr[0]['contact']['Name']='test1';
$new_arr[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