I use a system in my personal that saves the logs in a file “historico.db” I’m backing up this file with google drive What I want to do is through the N8N download the file from google drive and use the data in a spreadsheet, is there any way to do this?
yes that should be possible. Your workflow could use nodes like
- Google Drive node to download the file
- Move Binary Data node to load your file into json data for additional processing
- Spreadsheet File node to write data to a spreadsheet file
If you end up using Move Binary Data node make sure to use settings like
Set all Datato load all file content into a json field
You can also browse our workflow templates for fitting scenarios like