Databases & Spreadsheets Tools — Airtable & Google Sheets
What are the Databases & Spreadsheets Tools?
To keep your application data, customer leads, and operation logs structured without hosting separate databases, Langoedge provides native integrations for Airtable and Google Sheets.
These tools enable AI agents to perform structured CRUD (Create, Read, Update, Delete) operations directly on spreadsheets and databases.
[!IMPORTANT]
Prerequisite: Active Account Connection Required
Before your AI agents can read, create, or update records in Airtable or Google Sheets, you must authorize your Airtable account and Google Sheets Drive on the Connect Page.
Without active connection keys established, any graph executions invoking these tools will fail immediately.
1. Airtable Integration Tools
Airtable functions as a relational database wrapper. Connecting Airtable allows your agent to log records, search customer databases, and retrieve schema properties.
| Tool Name | Parameters | Description |
|---|---|---|
airtable_list_bases |
None | Lists all workspace bases available to the user. |
airtable_list_tables |
base_id |
Lists all tables contained in a specific base. |
airtable_list_records |
base_id, table_id |
Lists records in a table. |
airtable_get_record |
base_id, table_id, record_id |
Retrieves detailed fields of a single record. |
airtable_create_single_record |
base_id, table_id, fields |
Adds a new row with specific cell values. |
airtable_update_single_record |
base_id, table_id, record_id, fields |
Updates cell values of an existing record. |
airtable_delete_single_record |
base_id, table_id, record_id |
Deletes a record from the table. |
airtable_search_records |
base_id, table_id, formula |
Filters records using Airtable formula syntax. |
airtable_create_or_update_record |
base_id, table_id, fields, key_fields |
Upserts a record based on key match fields. |
2. Google Sheets Integration Tools
Google Sheets tools are ideal for flat-file data capture, reporting logs, and quick spreadsheet calculations.
| Tool Name | Parameters | Description |
|---|---|---|
gsheets_list_spreadsheets |
None | Lists spreadsheets in the connected Google Drive. |
gsheets_get_spreadsheet_info |
spreadsheet_id |
Retrieves worksheet title and tab sheets metadata. |
gsheets_list_worksheets |
spreadsheet_id |
Lists individual tab sheets. |
gsheets_read_rows |
spreadsheet_id, worksheet_name |
Reads all row rows from a specific worksheet. |
gsheets_get_values |
spreadsheet_id, range |
Retrieves cell values in a specified A1 range. |
gsheets_add_rows |
spreadsheet_id, worksheet_name, rows |
Appends new rows to the sheet. |
gsheets_update_rows |
spreadsheet_id, worksheet_name, rows |
Modifies existing rows inside the sheet. |
gsheets_find_rows |
spreadsheet_id, worksheet_name, query |
Searches for rows matching search criteria. |