Skip to main content

Read Sheet

The Read Sheet activity retrieves the contents of a specific sheet from a Google Sheets file and outputs the data as a JSON object. This allows for easy integration, lookup, and manipulation of spreadsheet data directly within your workflows.

Setup​

Google Account​

  • Required: Yes
  • Description: Select or add your connected Google account. Choose from existing credentials or add new ones for integration.

Operation​

  • Required: Yes
  • Description: Choose the type of read operation you want to perform. Available options include:
    • Read Sheet – Retrieve all data from a selected range in a sheet.
    • Lookup Sheet Rows (up to 500 rows) – Search and fetch rows matching a specific condition.
    • Custom API – Use advanced parameters for custom data fetching.

Configure​

Spreadsheet​

  • Required: Yes
  • Description: Select the spreadsheet from your connected Google Drive.

Sheet​

  • Required: Yes
  • Description: Choose the specific sheet within the selected spreadsheet to read data from.

Range​

  • Required: No
  • Description: Specify a range in A1 notation (e.g., A1:D10) to limit the data being read. If left empty, the full sheet data will be retrieved.

Lookup Column (For Lookup Operation)​

  • Required: Yes
  • Description: Define the column to search within when using the Lookup Sheet Rows operation.

Lookup Value (For Lookup Operation)​

  • Required: Yes
  • Description: Enter the value to search for in the lookup column.

Output​

The Read Sheet activity returns data as a JSON object, allowing the output to be used in subsequent workflow steps such as APIs, conditionals, or custom logic.

Example Output:

{
  "values": [
    ["Name", "Email", "Role"],
    ["Alice", "[email protected]", "Manager"],
    ["Bob", "[email protected]", "Engineer"]
  ]
}

Example Use Cases​

  • Import data from Google Sheets into workflows for processing or reporting.
  • Use lookup operations to fetch specific rows based on unique keys or IDs.
  • Combine with other activities (like API calls or Mappers) to automate spreadsheet-based workflows.
  • Retrieve configuration data or dynamic content from Sheets for conditional execution.