Skip to main content

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!

Hi there @karenachi,

Welcome to the Community! 🎉

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please send a screenshot of the “Action” section of your action steps that shows all of its fields. Like so:

46dd6c0979e3d815d621b8da43084ef1.png
(view larger)

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!


Reply