■Overview
The "Add files from OneDrive to Google Sheets" workflow is a business workflow that streamlines file management and data organization. When a new file is uploaded to OneDrive, the information is automatically recorded in Google Sheets. This facilitates smooth file tracking and sharing, eliminating the need for manual data entry. Utilize Google Sheets' automatic sending feature to easily share the latest file information with the entire team.
■Recommended for
■Benefits of using this template


When a row is added
When a row is updated
When a file is created or updated in a specific folder
When a folder is created or updated in a specific folder
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
When a row is added
When a row is updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
Insert columns
Delete columns
Write values to multiple columns
When a file is created or updated in a specific folder
When a folder is created or updated in a specific folder
Search Folder/File
Retrieve List of Files in Specific Folder
Create Folder
Download File
Upload File
Copy a File
Create Excel File
Grant Permissions to Folder or File
Change Folder or File Name
Create Share Link
Delete File/Folder
Move File to Another Folder