Google Sheets
Import spreadsheet data from Google Sheets into PuppyOne.
Supported content
| Type | Supported | Notes |
|---|---|---|
| Sheet | ✅ | Single or multiple sheets |
| Formulas | ✅ | Imports computed results |
| Formatting | ❌ | Imports data only |
| Charts | ❌ | Not supported |
Setup steps
Step 1: Start the import
- Open your Project
- Click Import → Google Sheets
Step 2: Authorize Google
- Click Connect Google
- Choose your Google account and authorize access
- Allow PuppyOne to access Google Sheets
Step 3: Choose the spreadsheet
- Paste a Google Sheets URL, or select one from the list
- Choose the sheet tab or tabs you want to import
- Click Import
Data structure example
Google Sheets is converted into JSON, with the first row used as field names:
Original spreadsheet:
| Product Name | Price | Category |
|---|---|---|
| Widget Pro | 99.99 | Electronics |
| Gadget X | 149.99 | Accessories |
Converted output:
{
"sheet_name": "Product List",
"rows": [
{
"Product Name": "Widget Pro",
"Price": 99.99,
"Category": "Electronics"
},
{
"Product Name": "Gadget X",
"Price": 149.99,
"Category": "Accessories"
}
]
}Configuration options
| Option | Notes |
|---|---|
| Use first row as header | Uses the first row as JSON field names |
| Skip empty rows | Ignores rows with no data |
| Number formatting | Automatically detects numeric types |
FAQ
Will importing a large sheet be slow?
PuppyOne uses the Google Sheets API to read data in batches, so spreadsheets with thousands of rows usually finish in a few seconds.
Can it sync automatically?
Manual sync is required for now. Automatic sync is coming soon.