Skip to main content

I need help running a Zap everyday at 9am (I got this figured out with “Schedule by Zapier”)

 

I want to update an excel sheet to smartsheet everyday at 9am

 

I have this also figured out where Excel is updated, triggers the update to push to Smartsheet. 

 

I don’t want it to run 600 + times, only 1 time when all the updates are completed. Is this possible? 

 

Hi @alennon 

You can manually do this with Transfer by Zapier. With Transfer you can move a lot of rows at once to smartsheet.

If you want it to be automatic, you’ll need to use Excel Online’s API to get all the rows and then Loop by Zapier to iterate each rows and at the end use smartsheet action to import rows to your smartsheet.