Track new OneDrive files in a Google Sheet

OneDrive

OneDrive

Google Sheets

Google Sheets

If you have a folder in OneDrive that you put files you want to keep a record of, you can now automatically track the addition of that file in a Google Sheet. This Google Sheet must have a first row with column headers called Name and Date.