Google Sheets Connection and daily update

KNIME Analytics Platform
1

Hey guys :slight_smile: I thinking is there any idea to dowload data from google sheets, “blending” data and then daily update in my google sheets without my participation. e.g. automatically do this things (without open knime) at 7 a.m ?

2

Hi @pjacob,

Yes, that’s possible. Google Sheet Reader/Writer does the IO for you. To run the workflow automatically everyday at 7 AM, you can use the automation feature of KNIME Server or you can run KNIME in Batch mode as a scheduled task.

:blush:

PS Remember to change the credential location of the Google Authentication node to “Node”.

4 Likes
3

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.