Skip to main content

Write Sheet

The Write Sheet activity writes data to a specific sheet in a Google Sheets file. It accepts input in JSON format and updates or appends data accordingly, enabling seamless data synchronization within your workflows.

Setup​

Google Account​

  • Required: Yes
  • Description: Select or add your connected Google account. Choose from existing credentials or add new ones as needed.

Operation​

  • Required: Yes
  • Description: Choose the operation to perform on the sheet. Available options include:
    • Create Spreadsheet – Create a new Google spreadsheet.
    • Edit Spreadsheet – Modify an existing sheet with one of the following sub-operations:
      • Append Row – Add new rows of data at the end of the sheet.
      • Update Row – Modify data in existing rows based on specified columns.

Configure​

Spreadsheet Name​

  • Required: Conditional
  • Description: When creating a new spreadsheet, specify the name for the new Google Sheets file.

Spreadsheet​

  • Required: Yes (for Edit operations)
  • Description: Select the existing spreadsheet from your connected Google Drive to perform write operations.

Sheet Name​

  • Required: Yes
  • Description: Specify or select the target sheet name within the spreadsheet where data should be written.

Headers​

  • Required: No
  • Description: Define custom header values for the sheet if needed. Headers can also be dynamically generated from the provided data.

Spreadsheet Columns (for Append/Update operations)​

  • Required: No
  • Description: Map each JSON field from your workflow data to the corresponding spreadsheet columns. You can choose between two mapping modes:
    • Manual: Manually assign column names and data values.
    • Dynamic: Automatically detect and map columns from incoming data.

Input Format​

The Write Sheet activity expects JSON input for writing or updating rows. The data should represent one or more rows to insert or modify.

Example Input​

{
  "rows": [
    {
      "Employee ID": "E001",
      "Employee Name": "Alice",
      "Department": "HR"
    },
    {
      "Employee ID": "E002",
      "Employee Name": "Bob",
      "Department": "Engineering"
    }
  ]
}

Example Operations​

Create Spreadsheet​

Creates a new spreadsheet with the provided name and initial sheet structure.

Append Row​

Adds one or more rows of data at the end of the selected sheet.

Update Row​

Updates data within existing rows based on column matches (e.g., updating status or modifying specific entries).

Example Use Cases​

  • Create new spreadsheets automatically for project tracking.
  • Append form submission data into a Google Sheet.
  • Update existing sheet records dynamically from API or payload results.
  • Log workflow execution results directly into a spreadsheet.

Output​

After execution, the Write Sheet activity returns metadata about the write operation, including:

  • Spreadsheet ID
  • Sheet name
  • Number of rows affected
  • Operation type (create, append, or update)

Notes​

  • Ensure your Google credentials have edit access to the selected spreadsheet.
  • For large datasets, consider batching to optimize performance.
  • Combine with Read Sheet for complete data automation (read → process → write flow).