I am trying to set up a Zap that allows a new row to be added to an Excel sheet. In setting it up, I am successfully able to connect to one drive, go to the folder, and even open the Excel file, but then when I am supposed to choose the worksheet, nothing comes up. This means that I cannot even go forward. I have tried it with multiple files, including files I am making just to see what is going on. Zapier is able to see the excel file itself, but not the workbooks within it.
Please help! Thank you.