Spreadsheet Triggers
Google Sheets
Section titled “Google Sheets”Read from or write to Google Sheets.
| Parameter | Type | Required | Description |
|---|---|---|---|
gcp_credentials_json |
string | ✅ | GCP service account JSON |
spreadsheet_id |
string | ❌ | Spreadsheet ID (from URL) |
spreadsheet_title |
string | ❌ | Spreadsheet title (if no ID) |
parent_folder_id |
string | ❌ | Drive folder ID |
parent_folder_name |
string | ❌ | Drive folder name |
share_with_email |
string | ❌ | Email to share with |
worksheet_name |
string | ❌ | Sheet/tab name (default: Sheet1) |
operation |
string | ✅ | append_row, update_cell, read_cell |
cell |
string | ❌ | Cell address (for update/read) |
data |
any | ❌ | Data for append/update |
Read from or write to local Excel files.
| Parameter | Type | Required | Description |
|---|---|---|---|
file_path |
string | ✅ | Excel file path |
sheet_name |
string | ✅ | Worksheet name |
operation |
string | ✅ | read_cell or write_cell |
cell |
string | ❌ | Cell address |
data |
any | ❌ | Value to write |