Skip to main content

Google Spreadsheet Node

The Write to Google Spreadsheet node allows you to automatically write data, such as CSV-formatted rows, into a Google Spreadsheet. Use this node to append or write rows of data into a specified Google Spreadsheet. It is ideal for automating reporting, data collection, or integration tasks involving Google Sheets.

Google Spreadsheet node​

Inputs​

  • CSV Output: The CSV-formatted data to be written to the spreadsheet. Usually provided by the CSV Builder node.
  • Spreadsheet Name/ID: The name or ID of the target Google Spreadsheet. If not specified, a new spreadsheet may be created.
  • Owner: (Optional) Identifier for the spreadsheet owner or authentication context.

Usage​

Typical workflow:

  1. Start → Text: Generate or collect tabular data.
  2. Text (Output) → CSV Builder (Input): Convert raw text or data into CSV format.
  3. CSV Builder (CSV Output) → Write to Google Spreadsheet (Input): Pass the CSV data to the spreadsheet node.
  4. Write to Google Spreadsheet: Data is written to the specified spreadsheet (e.g., User Registration).

Notes​

  • Ensure the Google Drive account is authenticated and has permission to access the target spreadsheet.
  • If the spreadsheet name does not exist, a new spreadsheet will be created automatically.
  • The node supports both spreadsheet name and spreadsheet ID for flexible targeting.