Skip to main content
Best answer

Run a Zap everyday - Excel to Smartsheet

  • June 2, 2022
  • 1 reply
  • 83 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? 

 

Best answer by robschmidtBest answer by robschmidt

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.

View original
Did this topic help you find an answer to your question?
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

robschmidt
Forum|alt.badge.img+9
  • Zapier Expert
  • 617 replies
  • Answer
  • June 3, 2022

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.