Get Started
Screenshot of n8n workflow
FREE TEMPLATE
Streamline Drive and OneDrive Excel Processing
0
Views
0
Downloads
24
Nodes
Download Template
Free
Preview Template
Utility Rating
7 / 10
Business Function
Operations
Automation Orchestrator
n8n
Integrations
SFTP Server
Microsoft OneDrive
Google Drive
Trigger Type
Manual trigger
Approx setup time ≈ 45 min
Need help setting up this template?
Ask in our free Futurise community
About
Community
Courses
Events
Members
Templates

How to Streamline Drive and OneDrive Excel Processing?

Leon Petrou
FREE TEMPLATE
Streamline Drive and OneDrive Excel Processing
0
Views
0
Downloads
24
Nodes
Download Template
Free
Preview Template
Utility Rating
7 / 10
Business Function
Operations
Automation Orchestrator
n8n
Integrations
SFTP Server
Microsoft OneDrive
Google Drive
Trigger Type
Manual trigger
Approximate setup time ≈ 45 minutes
Need help setting up this template?
Ask in our free Futurise community

Description

Collect, clean, and redistribute spreadsheet files without manual downloads or uploads. Teams that move reports between cloud drives or servers can turn raw files into ready to use spreadsheets in one run.

The flow starts on a manual run. It can pull a file from a public link, from Google Drive, from Microsoft OneDrive, or from a local file path. The Spreadsheet File node converts the Excel or CSV into rows that are easy to edit. A Set step labeled Work out Age shows how to add a new column or fix values. Then the data is written back into a fresh spreadsheet. The result can save to local disk, upload to an SFTP server, or go back to Google Drive or OneDrive.

To set it up, you need access to your Google Drive and OneDrive accounts and an SFTP server. Point the download step you plan to use to the correct file and disable the others. Map the upload nodes to the right folders. Expect faster report prep, fewer copy errors, and a simple way to keep files in sync across storage. Useful for weekly reports, partner file drops, and staff lists moved between teams.

Copy link

Tools Required

SFTP Server
Sign up
Tiny plan: €50 / mo (SaaS; includes REST API)
n8n
Sign up
$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.
Microsoft OneDrive
Sign up
Free: $0 / mo, 5 GB storage
Google Drive
Sign up
Drive API: $0 (no additional cost; quota-limited)

What this workflow does?

  • Manual start for safe test runs and controlled processing
  • Download a spreadsheet from a public URL using HTTP Request
  • Pull files directly from Google Drive with OAuth access
  • Fetch files from Microsoft OneDrive using secure login
  • Convert .xls .xlsx or .csv into JSON rows with Read Spreadsheet File
  • Add or fix columns with a Set step to compute new values
  • Write a clean spreadsheet with Write Spreadsheet File
  • Save locally or upload to SFTP Google Drive or OneDrive

What are the benefits?

  • Reduce manual work from 2 hours to 10 minutes per report
  • Streamline file collection and delivery by 80 percent
  • Improve data accuracy by removing copy paste errors by 90 percent
  • Connect Google Drive OneDrive and SFTP in one flow
  • Keep one standard file format for all teams

How to set this up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Drive, Microsoft OneDrive and SFTP Server. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, open the Google Drive nodes, choose Credential to connect with, click Create new credential, and follow the on screen steps to sign in with Google Drive OAuth2. Name the credential clearly.
  4. Open the Microsoft OneDrive nodes, choose Credential to connect with, click Create new credential, and complete the OAuth login. Use a clear credential name so your team recognizes it.
  5. Open the SFTP upload node and create an SFTP credential. Enter host, port, username, and either password or private key. Test the connection.
  6. If you plan to use a public link, open the Download Excel File node and paste the direct file URL. Set authentication only if the link needs it.
  7. If you plan to use a local file, open the Read Binary File node and set the file path to an accessible file on the n8n host.
  8. For Google Drive or OneDrive sources, select the source file or enter its ID. Confirm the binary property name matches what the Read Spreadsheet File node expects.
  9. Open Read Spreadsheet File and confirm the input binary property is correct. Choose the right file type if auto detect fails, for example CSV with the right delimiter.
  10. Adjust the Work out Age Set node to match your column names or remove fields you do not need.
  11. Configure Write Spreadsheet File with your desired format and file name. Then set target folder and file name in the SFTP, Google Drive, and OneDrive upload nodes.
  12. Disable the source nodes you are not using. Click Execute to run a test and check the output file in the destination folders.
  13. If you see permission errors in Drive or OneDrive, reauthenticate the credentials. If SFTP fails, verify host, port, and firewall rules. If the file will not parse, confirm the sheet structure and headers.

Need help or want to customize this?

Ask in the Free Futurise Community.

Similar Templates

n8n
Operations
Automate Google Drive to Airtable File Logs
New files in your Google Drive need to reach the right person fast. This setup finds each new file in a chosen folder, shares it with a set email, and records key details in Airtable for tracking. Teams that move documents every day will value the speed and clean audit trail. It runs on a Google Drive event that checks the folder every minute and picks up new files. Next, a Google Drive step grants writer access to the recipient so they get instant access by email. Finally, an Airtable step adds a row with file name, file ID, created time, modified time, and the recipient email. The path is simple and direct, which keeps the flow stable and easy to maintain. You need a folder in Drive and an Airtable base and table ready. Connect Google Drive with OAuth and Airtable with a personal access token, then replace the test email with your own. Expect less manual sharing, fewer mistakes, and clear logs for audits. It fits onboarding packs, client uploads, and vendor handoffs.
7 views
view
n8n
Operations
Automate Google Drive to Notion Meeting Notes
New audio files in a chosen Google Drive folder turn into clear notes in Notion. Great for teams that record meetings, interviews, or training. Get fast summaries without typing. A Drive trigger checks the folder every minute and grabs each new file. The file is downloaded, then sent to OpenAI for speech to text. A second OpenAI step builds a structured JSON summary with a title, key points, and date context. The Notion node creates a fresh page, adds a heading called Summary, and writes the result so the team can read and search it. Setup needs access to Google Drive, an OpenAI API key, and a Notion workspace. Expect note taking time to drop from an hour to a few minutes per recording, with a steady format across pages. Useful for podcast recaps, sales call notes, and internal briefings where speed and consistency matter.
13 views
view
n8n
Operations
Automate Google Drive PII Removal
Protect shared CSV files without extra manual work. The flow watches a Google Drive folder, removes columns with personal data, and saves a clean copy for safe use across teams. Here is how it works. A Google Drive Trigger checks a chosen folder every minute for a new file. The file is downloaded and read by Extract from File to get the headers and rows. OpenAI reviews the table and returns only the column names that look like PII. One node pulls the original file name, another extracts the model result. A Merge node lines up the filename, the data, and the PII list. A Code node removes those columns and rebuilds a clean CSV. The Upload to Drive node saves the scrubbed file in a target folder with a clear name. You will need Google Drive and OpenAI credentials. Expect to cut review time from about 30 minutes per file to around 2 minutes of automated work. Great for sales exports, support logs, HR reports, and vendor handoffs where sensitive fields should not leave your drive. Start with one sample CSV to confirm the flagged columns match your policy. If needed, tweak the OpenAI prompt or the Code node to match your rules.
11 views
view
See More Templates

These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.