​

Node Inputs

• Select Sheet
  • Type: GoogleDrive
  • Description: You can choose a Google Sheet from your Drive to write data into.
  • Optional: Yes, under certain conditions.
• Use Link
  • Type: Boolean
  • Description: Decide whether to use a direct link to access a Google Sheets file instead of selecting it from your Drive.
  • Optional: Yes.
• Link
  • Type: String
  • Description: If using a link, provide the full link to the Google Sheets file here.
  • Optional: Yes, under certain conditions.
• Sheet Name
  • Type: String
  • Description: The specific sheet within the Google Sheets file you want to write data into. Defaults to the first sheet if not specified.
  • Optional: Yes.
• Writer Mode
  • Type: Enum
  • Description: Defines how the data will be written into the Google Sheets. This can be adding a new row, writing to a specific column, and more.
  • Optional: Yes.
• Sheet Names
  • Type: String Array
  • Description: A hidden field used to store all sheet names within the selected Google Sheets file.
  • Optional: Yes.
• file_name, file_url
  • Type: String
  • Description: These are hidden fields used to store technical details about the file and are not directly used by the user.

​

Node Output

• Sheet Link
  • Type: String
  • Description: The link to the Google Sheet where data was written.

​

Node Functionality

The Google Sheets Writer node lets users write data directly into a Google Sheet, either by selecting a sheet from their Google Drive or by using a direct link to a sheet. It provides various modes to either add data as a new row, add it to a specific column, or other configurations according to the selected “Writer Mode”. This allows for flexible data entry into sheets for various automated tasks.

​

When To Use

This node is incredibly useful when you need to automate data entry into Google Sheets. Applications can include:

• Automatically logging data from web forms or other sources directly into a spreadsheet.
• Updating records in a Google Sheet based on triggers from other systems or platforms.
• Collating data from multiple sources into a single, easily accessible location in the cloud.
• Any task that requires regular, automated updates to a Google Sheets document, potentially saving hours of manual data entry and ensuring data is always current and can be accessed or shared easily.