Google sheets trigger KNIME workflow

KNIME Analytics Platform
1

I have a KNIME workflow on my machine that will update Google Sheets, but how to allow users trigger the KNIME flow when they want to update the data?

For example, is it possible to use GS macro (KNIME workflow read GS macro and run)? or any workaround?

2

Sounds like a topic for KNIME server
br

3 Likes
3

Assuming that the users in question will be indicating that they need to trigger a knime flow from within Google Sheets (updating a predefined cell for example), you could certainly have a knime workflow scheduled to run periodically on your machine that would read that value and determine if the update is needed.

These polling strategies aren’t the most efficient and they obviously aren’t real-time. Because this approach would be dependent on your machine being on and connected in order to execute, this would also not the most reliable. (This is why folks purchase Knime Server)

If this is not a mission-critical process, this may work well enough for your use case, but be aware of the limitations and pitfalls!

2 Likes
4

Yep, understand. So by KNIME server, the KNIME workflow can be triggered by Google Sheets?

5

Hello @anguslou,

Correct. You need access to REST API. Check out here for more:

Br,
Ivan

2 Likes
7

@ipazin
Do you know by any chance on who could offer me a trial license for KNIME on Azure for testing?
thanks and br

8

Hello @Daniel_Weikert,

you can use this form:

Br,
Ivan

3 Likes
9