[Google] Update Google Sheet
The Update Google Sheet block writes data to a Google Spreadsheet, allowing workflows to push new information into a sheet programmatically.
Write CSV data to a Google Spreadsheet
The Update Google Sheet block writes data to a Google Spreadsheet, allowing workflows to push new information into a sheet programmatically. It accepts CSV-formatted text as its primary input and applies that data to a specified spreadsheet using one of three write modes: appending rows to the bottom of existing data, overwriting all current sheet content, or writing to a specific cell range defined in A1 notation. The target spreadsheet is identified by its spreadsheet ID, and a Google OAuth connection ID is used to authenticate the request.
The block's operationType field controls exactly how the data lands in the sheet. Choosing addToBottom preserves existing rows and appends new ones below them. The overwrite mode replaces all existing data in the sheet. The range mode targets a precise cell range, such as B2:D10, giving workflows fine-grained control over where data is placed. All data passed to the block must be formatted as CSV in the text field.
Once the write operation completes, the block returns a spreadsheetUrl string containing the URL of the updated Google Spreadsheet. This block fits into workflows that collect, transform, or aggregate data and need to persist results in a Google Sheet — for example, logging AI-generated outputs, recording form submissions, or syncing processed records from another data source.
What you can build
Real-world workflows powered by the [Google] Update Google Sheet block.
Log AI Outputs to Sheet
Append AI-generated responses or analysis results as new rows in a Google Sheet for record-keeping and review.
Sync Form Submission Data
Write incoming form responses into a Google Spreadsheet each time a user submits data through an AI-powered app.
Overwrite Report Data
Replace an existing sheet's contents with a freshly generated report on a scheduled or triggered basis.
Update a Specific Cell Range
Write processed data into a defined cell range within a sheet, such as updating a summary table without touching surrounding content.
Track Pipeline Records
Append new CRM or sales pipeline entries to a shared Google Sheet as they are processed through a workflow.
Export Database Query Results
Push the CSV output of a database query or data transformation step directly into a Google Spreadsheet for further analysis.
Ready to add [Google] Update Google Sheet to your workflow?
Get Started FreeCommon questions about [Google] Update Google Sheet
What are the required parameters for this block?
The block requires a text field containing CSV-formatted data, a spreadsheetId identifying the target Google Spreadsheet, an operationType specifying how the data is written (addToBottom, overwrite, or range), and a connectionId for Google OAuth authentication. When using the range operationType, a range value in A1 notation is also required to specify the target cells.
What does the block return after a successful update?
The block outputs a single field, spreadsheetUrl, which is a string containing the URL of the updated Google Spreadsheet.
What is the difference between the three operationType options?
addToBottom appends new rows below any existing data in the sheet. overwrite replaces all existing sheet data with the new CSV content. range writes the CSV data to a specific cell range defined in A1 notation, such as A1:C5, leaving content outside that range untouched.
What format does the input data need to be in?
Data must be provided as CSV (comma-separated values) in the text field. The block does not accept other formats such as JSON or plain text tables.
What kinds of workflows commonly use this block?
This block is commonly used in workflows that collect or generate data and need to persist it in a Google Sheet — such as logging AI outputs, recording form submissions, syncing processed records from external sources, or periodically refreshing report data in a shared spreadsheet.
Related capabilities
[Google] Create Google Doc
Create a new Google Document and optionally populate it with content.
[Google] Update Google Doc
Update the contents of an existing Google Document.
[Google] Fetch Google Doc
Fetch the contents of an existing Google Document.
[Google] Create Google Sheet
Create a new Google Spreadsheet and populate it with CSV data.
[Google] Fetch Google Sheet
Fetch contents of a Google Spreadsheet range.
Search Google
Search the web using Google and return structured results.
Add [Google] Update Google Sheet to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.