Download a report and copy to google sheets


I want to download a report from my ERP (it has a fixed link) and I want to paste it a google sheet.

Is it feasible with make?


How easy and if it is possible honestly depends on the authentication needed for downloading. Likely, you can download the report using the HTTP module and upload it. Depending on the file type you could probably loop through the rows and update the google sheet but if you want to replace the whole file it might be possible to do it with less calls using the Google Drive “Update a File” module (although I’ve never tried this).

1 Like