Skip to content
Nappai Documentation

Google Sheet Writer

⚠️ DEPRECATION WARNING

This component is deprecated and will be removed in a future version of Nappai.
Please migrate to the recommended alternative components.

How it Works

The Google Sheet Writer component lets you send data from Nappai into a Google Sheet.
First, you must set up a Google Sheets API credential in Nappai’s credentials section.
When you add the component to a workflow, choose that credential in the Credential field.
The component then authenticates with Google, opens the selected spreadsheet (or creates a new one if none is chosen), and writes the data you provide.
You can either append new rows to an existing sheet or overwrite the sheet entirely.
If you create a new sheet, you can give it a custom title.

Inputs

  • Input Data: Data to be written.
  • Select Google Sheet (optional): Select an existing Google Sheet to update, or leave blank to create a new one.
  • New Sheet Title (if creating): Title for the new sheet (only used when creating a new sheet).
  • Sheet Name: Name of the sheet to write to (optional).
  • Write Mode: Choose whether to append data or overwrite the sheet.
  • Tool Name: The name of the tool that will be used when this component is connected as a tool.
  • Tool Description: A detailed description of what this tool does.
  • Tools arguments metadata: Defines the arguments metadata for the tools.

Outputs

  • Result: The data that was written, returned as a Data object.
  • Tool: A Tool object that can be used by agents when the component is connected as a tool.

Usage Example

  1. Add the component to your workflow.
  2. Configure the credential: In the component’s settings, select the Google Sheets API credential you created earlier.
  3. Choose a spreadsheet: Either pick an existing sheet from the file selector or leave it blank to create a new one.
  4. Set the sheet name (if you want to write to a specific tab).
  5. Select write mode:
    • append – adds new rows below the existing data.
    • overwrite – replaces all existing data in the sheet.
  6. Connect the data source: Drag the output of a previous component (e.g., a data extraction step) into the Input Data field.
  7. Run the workflow. The component will write the data to Google Sheets and output the same data for downstream steps.
  • Google Sheet Reader – Pull data from a Google Sheet into Nappai.
  • Google Sheet Writer (new version) – The updated, non‑legacy component that replaces this one.

Tips and Best Practices

  • Use unique sheet names to avoid accidental overwrites.
  • Prefer append mode when you want to keep a history of data.
  • Check sheet permissions: The Google account used by the credential must have edit access to the spreadsheet.
  • Validate data format before writing to avoid errors (e.g., ensure columns match the sheet layout).

Security Considerations

  • Store your Google Sheets API credentials securely in Nappai’s credential manager.
  • The component handles OAuth tokens internally; no sensitive data is exposed in the workflow.
  • If you share the workflow, make sure the credential is not shared with users who should not have access to the target spreadsheets.