Google Sheets Node Documentation
The Google Sheets node in Lamatic automates data extraction and synchronization from Google Spreadsheets. It supports reading from multiple sheets, handling various data formats, and enables regular data synchronization to support data processing and analysis workflows.
Features
✅ Key Functionalities
- Batch Trigger: Automates data extraction and synchronization on a schedule.
- Data Format Support: Handles text, numbers, dates, formulas, and cell formatting.
- Multi-Sheet Support: Ability to read from multiple sheets within a workbook.
✅ Benefits
- Streamlines data collection from Google Sheets.
- Maintains data consistency through scheduled synchronization.
- Enables automated data processing workflows.
Prerequisites
Before setting up the Google Sheets node, ensure you have the following:
- Google Sheets API credentials for accessing the spreadsheet.
- The target spreadsheet URL from Google Sheets.
- An understanding of Cron expressions for scheduling flows.
Installation
Step 1: Set Up Lamatic Flow
- Create a Custom Flow:
- Follow the webhook integration guide (opens in a new tab).
- Configure webhooks as trigger events.
- Define custom actions for incoming webhook data.
- Use Pre-built Templates:
- Start with a webhook template (opens in a new tab).
- Customize the template as needed.
Step 2: Configure Node in Lamatic
- Add the Google Sheets node to your flow.
- Provide necessary credentials and spreadsheet details.
- Schedule the flow using a Cron expression for regular execution.
Configuration Reference
Batch Trigger: Scheduled
| Parameter | Description | Required | Example |
|---|---|---|---|
| Name | Display name for the node. | ✅ | Google Sheets |
| Credentials | Google authentication details required to connect to the spreadsheet. | ✅ | my-google-sheets-credentials |
| Spreadsheet | The spreadsheet URL from which data will be extracted. | ✅ | https://docs.google.com/spreadsheets/d/{spreadsheet-id} |
| Sheet Names | Specific sheets to read from (empty for all sheets). | ❌ | Sheet1,Sheet2 |
| Sync Mode | Specify either incremental (process new/updated rows only) or full-refresh (reprocess all data). | ✅ | incremental |
| Sync Schedule | Frequency for running the flow, specified using a Cron expression. | ✅ | 0 0 05 1/1 * ? * UTC |
Low-Code Example
{
"triggerNode": {
"nodeId": "triggerNode_1",
"nodeType": "googleSheetsNode",
"nodeName": "Google Sheets",
"values": {
"syncMode": "incremental_append",
"spreadsheetUrl": "https://docs.google.com/spreadsheets/d/{your-spreadsheet-id}",
"sheetNames": "Sheet1,Sheet2",
"credentials": "{your-google-sheets-credentials}",
"cronExpression": "0 0 05 1/1 * ? * UTC"
}
}
}Troubleshooting
Common Issues
| Problem | Solution |
|---|---|
| Invalid Credentials | Verify that the correct Google Sheets API credentials are provided. |
| Spreadsheet Not Found | Ensure the spreadsheet URL is accurate and accessible. |
| Sync Not Working | Check the Cron expression for correctness. |
| Data Format Issues | Verify that the data in sheets follows expected format (dates, numbers, etc.). |
Debugging
- Check Lamatic Flow logs for error details.
- Verify Google Sheets API access permissions.
- Test the spreadsheet URL to ensure it's valid and accessible.
- Confirm sheet names match exactly if specified.