Import from Google Sheets — Live Sync with Formula Preservation

You can use either the full URL or just the Sheet ID:

• Full URL: https://docs.google.com/spreadsheets/d/1ABC123xyz/edit
• Sheet ID only: 1ABC123xyz (the part between /d/ and /edit)

Unsheet automatically extracts the Sheet ID from full URLs.

1. Go to your Dashboard
2. Find the "Connect Google Sheet" section below the file upload area
3. Paste your Google Sheets URL or ID
4. Click "Import Sheet"
5. Unsheet fetches the full spreadsheet data via the Sheets API v4
6. The AI generates your app schema, and you're redirected to your new Unsheet app

When Unsheet fetches your Google Sheet, it reads the userEnteredValue for each cell — not the computed result. This means:

• =SUM(A1:A10) is preserved as a formula string
• =B2*C2 is preserved, not just the computed value
• Even complex formulas like =IF(B2>100, "High", "Low") are kept

These formulas are then loaded into HyperFormula in your browser, where they evaluate and recalculate in real-time.

The Google Sheets import uses the OAuth access token from your sign-in. Make sure you granted the Google Sheets (read) scope when you signed in.

If you're having trouble, try signing out and signing back in — the permission prompt will appear again.