Real-time OneDrive to Google Sheets Automation
Budget: £10 – £45 GBP
I'm seeking a skilled Power Automate expert to design a flow that comprehensively tracks my OneDrive for Business contents.
Key Requirements:
- The flow should catalogue all files, folders, and subfolders in my OneDrive for Business and relay this information to a Google Sheet.
- It should facilitate real-time updates of the Google Sheet in the event of any changes in OneDrive, such as the addition, creation, deletion, movement, or renaming of files or folders.
- The data should be formatted according to a custom structure in the Google Sheet as follows:
Folder Name, Folder Path, File Name, File Size, Created At, File Link, Folder Link
Ideal Skills and Experience:
- Proven expertise in Power Automate and Google Sheets.
- Prior experience with real-time data synchronization.
- Ability to create custom data formats in Google Sheets.
- Knowledge of OneDrive for Business is a plus.
Key Requirements:
- The flow should catalogue all files, folders, and subfolders in my OneDrive for Business and relay this information to a Google Sheet.
- It should facilitate real-time updates of the Google Sheet in the event of any changes in OneDrive, such as the addition, creation, deletion, movement, or renaming of files or folders.
- The data should be formatted according to a custom structure in the Google Sheet as follows:
Folder Name, Folder Path, File Name, File Size, Created At, File Link, Folder Link
Ideal Skills and Experience:
- Proven expertise in Power Automate and Google Sheets.
- Prior experience with real-time data synchronization.
- Ability to create custom data formats in Google Sheets.
- Knowledge of OneDrive for Business is a plus.