• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Workflow Help to add new file name (in OneDrive) to an Excel tab based on parent folder

I am trying to accomplish the following: Create a production log for a law firm in OneDrive.
Top folder is: State Clients, under this each client has a folder with their name, ClientLast, FirstName, the next level has 2 folders: Disclosures and Discovery, and each 3 further subfolders: Section A, Section B, Section C.

I have an Excel log file that lives in the Disclosures subfolder. When a new file is added to either Section A, Section B, or Section C folders, I want the name added to the appropriate tab on the log file. Excel sheet names correspond to Section A, Section B, Section C.

I have not found how to parse out the immediate folder to match to the tab. Ideally, I would also like to pass the client folder name to a router so this automation will work for all clients, rather than needing to set up a separate automation for each client.

Any help is appreciated, how can I parse out these folder names from the file path of the new file?
 
P

Pabblymember11

Guest
Hey @JayleenSFS

In Pabbly Connect, set up the workflow to trigger when a new file is added to any "Section A," "Section B," or "Section C" folder within your OneDrive structure. Use the "Text Formatter" tool to split the file path by the `/` delimiter, extracting the client folder name (2nd element) and the section folder name (4th element).


With the help of the Router action step, you can route the workflow based on the section folder name to update the corresponding Excel tab (Section A, B, or C) using the **"Google Sheets"** or **"Excel"** action. This setup allows one automation to handle all clients dynamically.

 
Top