Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Microsoft Excel error: Unable to find any more rows, create a new row in your account and try again.

jakeprodsaw

Setting up my first ZAP here!

I’m trying to have my excel sheet update my monday board when a row changes, but it won’t recognize all of my rows..

 

Yes, it’s a rather large workbook, but it would be great if possible.

Best answer by ken.aBest answer by ken.a

Hi there @jakeprodsaw,

Welcome to the Community! 🎉

Before you’re able to use Microsoft Excel spreadsheet as a Zap. Zapier requires you to set them up in a specific way, by adding headers to the columns of your spreadsheet.

You can read more about that here: https://help.zapier.com/hc/en-us/articles/8496044256909-How-to-Setup-Your-Microsoft-Excel-sheet-to-Work-With-Zapier#other-microsoft-excel-zap-tips-0-0

Additionally, in the context of Zapier and trigger sample data, "Row A," "Row B," "Row C," etc., often refer to rows in a spreadsheet or data table. When Zapier pulls sample data from your connected app, it displays the data from different rows for you to review and use in setting up the rest of your Zap.

You can also read about that here: https://zapier.com/help/create/basics/set-up-your-zap-trigger

Hopefully, this points you to the right direction! 😊

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.

3 replies

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6380 replies
  • Answer
  • May 19, 2023

Hi there @jakeprodsaw,

Welcome to the Community! 🎉

Before you’re able to use Microsoft Excel spreadsheet as a Zap. Zapier requires you to set them up in a specific way, by adding headers to the columns of your spreadsheet.

You can read more about that here: https://help.zapier.com/hc/en-us/articles/8496044256909-How-to-Setup-Your-Microsoft-Excel-sheet-to-Work-With-Zapier#other-microsoft-excel-zap-tips-0-0

Additionally, in the context of Zapier and trigger sample data, "Row A," "Row B," "Row C," etc., often refer to rows in a spreadsheet or data table. When Zapier pulls sample data from your connected app, it displays the data from different rows for you to review and use in setting up the rest of your Zap.

You can also read about that here: https://zapier.com/help/create/basics/set-up-your-zap-trigger

Hopefully, this points you to the right direction! 😊

jakeprodsaw
  • jakeprodsawBeginner
  • Author
  • Beginner
  • 1 reply
  • May 19, 2023
ken.a wrote:

Hi there @jakeprodsaw,

Welcome to the Community! 🎉

Before you’re able to use Microsoft Excel spreadsheet as a Zap. Zapier requires you to set them up in a specific way, by adding headers to the columns of your spreadsheet.

You can read more about that here: https://help.zapier.com/hc/en-us/articles/8496044256909-How-to-Setup-Your-Microsoft-Excel-sheet-to-Work-With-Zapier#other-microsoft-excel-zap-tips-0-0

Additionally, in the context of Zapier and trigger sample data, "Row A," "Row B," "Row C," etc., often refer to rows in a spreadsheet or data table. When Zapier pulls sample data from your connected app, it displays the data from different rows for you to review and use in setting up the rest of your Zap.

You can also read about that here: https://zapier.com/help/create/basics/set-up-your-zap-trigger

Hopefully, this points you to the right direction! 😊

Thank you!

 

Now, the next problem!

 

Effectively, I’m trying to mirror my excel sheet into Monday using the Update Item Name & Change Multiple Columns Value. See below..

 

I have a zap setup for each of the first three lines of my excel sheet into the corresponding rows of my Monday board.

The problem I’m now having is that when it does perform the task (after I alter the trigger column on one row), the zaps all either retrieve the same data, or get switched up in order. I have yet to have all three zaps work simultaneously.

I’ve gone over the items in each of the fields multiple times to make sure they are all grabbing a different row, but it gets tripped up somehow.

Any help is appreciated!

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6380 replies
  • June 2, 2023

Hi there @jakeprodsaw,

Unfortunately, I couldn’t replicate the issue you’re experiencing, but looking at the screenshot of your Zap setup I can’t see anything wrong with the Zap setup. 

Also, you mentioned that the Zaps all either retrieve the same data, or get switched up in order. I would recommend reaching out to our Support team regarding this issue. They can look closer at the Zap and its logs and determine the root cause of the issue.

You can reach our Support team here: https://zapier.com/app/get-help

Hopefully, this helps! 😊

Terms & Conditions