Docs
Apps
Google Sheets Node

Google Sheets Node

Loading node sections...

Overview

The Google Sheets Node is a data synchronization component that automates data extraction and synchronization from Google Spreadsheets. This node supports reading from multiple sheets, handling various data formats including text, numbers, dates, formulas, and cell formatting, enabling regular data synchronization to support data processing and analysis flows.

Node Type Information

TypeDescriptionStatus
Batch TriggerStarts the flow on a schedule or batch event. Ideal for periodic data processing.✅ True
Event TriggerStarts the flow based on external events (e.g., webhook, user interaction).❌ False
ActionExecutes a task or logic as part of the flow (e.g., API call, transformation).❌ False

This node is a Batch Trigger node that automates data extraction and synchronization from Google Spreadsheets on a scheduled basis.

This node is a Batch Trigger node that streamlines data collection from Google Sheets and maintains data consistency through scheduled synchronization for automated data processing flows.

Features

Key Functionalities
  1. Batch Trigger: Automates data extraction and synchronization on a schedule using Cron expressions for regular execution.
  2. Data Format Support: Handles various data types including text, numbers, dates, formulas, and cell formatting.
  3. Multi-Sheet Support: Ability to read from multiple sheets within a workbook with configurable sheet selection.
  4. Synchronization Modes: Supports both incremental (process new/updated rows only) and full-refresh (reprocess all data) modes.
  5. Batch Processing: Configurable batch sizes for efficient data processing of large spreadsheets.
Benefits
  1. Streamlined Data Collection: Automates the process of collecting data from Google Sheets, reducing manual effort and ensuring consistency.
  2. Data Consistency: Maintains data consistency through scheduled synchronization, keeping information current and accurate.
  3. Automated Processing: Enables automated data processing flows by providing structured data output.
  4. Flexible Configuration: Supports multiple sheets and various data formats to accommodate different use cases.
  5. Efficient Processing: Batch processing capabilities for handling large datasets efficiently.

Prerequisites

Before using Google Sheets Node, ensure the following:

  • Google Sheets API Credentials: Valid Google authentication details for accessing the target spreadsheet.
  • Target Spreadsheet URL: The specific Google Sheets URL from which data will be extracted.
  • Cron Expression Knowledge: Understanding of Cron expressions for scheduling flows.
  • Sheet Access Permissions: Proper permissions to access the target spreadsheet and sheets.

Installation

Step 1: Set Up Google Sheets Access

  1. Create Google Sheets API Credentials:

    • Set up Google OAuth credentials for Sheets API access
    • Ensure proper permissions for the target spreadsheet
    • Test spreadsheet accessibility and data permissions
  2. Identify Target Spreadsheet:

    • Copy the Google Sheets URL
    • Verify spreadsheet contains the required data
    • Ensure spreadsheet is accessible with provided credentials

Step 2: Configure Google Sheets Credentials

Use the following format to set up your credentials:

Key NameDescriptionExample Value
Credential NameName to identify this set of credentialsmy-google-sheets-creds
Google OAuthGoogle authentication details for Sheets accessGoogle Sheets OAuth

Step 3: Set Up Lamatic Flow

  1. Create a Custom Flow for Google Sheets:

    • Configure the Google Sheets node
    • Set up scheduling parameters
    • Define synchronization preferences
  2. Use Pre-built Usecases from the Lamatic Studio

Configuration Reference

Batch Trigger Configuration

ParameterDescriptionRequiredExample
NameDisplay name for the nodeGoogle Sheets
CredentialsGoogle authentication details required to connect to the spreadsheetmy-google-sheets-credentials
SpreadsheetThe spreadsheet URL from which data will be extractedhttps://docs.google.com/spreadsheets/d/{spreadsheet-id}
Sheet NamesSpecific sheets to read from (empty for all sheets)Sheet1,Sheet2
Sync ModeSpecify either incremental (process new/updated rows only) or full-refresh (reprocess all data)incremental
Sync ScheduleFrequency for running the flow, specified using a Cron expression0 0 05 1/1 * ? * UTC
Batch SizeNumber of rows to process in each batch200
Names ConversionConvert column names to standardized formatfalse

Low-Code Example

triggerNode:
  nodeId: triggerNode_1
  nodeType: googleSheetsNode
  nodeName: Google Sheets
  values:
    credentials: TestCred
    syncMode: incremental_append
    cronExpression: 0 0 00 1/1 * ? * UTC
    sheetName: AS
    batchSize: '200'
    namesConversion: 'false'
    spreadSheetLink: https://docs.google.com/spreadsheets/d/{your-spreadsheet-id}

Output Schema

  • sheet_name: String identifier for the processed sheet
  • data: Array of objects containing row data with column names as keys
  • metadata: Additional information about the data extraction
    • total_rows: Number of rows processed
    • total_columns: Number of columns in the sheet
    • last_updated: Timestamp of last data update

Output Schema

Batch Trigger Output

  • sheet_name: String identifier for the processed sheet
  • data: Array of objects containing row data
  • metadata: Additional extraction information
    • total_rows: Integer count of processed rows
    • total_columns: Integer count of columns
    • last_updated: ISO timestamp of last update
    • sync_mode: String indicating sync mode used
    • batch_number: Integer indicating current batch (if applicable)

Troubleshooting

Common Issues

ProblemSolution
Invalid CredentialsVerify that the correct Google Sheets API credentials are provided
Spreadsheet Not FoundEnsure the spreadsheet URL is accurate and accessible
Sync Not WorkingCheck the Cron expression for correctness
Data Format IssuesVerify that the data in sheets follows expected format (dates, numbers, etc.)
Sheet Access ErrorsConfirm sheet names match exactly if specified and have proper permissions
Batch Processing IssuesVerify batch size configuration and spreadsheet size compatibility
Column Name IssuesCheck names conversion settings and column header formatting

Debugging

  • Check Lamatic Flow logs for detailed error messages
  • Verify Google Sheets API access permissions
  • Test the spreadsheet URL to ensure it's valid and accessible
  • Confirm sheet names match exactly if specified
  • Validate Cron expression syntax using online Cron validators
  • Monitor data processing logs for specific row or column errors
  • Test with a small spreadsheet before processing large datasets
  • Verify network connectivity and API rate limits
  • Check column header formatting and data type consistency

Additional Resources

Was this page useful?

Questions? We're here to help

Subscribe to updates