Import to Google Sheets
import_to_google_sheetsImport spreadsheets (XLSX, XLS, ODS, CSV, TSV) into Google Sheets from local files or URLs, with automatic conversion and data preservation.
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 |
|---|---|---|---|
| content | No | Text content for text-based formats (CSV, TSV). Use only for short snippets or content already in memory. | |
| file_url | No | Remote URL to fetch the spreadsheet from (http/https). | |
| file_name | Yes | The name for the new Google Sheets spreadsheet (extension will be ignored). | |
| 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. | |
| folder_id | No | The ID of the parent folder. Defaults to 'root'. | root |
| source_format | No | Source format hint ('xlsx', 'xls', 'ods', 'csv', 'tsv'). Auto-detected from file_name extension if not provided. | |
| user_google_email | Yes | The user's Google email address. Required. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |