The Google Sheets Writer node sends data from your workflow into a Google Sheet. It supports writing full rows, single rows, or column-specific data, and can create new sheets with defined permissions.
Purpose: Write structured data to Google Sheets
Usage: As an output step in MergePoint workflows
Authentication Required: Yes (Google account)
The node writes to your sheet by mapping workflow outputs to spreadsheet columns based on the headers found in Row 1.
Sheet Connection: Select a Google Sheet (via Drive picker or URL)
Header Detection: The node reads headers from the first row
Input Mapping: Headers appear as input fields in the node
Data Binding: Connect outputs from previous steps to matching columns
Execution: Data is written to the appropriate cells based on Writer Mode
Example: If the sheet headers are Name, Email, Date, these will appear as fields to map in the node.
Choose how to connect:
Select Sheet: Pick from your Google Drive
Use Link: Paste a direct URL to the sheet
Specify how data should be written:
Mode | Behavior |
|---|---|
Add New Rows | Appends one or more rows at the bottom of the sheet |
Add A Single Row | Appends exactly one row at the bottom |
Write to Column | Writes values vertically in one specified column |
Use "Add New Rows" for logging, "Single Row" for individual submissions, and "Write to Column" for column-level updates.
After connecting to a sheet, the node reads Row 1 and exposes its headers as mappable input fields. Connect outputs from other steps directly to these fields.
If your sheet structure changes, click the refresh icon (🔄) next to Sheet Name to reload column inputs.
When to refresh:
After renaming column headers
After adding/removing columns
When inputs are missing or incorrect
Failure to refresh after a schema change may result in errors or unmapped data.
Sheet Link: URL of the destination Google Sheet
Under Show More Options, enable "Create New Sheet" to duplicate the schema of a selected sheet into a new workbook.
Configurable Fields:
New Sheet Name (optional)
New Sheet Permissions:
Keep Sharing Settings
Anyone Can Edit
Anyone Can View
Private (owner only)
Enable dynamic parameters from the Configure Inputs panel. Useful fields include:
New Sheet Name
Sheet URL
Writer Mode
Sheet Name
This allows you to drive sheet behavior dynamically based on earlier steps.
Flow: Scraper → Extract → Google Sheets Writer
Mode: Add New Rows
Mapped Fields: Company, Rating, Feedback
Flow: Datetime → Scraper → Extract → Google Sheets Writer
Mode: Add A Single Row
Mapped Fields: Date, Visits, Revenue
Flow: CSV Reader → Google Sheets Writer
Options: Enable Create New Sheet
New Name: "Q2 Sales Report"
Permissions: Anyone Can View
Authentication: Must be configured via the Credentials page
Header Requirement: The target sheet must have headers in Row 1
Access: You must have write access to the sheet or Drive
Schema Matching: Refresh headers if structure changes
Only Writes: This node cannot update existing rows — use Google Sheets Updater for that
Type Mismatches: For multiple rows, ensure Writer Mode is set to "Add New Rows"
