---
title: Google sheets
description: Read data from a specified Google Sheet within your workflow.
category: Google Services
tags: [google sheets, spreadsheet, data read, integration]
---

# Google sheets

## Description

The **Google Sheets** activity allows you to retrieve structured data from a specific worksheet inside a selected Google Sheet file.

This activity is useful for reading tabular data, configurations, or external inputs from Google Sheets as part of a workflow. You can specify the file and sheet name to extract only the necessary content.

Use this activity to:

- Import tabular data from Google Sheets for processing
- Read dynamic configurations maintained by users
- Integrate sheet-based inputs into automated workflows

> **Use case**:  
> A marketing team maintains campaign data in a Google Sheet. This activity reads the latest campaign metrics into the workflow and passes it to `Data Transfors` for analysis and reporting.

## Input

_Not Applicable_

## Output

| Output Type | Format | Description                         |
| ----------- | ------ | ----------------------------------- |
| **Data**    | Table  | Parsed data from the selected sheet |

## Configuration Fields

| Field Name     | Description                                                                 |
| -------------- | --------------------------------------------------------------------------- |
| **Connection** | Select the Google Sheets connection to authenticate and access your files.  |
| **File Name**  | Choose the file from your connected account. _(Single file selection only)_ |
| **Sheet Name** | (Optional) Specify the sheet to read from. Defaults to the first sheet.     |

## Sample Input

_Not applicable_

## Sample Configuration

| Field           | Value                      |
| --------------- | -------------------------- |
| `connection.id` | `google-sheets-connection` |
| `fileName`      | `Campaign_Metrics_Q2_2024` |
| `sheetName`     | `April_Data`               |

## Sample Output

| Campaign | Clicks | Impressions | Cost   |
| -------- | ------ | ----------- | ------ |
| A1       | 320    | 10,000      | $45.00 |
| B2       | 280    | 8,500       | $38.00 |
| C3       | 410    | 12,000      | $50.00 |