Mass file transfer from One Drive folders to Smartsheet Attachments
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.