Trying to authenticate Google Sheets programmatically with a service account

Using the Google Authenticator node with a service account, is it possible to pass in the JSON key either from within the workflow itself or through GitHub or GitHub actions? I only see the option to save the key to my local file system, which I don’t want.

Hi @gaceto,

Welcome to the Forum.

In the Google Authentication node, if you click the yellow icon in the section where you select your JSON key file, you’ll see several options for how to provide the file:

  • Local File (as you mentioned) – for selecting a file from your local system
  • Local Space – if the file is available in your KNIME workspace
  • Embedded Data – if you want to embed the JSON content directly into the workflow data area
  • URL – useful if your JSON file is hosted online (e.g., https://...)

Best,
Keerthan

1 Like