[Google] Fetch Google Sheet
The Fetch Google Sheet block retrieves the contents of a specified range from a Google Spreadsheet and makes that data available for use in a workflow.
Fetch data from a Google Spreadsheet range
The Fetch Google Sheet block retrieves the contents of a specified range from a Google Spreadsheet and makes that data available for use in a workflow. It connects to Google via an OAuth connection and reads from a spreadsheet you identify by its ID, which is found in the spreadsheet's URL. You define the range using A1 notation — for example, "Sheet1!A1:C10" — to target a specific set of cells.
The block accepts a few key inputs: the spreadsheet ID, the cell range, an optional variable name to store the result, a Google OAuth connection ID, and an export format. The export format can be either "csv" for comma-separated values or "json" for structured JSON. The block returns a single output field called "content", which is a string containing the spreadsheet data in whichever format was selected.
This block fits into workflows that need to read structured data from a Google Sheet before processing, transforming, or displaying it. Common scenarios include pulling a list of records for AI processing, reading configuration data, or feeding spreadsheet contents into a report or response generation step.
What you can build
Real-world workflows powered by the [Google] Fetch Google Sheet block.
AI-Powered Data Analysis
Fetch a range of spreadsheet data and pass it to an AI model to generate summaries, identify trends, or answer questions about the dataset.
Dynamic Report Generation
Pull data from a Google Sheet and use it as the source content for automatically generating formatted reports or documents.
CRM Record Lookup
Retrieve customer or lead records stored in a Google Sheet to use as context when generating personalized outreach or support responses.
Workflow Configuration Loading
Read configuration values or lookup tables from a Google Sheet at runtime to control branching logic or parameterize downstream workflow steps.
Inventory or Catalog Sync
Fetch product or inventory data from a spreadsheet to populate AI-generated responses, search results, or customer-facing content.
Scheduled Data Ingestion
Use the block as the first step in a recurring workflow that reads updated spreadsheet data and routes it through processing or notification steps.
Ready to add [Google] Fetch Google Sheet to your workflow?
Get Started FreeCommon questions about [Google] Fetch Google Sheet
What parameters are required to use this block?
The block requires a spreadsheet ID (taken from the spreadsheet's URL), a cell range in A1 notation (e.g. "Sheet1!A1:C10"), an export format (either "csv" or "json"), and a Google OAuth connection ID. The destination variable name is optional.
What does the block return?
The block returns a single output field called "content", which is a string containing the spreadsheet data formatted as either CSV or JSON, depending on the export type you selected.
How do I specify which cells to fetch?
You define the range using A1 notation in the "range" field. For example, "Sheet1!A1:C10" fetches columns A through C, rows 1 through 10, from the sheet named Sheet1.
What is the difference between the csv and json export types?
Setting exportType to "csv" returns the data as comma-separated values in a plain string. Setting it to "json" returns the data as structured JSON. The choice affects how the "content" output is formatted and how downstream blocks should parse it.
What kinds of workflows commonly use this block?
This block is typically used at the start of workflows that need to read structured data from a Google Sheet — such as AI analysis pipelines, report generation flows, record lookups, or any workflow that uses a spreadsheet as a data source.
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] Update Google Sheet
Update a Google Spreadsheet with new data.
Search Google
Search the web using Google and return structured results.
Add [Google] Fetch Google Sheet to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.