Google Sheets Connection Issues
Fix problems with your Google Drive connection and sheet access.
"Google Drive setup needed" message
If you see a message on your dashboard saying Google Drive setup is needed, it means LeadToSheet doesn’t have permission to create or access a Google Sheet on your behalf. This can happen if:
- You signed up without granting Google Drive permissions
- Your Google Drive permissions were revoked
- The original Google account connection expired
To fix this, you’ll need to reconnect your Google account with the required permissions.
Reconnecting your Google account
You can reconnect Google Drive directly from the dashboard without logging out:
- 1
Open your site Overview
From the sidebar, choose the site that's affected and stay on the Overview page.
- 2
Click "Connect Google Drive"
In the "Action needed: Connect your Google Drive" alert, click the "Connect Google Drive" button. You'll be redirected to Google to authorise.
- 3
Check the Google Drive permission box
On the Google consent screen, make sure to tick the Google Drive checkbox before clicking Allow — without it, LeadToSheet still can’t create your spreadsheet.
- 4
Verify the connection
After Google sends you back, the alert should disappear and the Google Sheets card should show your spreadsheet link.
Tip
LeadToSheet only requests permission to access files it creates. It never reads or modifies your other Google Drive files.
Note
If the dashboard alert doesn’t appear, signing out and back in via "Continue with Google" on the login page is an equivalent fallback — both flows trigger the same Google consent screen.
Sheet was deleted or moved
If your Google Sheet was accidentally deleted or moved to the trash:
- 1
Check your Google Drive trash
Open Google Drive, go to Trash, and look for a spreadsheet with your business name (e.g., "Acme Corp - Form Submissions").
- 2
Restore the sheet
Right-click the file and select "Restore". It will be moved back to its original location.
- 3
Retry failed submissions
Go back to LeadToSheet and retry any failed submissions. They should now sync successfully.
Note
If the sheet was permanently deleted (emptied from trash), contact us at support@leadtosheet.com. We can help create a new sheet and your existing submission data is still safely stored in LeadToSheet.
Permission errors
If you’re seeing permission-related errors, it usually means the Google OAuth token has expired or been revoked. This can happen if:
- You changed your Google account password
- You revoked LeadToSheet’s access in your Google Account settings
- Your organization’s admin restricted third-party app access
- The token expired naturally (rare, but can happen with long periods of inactivity)
The fix is the same: log out and sign back in with Google to refresh the connection.