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

Question

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.

ken.a · Accepted Answer

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-0Additionally, 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-triggerHopefully, this points you to the right direction!😊

jakeprodsaw · Answer

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-0Additionally, 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-triggerHopefully, 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!

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded