English
Data Connections
Google Sheets

Google Sheets

Import spreadsheet data from Google Sheets into PuppyOne.


Supported content

TypeSupportedNotes
SheetSingle or multiple sheets
FormulasImports computed results
FormattingImports data only
ChartsNot supported

Setup steps

Step 1: Start the import

  1. Open your Project
  2. Click ImportGoogle Sheets

Step 2: Authorize Google

  1. Click Connect Google
  2. Choose your Google account and authorize access
  3. Allow PuppyOne to access Google Sheets

Step 3: Choose the spreadsheet

  1. Paste a Google Sheets URL, or select one from the list
  2. Choose the sheet tab or tabs you want to import
  3. Click Import

Data structure example

Google Sheets is converted into JSON, with the first row used as field names:

Original spreadsheet:

Product NamePriceCategory
Widget Pro99.99Electronics
Gadget X149.99Accessories

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

OptionNotes
Use first row as headerUses the first row as JSON field names
Skip empty rowsIgnores rows with no data
Number formattingAutomatically 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.


Next steps