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.

• 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

• 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

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.