Best answer

Run a Zap everyday - Excel to Smartsheet

  • 3 June 2022
  • 1 reply
  • 66 views

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? 

 

icon

Best answer by robschmidt 3 June 2022, 02:51

View original

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

1 reply

Userlevel 7
Badge +9

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.