Question

How to copy Google Sheets Rows in a Batch to Smartsheet?

  • 9 April 2024
  • 1 reply
  • 11 views

Dear Community, 

There are two type of rows I need to copy from GSheets to Smartsheet. 

If the row in Gsheet contains e-mail address it should be copied immediately - I created  the zap created and works perfectly. So in Smartsheet we can use autoresponse etc. 

However ff the row in Gsheet does not contain e-mail address it should be moved as a batch from Gsheet to Smartsheet like once per day so all my Zapier tasks are not consumed in the first week :) - Is this possible? 


1 reply

Userlevel 7
Badge +14

Hi @kowal 

Most Zap steps work on a per record basis.

It appears all the Smartsheet Zap actions work on a per record basis.

Unless you use the Smartsheet API, if that supports bulk operations.

If so, the Smartsheet API can be used via an advanced action “API Request”.

Otherwise, you would need to process each GSheet row individually, even on a schedule, so you wouldn’t be saving Tasks.

 

Steps

  1. Trigger: Schedule
  2. Action: GSheets - Lookup Row(s)
    1. Needs a common value in a column to find all the desired rows
  3. Action: Looping - Create Loop from Line Items
  4. Action: Smartsheet - Add Row to Sheet

 

 

Reply