I am running into a challenge.
Run Query on DB, Get results.
Need to download an Excel file (which has prebuilt pivot table based on data tab) from Google drive (template location)
Update the file data tab with the results from query
Upload on the google drive for client folder with modified data and file name.
So avoiding file to be stored locally etc…
Now the challenge is using KNIME Protocol …
I tried saving file locally using Excel Sheet Appender. It works with KNIME protocol but Download does not…
Thank you Scott / Armin for quick response.
I figured another solution. However, once I finally laid out my workflow to download file, update it from query etc, I ran into another problem.
But since it is related to Google Drive, I think I should use another post/question, so it can be properly tagged.