Nodes
GoogleSheets

This node allows you to connect to your Google spreadsheets.

Configuration

To change the Client ID and GSheet API Key to connect your own account, you have to:

  1. Create an account on https://console.cloud.google.com/ (opens in a new tab)
  2. Activate Google Sheet API
  3. Define Oauth consent
  4. Add a client to Oauth 2.0
  5. Add the link: https://editor.voltapp.tech/ (opens in a new tab) to the allowd javascripts
  6. This will give you access to your client ID to add into the Client ID attribute
  7. Add an API key and add it to the API key attribute

You will have to specify the Spreadsheet ID in all actions from the GSheet URL, ex: https://docs.google.com/spreadsheets/d/11R2fQeZQVcSzxnGnDeuuU_8e1w7aF5NsoJNHswJyxFI/edit#gid=0 (opens in a new tab)

PositionupdatedAppendcolumns