Import to Google Sheets
import_to_google_sheetsImport spreadsheet files (XLSX, XLS, ODS, CSV, TSV) into Google Sheets by providing a file path, URL, or content. Automatic conversion preserves rows, columns, and sheets.
Instructions
Imports a spreadsheet (XLSX, XLS, ODS, CSV, TSV) into Google Sheets format with automatic conversion.
Google Drive automatically converts the source spreadsheet to native Google Sheets format, preserving rows, columns, sheets, and values. For batch operations, prefer file_path for files on disk so callers do not need to load full file contents into their context.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | The user's Google email address. Required. | |
| file_name | Yes | The name for the new Google Sheets spreadsheet (extension will be ignored). | |
| content | No | Text content for text-based formats (CSV, TSV). Use only for short snippets or content already in memory. | |
| file_path | No | Local file path or file:// URL for any supported format (XLSX, XLS, ODS, CSV, TSV). Appropriate for larger files than content, but file_path may still load the file into memory or perform non-streaming reads. Avoid very large files that could exceed memory or time limits; use streaming/chunked uploads or an alternative API for huge files. | |
| file_url | No | Remote URL to fetch the spreadsheet from (http/https). | |
| source_format | No | Source format hint ('xlsx', 'xls', 'ods', 'csv', 'tsv'). Auto-detected from file_name extension if not provided. | |
| folder_id | No | The ID of the parent folder. Defaults to 'root'. | root |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |