GSheets

Learn how to automate writing data to Google Sheets using the GSheets node in StackAI. Step-by-step guide with input, configuration, and output details.

What is GSheets?

GSheets is a StackAI integration node that allows you to write data directly to Google Sheets. This node is ideal for automating data entry, updating records, or logging information in your spreadsheets as part of your workflow.

---

How to use it?

To use the GSheets node, you need to configure it with the required spreadsheet and sheet details, and provide the data you want to write. The node will then append or update the specified Google Sheet with your data and return the status of the operation.

---

Example of Usage

Suppose you want to log new user signups into a Google Sheet. You can connect the GSheets node in your StackAI workflow, configure it with your target spreadsheet and sheet, and pass the signup data as input.

---

Available Actions

1. Write to Google Sheet

Description: Appends or updates data in a specified Google Sheet.

Inputs

• Spreadsheet (spreadsheet_id)

  • Required: Yes

  • Type: Select

  • Description: Select the Google Sheet to write to.

• Sheet (sheet_name)

  • Required: Yes

  • Type: String

  • Description: Specify the sheet/tab within the spreadsheet.

• Data (data)

  • Required: Yes

  • Type: Textarea

  • Description: The data to write. Can be a JSON object (preferred for structured data) or plain text.

Example Input:

{
  "spreadsheet_id": "1A2B3C4D5E6F7G8H9I0J",
  "sheet_name": "Signups",
  "data": {
    "Name": "Jane Doe",
    "Email": "[email protected]",
    "Signup Date": "2025-07-07"
  }
}

Configurations

• No additional configurations are required beyond the inputs above.

Outputs

• Status (status)

  • Required: Yes

  • Type: String

  • Description: Indicates if the operation was successful (e.g., "success" or "failure").

• Updated Range (updated_range)

  • Required: Yes

  • Type: String

  • Description: The cell range in the sheet that was updated (e.g., "Signups!A2:C2").

• Message (message)

  • Required: Yes

  • Type: String

  • Description: A message describing the outcome of the operation.

Example Output:

{
  "status": "success",
  "updated_range": "Signups!A2:C2",
  "message": "Data written successfully."
}

---

Summary Table

Input Name	Required	Type	Description
spreadsheet_id	Yes	Select	Google Sheet to write to
sheet_name	Yes	String	Sheet/tab within the spreadsheet
data	Yes	Text	Data to write (JSON or plain text)

Output Name	Required	Type	Description
status	Yes	String	Status of the operation
updated_range	Yes	String	The updated cell range in the spreadsheet
message	Yes	String	Message about the operation

---

Best Practices

• Always use structured JSON for the data input for best results.

• Ensure you have the correct permissions to access and write to the selected Google Sheet.

• Use clear sheet and spreadsheet names to avoid confusion in multi-sheet documents.

---

Automate your data workflows with the GSheets node in StackAI for seamless Google Sheets integration.