I’ve run into an issue while setting up a data source from Google Sheets in Dataddo.
The document is properly shared with the connected Google account, and the authorizer has been updated successfully. However, when trying to create the data source, Dataddo still doesn’t detect the sheet and returns a “Source not found” error message.
Has anyone experienced this before? Could it be related to Google permission delays or something else on the backend?
Yes, this is a fairly common issue, and I’ve recently seen a similar case.
One thing to double-check: Is the document you’re trying to connect in native Google Sheets format, or is it an Excel file (.xlsx) uploaded to Google Drive?
Even if it opens in Sheets automatically, API requires the file to be fully converted into Google Sheets format, not just viewed through the Sheets interface. Files that remain in Excel format won’t be detected by the Dataddo connector (comes from API).
To fix it:
Open the Excel file in Google Sheets.
Go to File > Save as Google Sheets.
Also, make sure the sheet is shared directly with the same Google account connected as the Dataddo authorizer and that it’s not in a Shared Drive unless that’s properly configured.
Let us know if this helps or if you’re still stuck!