Mass file transfer from One Drive folders to Smartsheet Attachments

Julia C Peterson
Julia C Peterson ✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

Hello,

I'm wondering if this is possible through the One Drive connector, any automation tool, or API.

I have roughly ~1,000 folders in OneDrive, and the folders are named by client ID. Each client has 1 row in a smartsheet tracker, and the primary column is the client ID. The goal is to have all of the attachments in each folder be attached to the corresponding client's row through mapping folder ID to the primary column (or first mapping the primary column value to the row ID, and then mapping folder name to row ID)

Any ideas? Ideally I want the attachments themselves to be added to smartsheet, not just a link to one drive.


Thanks,

Julia

Best Answers

  • Etienne Mermillod
    Etienne Mermillod ✭✭✭✭✭
    Answer ✓

    Hi Julia,

    It's technically possible to loop over all files inside of SharePoint and upload them to Smartsheet but will require some custom development to implement the solution.

Answers