Insert Smart Chips
insert_smart_chipsDestructiveIdempotent
Insert Google Workspace Smart Chips (Drive files, folders, or people) into any Google Sheets cell or range. Specify URLs or emails to enrich your spreadsheet with clickable references.
Instructions
Inserts Google Workspace Smart Chips (Drive files/folders or People) into a Google Sheet cell or range.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| chips | Yes | Smart chip(s) to insert: - A single URL or email string for a single cell (e.g., "https://drive.google.com/drive/folders/123", "user@example.com"). - A list of URLs or emails for a single cell (multiple chips) or across cells (e.g., ["https://...", "https://..."]). - A 2D list of URLs/emails matching a grid range. For a single-row or single-column range, each inner list is instead the chips for one cell (e.g., [["a@x.com", "b@x.com"]] puts both chips in the first cell of "A1:C1"). - A dict or list of dicts with explicit properties (e.g., {"type": "drive", "uri": "..."}, {"type": "person", "email": "..."}). - A JSON-encoded string representing any of the above formats. | |
| chip_type | No | Explicit chip type if passing raw strings: "drive" (default for URLs/IDs) or "person" (default for emails). | |
| range_name | Yes | Target cell or range (e.g., "Sheet1!F3", "Sheet1!F3:F23", "F3"). Required. | |
| spreadsheet_id | Yes | The ID of the spreadsheet. Required. | |
| user_google_email | Yes | The user's Google email address. Required. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |