The Google Sheets Writer node allows you to write data to Google Sheets from your Gumloop flows. It can append new rows, add a single row, or write to specific columns in your spreadsheet.
The Google Sheets Writer node works by mapping your flow’s outputs to spreadsheet columns:
Sheet Connection: Connect to an existing Google Sheet
Column Detection: The node reads the headers in the first row of your selected sheet
Dynamic Inputs: These headers become available as inputs to the node
Data Mapping: Connect outputs from previous nodes to these column inputs
Execution: When the flow runs, data is written to the corresponding columns
For example, if your sheet has headers “Name”, “Email”, and “Date”, these will appear as input options on the node. You can then connect data from other nodes directly to these inputs.
Once connected to a sheet, the node dynamically displays inputs matching the column headers found in the first row of your sheet. Connect your node outputs directly to these column headers to map your data to the appropriate columns in the spreadsheet.
Important: If you modify column headers in your Google Sheet, you must refresh the node’s column data in Gumloop to see these changes.
To refresh column headers:
Click the refresh icon (🔄) next to the Sheet Name dropdown
This will update the available column inputs to match your current Google Sheet structure
You’ll need to reconnect any node outputs to columns that have been renamed
When to refresh your column headers:
After adding new columns to your spreadsheet
After renaming existing columns
After deleting columns that are no longer needed
When new columns in your sheet don’t appear as inputs in the node
Failure to refresh column headers after modifying your spreadsheet structure is a common cause of workflow failures. Always refresh when you make changes to your Google Sheet’s first row.
Under “Show More Options”, you can enable the “Create New Sheet” feature, which creates a copy of the selected sheet’s schema in a new workbook. When enabled, you can configure:
New Sheet Name: Specify a name for your new sheet (optional)
New Sheet Permissions: Set access levels for your new sheet:
Keep Sharing Settings: Maintain your default Google Drive sharing settings
Anyone Can Edit: Allow anyone with the link to edit the sheet
Anyone Can View: Allow anyone with the link to view (but not edit) the sheet
Current Datetime → Web Scraper → Extract Data → Google Sheets WriterSetup:- Writer Mode: Add A Single New Row- Columns: Date, Visits, Conversions, RevenueResult: Daily performance tracking in spreadsheet
CSV Reader → Google Sheets WriterSetup:- Select Sheet: [Template Sheet with proper columns]- Create New Sheet: Yes (under Show More Options)- New Sheet Name: "Q2 Sales Report"- New Sheet Permissions: Anyone Can View- Writer Mode: Add New RowsResult: New shareable report with same schema as template but in a new workbook
Requires Authentication with Google - Set up in the Credentials page
Sheet must have headers in the first row for column mapping to work
You must have write access to the Google Sheet
After modifying column headers in your Google Sheet, click the refresh button (🔄) next to the Sheet Name to update the available column inputs in Gumloop
This node only adds new rows - to update existing rows, use the Google Sheets Updater node
If you’re facing a type mismatch error, toggle the Writer Mode to “Add New Rows” if you’re writing multiple rows
If “Create New Sheet” option is enabled (found under “Show More Options”):
An existing sheet must first be selected (to copy the schema)
Google Drive credentials are required
You must have permission to write to that Google Drive
In summary, the Google Sheets Writer node streamlines data writing to Google Sheets by adding new rows or columns, with additional options to create new sheets with specific permissions. For updating existing data, consider using the Google Sheets Updater node instead.