🔧 Troubleshootingintermediate4 min read

Troubleshooting Google Sheets Import — Fix Connection Issues

Fix Google Sheets import problems in Unsheet: permission errors, invalid Sheet IDs, empty sheets, and expired tokens. Solutions for every issue.

In this guide

  1. 1Permission Denied
  2. 2Invalid Sheet ID
  3. 3Expired Session

Permission Denied

Error: "Google Sheets API error: The caller does not have permission"

Fix:

  • Make sure the Google Sheet is shared with your Google account (the one you signed into Unsheet with)
  • If the sheet is in someone else's Drive, ask them to share it with you
  • Try signing out of Unsheet and signing back in to refresh your Google permissions

Invalid Sheet ID

Error: "Google Sheets API error: Requested entity was not found"

Fix: Double-check the URL you pasted. The Sheet ID is the long string between /d/ and /edit in the URL:

https://docs.google.com/spreadsheets/d/1ABC123xyz/edit

Expired Session

If your Google Sheets import was working before but now fails, your OAuth token may have expired.

Fix: Sign out of Unsheet and sign back in. This refreshes your Google access token.

Found this useful?

Share it with your team or network.

Frequently Asked Questions

Why can't I import my Google Sheet?
Common causes: you didn't grant Google Sheets permissions during sign-in, the Sheet ID is invalid, the sheet is empty, or your session has expired. Try signing out and back in.

Related Guides

🔗Integrations· 5 min

Import from Google Sheets — Live Sync with Formula Preservation

Connect any Google Sheet to Unsheet. Formulas are preserved and recalculate live. Complete guide to Google Sheets integration with troubleshooting tips.

🚀Getting Started· 2 min

How to Create an Unsheet Account — Sign Up in 30 Seconds

Create your free Unsheet account with Google sign-in. No credit card required. Start converting spreadsheets to web apps immediately.

Ready to kill your spreadsheets?

Upload your first file and see the magic in under 30 seconds.

Get Started Free →