A living index of your folder in a spreadsheet

The scenario walks a folder in your storage and adds a row to your sheet for every file: name, type, link and dates. Already-indexed files are never duplicated.

  • Find a file by searching a table, not by scanning a folder
  • Re-runs only add to the index
  • A direct link to the file in each row
  • You can see what appeared and when
Google Sheets
Set it upScriptera

How it works

To move data from Microsoft OneDrive to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: When clicking ‘Execute workflow’
  2. Then: Config
  3. Then: List files and folders
  4. Check: Merge
  5. Then: Filter Already Indexed Files
  6. Then: Prepare Index Row
  7. Then: Append Row to Index Sheet
  8. Then: Get Existing Index Rows

You can launch this Microsoft OneDrive + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios