Quantum-CLI: A powerful CLI to build, run, and test Quantum Machines.

Execute Your Workflow in a Loop with QuantumDataLytica

QuantumLoop is a powerful enhancement to our no-code data automation platform.

QuantumDataLytica vs Traditional ETL Tools: Accelerate Your Data Integration Without Coding

Traditional Extract, Transform, Load (ETL) tools have long been at the core of data integration practices.

QuantumDataLytica: The No-Code Alternative to Traditional ETL

For years, ETL (Extract, Transform, Load) solutions have been the cornerstone of data integration.

| Marketplace | Google Sheet

Google Sheet

1.0.0 0

Google Sheets Automation Machine enables secure and action-driven interaction with Google Sheets using authentication.

  • Supports reading, appending, updating, deleting rows, clearing ranges, creating sheets, and fetching metadata
  • Flexible row operations using index-based or key-based logic
  • Ideal for workflow automation, reporting, and data synchronization

Free

Main Banner
Machine Overview
  • Machine Name : Google Sheet
  • Title : Google Sheet
  • Short Description :

    Google Sheets Automation Machine enables secure and action-driven interaction with Google Sheets using authentication.

    • Supports reading, appending, updating, deleting rows, clearing ranges, creating sheets, and fetching metadata
    • Flexible row operations using index-based or key-based logic
    • Ideal for workflow automation, reporting, and data synchronization
  • Detail Description :

    Google Sheets Automation Machine is a comprehensive, action-based integration tool designed to automate data operations in Google Sheets.

    The machine interacts with Google Sheets using authentication and dynamically executes operations based on the selected Action parameter. Each action activates only the required inputs, ensuring strict validation and predictable execution.

    Supported actions include:

    • READ – Fetch data from a specified range
    • APPEND – Add new rows to a sheet
    • UPDATE – Modify existing rows using index-based or key-based logic
    • DELETE – Remove rows by row index or by matching key values
    • CLEAR – Clear values from a specified range
    • METADATA – Retrieve spreadsheet and sheet-level metadata
    • CREATESHEET – Create a new sheet within a spreadsheet

    For update and delete operations, the machine supports two operation modes:

    • BYINDEX – Directly target rows using row numbers
    • BYKEY – Target rows dynamically by matching column values

    All responses are normalized and structured, returning operation status, affected row counts, fetched data, or detailed error messages.

    This machine is ideal for automating reporting systems, ETL pipelines, data synchronization jobs, and operational workflows that rely on Google Sheets as a data source or destination.

  • Machine Document : -
Classification
  • Industry : IT
  • Category : Utility
  • Sub Category : -
Compatibility and Dependencies
  • Dependent Machines : -
  • Compatible Machines : -
  • Version : 1.0.0
Specifications
  • Input Specification : Download

    Input Parameters

    • AccessToken
      OAuth 2.0 access token used to authenticate with the Google Sheets API.
    • SpreadsheetId
      Unique identifier of the target Google Spreadsheet.
    • SheetName
      Name of the sheet within the spreadsheet where the operation will be performed.
    • Action
      Defines the Google Sheets operation to execute.
      Supported actions: READ, UPDATE, APPEND, DELETE, CLEAR, METADATA, CREATESHEET.
    • Range
      Cell range in A1 notation (for example: A1:D10).
      Required for: READ, APPEND, CLEAR.
    • Rows
      Row data used for append or update operations, provided as JSON arrays.
      Required for: APPEND, UPDATE.
    • OperationType
      Specifies how rows are targeted during update or delete operations.
      Values: BYINDEX, BYKEY.
    • RowIndices
      Array of row indices used to update or delete rows directly by index.
      Required when: OperationType = BYINDEX.
    • KeyColumn
      Column name used as a matching key for update or delete operations.
      Required when: OperationType = BYKEY.
    • KeyValue
      Value used to match rows in the key column.
      Required when: OperationType = BYKEY.
  • Output Specification : Download

    Output

    The response structure varies based on the selected Action.

    • status
      Indicates whether the operation succeeded or failed.
    • message
      Human-readable description of the operation result.
    • data
      Returned rows for READ operations.
    • affected_rows
      Number of rows appended, updated, deleted, or cleared.
    • sheet_name
      Name of the affected sheet.
    • metadata
      Spreadsheet or sheet-level metadata for METADATA operations.
    • error
      Detailed error information when an operation fails.
Infrastructure Requirement
  • OS Requirement : Linux
  • CPU : 2
  • Cloud : AWS
  • RAM : 4Gi
Usage Stats
  • Total OnBoarded : -
  • Active OnBoarding : -
Parameter Name Type Description
AccessToken Text Box
SpreadsheetId Text Box
SheetName Text Box
Range Text Box
Rows Json
OperationType Dropdown Single Select
RowIndices Json
KeyColumn Text Box
KeyValue Text Box
Action Dropdown Single Select

View Similar

noDataFound

Data Not Found

February 4, 2026

--

View Similar

noDataFound

Data Not Found

Total Reviews
0
Total Ratings
0
Average Rating
0
Star Rating
5
0
4
0
3
0
2
0
1
0

View Similar

noDataFound

Data Not Found

It supports reading data, appending rows, updating rows, deleting rows, clearing ranges, creating sheets, and fetching spreadsheet metadata.

BYINDEX targets rows using their numeric row positions, while BYKEY dynamically targets rows by matching a specified column value.

Ranges must be specified using A1 notation, such as 'A1:D10' or 'A:D'. The sheet name is handled automatically.

Yes. A valid OAuth 2.0 access token is required for all Google Sheets API operations.

Yes. The machine is designed for automation use cases such as ETL pipelines, reporting systems, and data synchronization workflows.

View Similar

noDataFound

Data Not Found

Specifications
  • Input Specification : Download

    Input Parameters

    • AccessToken
      OAuth 2.0 access token used to authenticate with the Google Sheets API.
    • SpreadsheetId
      Unique identifier of the target Google Spreadsheet.
    • SheetName
      Name of the sheet within the spreadsheet where the operation will be performed.
    • Action
      Defines the Google Sheets operation to execute.
      Supported actions: READ, UPDATE, APPEND, DELETE, CLEAR, METADATA, CREATESHEET.
    • Range
      Cell range in A1 notation (for example: A1:D10).
      Required for: READ, APPEND, CLEAR.
    • Rows
      Row data used for append or update operations, provided as JSON arrays.
      Required for: APPEND, UPDATE.
    • OperationType
      Specifies how rows are targeted during update or delete operations.
      Values: BYINDEX, BYKEY.
    • RowIndices
      Array of row indices used to update or delete rows directly by index.
      Required when: OperationType = BYINDEX.
    • KeyColumn
      Column name used as a matching key for update or delete operations.
      Required when: OperationType = BYKEY.
    • KeyValue
      Value used to match rows in the key column.
      Required when: OperationType = BYKEY.
  • Output Specification : Download

    Output

    The response structure varies based on the selected Action.

    • status
      Indicates whether the operation succeeded or failed.
    • message
      Human-readable description of the operation result.
    • data
      Returned rows for READ operations.
    • affected_rows
      Number of rows appended, updated, deleted, or cleared.
    • sheet_name
      Name of the affected sheet.
    • metadata
      Spreadsheet or sheet-level metadata for METADATA operations.
    • error
      Detailed error information when an operation fails.

Updates and Community

Machine Developer

BotCraft Engineers
  • Last Updated
  • February 4, 2026
  • Version
  • 1.0.0
Version History

Statistics

Total Workflows
0
Active Workflows
0
Success Rate
N/A
Last Used in Workflow
N/A

Categories

Utility

Support

Average Response Time 8AM-8PM