Google Sheets Writer

This document outlines the functionality and characteristics of the Google Sheets Writer node, which enables automated data writing to Google Sheets.

​

Node Inputs

​

Sheet Selection (Choose one method)

• Select Sheet: Choose to write to an existing Google Sheet from your Drive
• Use Link: Option to use a direct Google Sheets URL
• Create New: Option to create a new Google Sheet with the same schema

​

Configuration Options

• Sheet Name: Specific worksheet within the Google Sheets file
• Writer Mode: Choose how to write data:
  1. Add New Rows: Appends multiple rows at once with data from connected nodes
  2. Add A Single New Row: Appends one row at the end with data from connected nodes
  3. Write to Column: Adds data to a the specified column based on connected input

​

Data Input

Connect your node outputs directly to the column headers you want to write to. The node will automatically map the data to the appropriate columns based on these connections.

​

Node Output

• Sheet Link: URL to access the Google Sheet where data was written

​

Node Functionality

The Google Sheets Writer node provides automated data writing to Google Sheets with multiple writing modes:

• Add New Rows: Use this mode when you need to write multiple rows of data at once. Perfect for batch operations.
• Add A Single New Row: Choose this when you’re writing one row at a time, like logging individual events or transactions.
• Write to Column: Ideal when you need to add an entire column of data at once, such as adding a new category or metric.

Key features include:

• Direct column mapping through node connections
• Support for new and existing sheets
• Multiple writing modes for different needs
• Secure authentication with Gumloop

​

When To Use

The Google Sheets Writer node is particularly valuable in scenarios requiring automated data writing to spreadsheets. Common use cases include:

• Data Collection: Store form submissions or survey responses
• Logging: Track system events or user activities
• Reporting: Compile automated reports
• Data Organization: Structure data in tabular format

Some specific examples:

• Recording daily transactions
• Logging system metrics
• Storing user feedback
• Creating automated reports

​

Important Considerations:

1. Requires Authentication with Google - Set up in the Credentials page
2. Sheet must have headers in the first row
3. You must have write access to the Google Sheet
4. Column headers in your sheet must match the expected inputs
5. If column headers are changed, you’ll need to refresh the node to see the updates
6. This node only adds new rows - to update existing rows, use the Google Sheets Updater node

In summary, the Google Sheets Writer node streamlines data writing to Google Sheets by adding new rows or columns. For updating existing data, consider using the Google Sheets Updater node instead.