[Google] Create Google Sheet
The Create Google Sheet block creates a new Google Spreadsheet and fills it with data provided in CSV format.
Create and populate a new Google Spreadsheet from CSV
The Create Google Sheet block creates a new Google Spreadsheet and fills it with data provided in CSV format. You supply a title for the spreadsheet and the CSV text you want to populate it with, and the block handles the creation and data entry in a single step. It also accepts an optional Google OAuth connection ID to authenticate with the appropriate Google account.
The block returns a single output — the URL of the newly created spreadsheet — which can be stored in a variable you specify via the destinationVar field. This makes it straightforward to pass the spreadsheet link to downstream blocks, such as sending it in an email or logging it elsewhere in the workflow.
This block fits into workflows that generate structured data and need to export or share it as a spreadsheet. Common scenarios include report generation pipelines, data collection summaries, AI-generated analysis outputs, and any workflow where tabular results need to be handed off to collaborators via Google Sheets.
What you can build
Real-world workflows powered by the [Google] Create Google Sheet block.
Automated Report Generation
At the end of a data processing workflow, generate a formatted CSV summary and create a new Google Sheet to share with stakeholders.
AI Analysis Export
After an AI block produces structured analysis results, convert the output to CSV and store it in a new Google Spreadsheet for review.
Form Submission Logging
Capture form or survey responses collected through a workflow and write them into a new Google Sheet for record-keeping.
Sales Data Handoff
Export CRM or pipeline data aggregated during a workflow into a new spreadsheet and pass the URL to a sales team notification.
Scheduled Data Snapshots
Run a recurring workflow that pulls data from an external source, formats it as CSV, and creates a timestamped Google Sheet each cycle.
Team Collaboration Sheets
Generate a task list or project plan in CSV format during a workflow and create a Google Sheet that team members can access immediately via the returned URL.
Ready to add [Google] Create Google Sheet to your workflow?
Get Started FreeCommon questions about [Google] Create Google Sheet
What parameters are required to use this block?
The block requires two parameters: a title string for the new spreadsheet and a text string containing the CSV data to populate it with. The connectionId (Google OAuth connection ID) and destinationVar (variable to store the resulting URL) are optional fields.
What does the block return?
The block outputs a single field, spreadsheetUrl, which is the URL of the newly created Google Spreadsheet. You can capture this value in a workflow variable by specifying the destinationVar field.
How does the block authenticate with Google?
Authentication is handled via a Google OAuth connection, referenced by the optional connectionId field. This connects the block to the appropriate Google account that will own the created spreadsheet.
What format does the input data need to be in?
The data must be provided as CSV text in the text field. The block uses this CSV content to populate the new spreadsheet at creation time.
What kinds of workflows commonly use this block?
This block is commonly used in report generation pipelines, AI output export workflows, data aggregation summaries, and any workflow that produces tabular data and needs to make it accessible via a shareable Google Sheets link.
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] Update Google Sheet
Update a Google Spreadsheet with new 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] Create Google Sheet to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.