Hello,
I'm setting up a workflow in Zapier where it triggers upon the addition of a new file to a OneDrive folder, allowing me to retrieve the file ID. My challenge is with Excel files: I need to automatically obtain the worksheet ID from these files to extract data, but currently, Zapier requires manual selection of the worksheet.
I want the flexibility to add various Excel files with different data to the folder without having to manually select a worksheet ID each time. Is there a way to automate the retrieval of worksheet IDs so that the process can continue seamlessly with different files?
Any suggestions or workarounds would be greatly appreciated!
