<@U04SE163WC8>, with google-sheets connector, I wa...
# replication-ask-ai
v
@kapa.ai, with google-sheets connector, I want to ingest only one tab of a spreadsheet, let’s say its named as Tab_A. However, I cannot create a new source because it google-sheets connector is failing due to other unexpected or unsupported format of other tabs I don’t even want to ingest. How can I solve this?
k
Based on the information from the knowledge sources, it seems that the Google Sheets connector in Airbyte treats each tab as a separate stream. However, it does not currently support the ability to select specific tabs or ranges within a Google Sheets source. This means that if there are unsupported formats or configurations in any of the tabs, it could cause the connection or sync to fail, even if you're not interested in those specific tabs. A workaround suggested in a [forum post](https://discuss.airbyte.io/t/2600) is to move the data you want to sync to a separate Google Sheets file. This way, the connector won't be affected by the other tabs in the original spreadsheet. However, this might not be the most convenient solution, especially if the data in the spreadsheet is updated frequently. As of now, there's no official solution to this issue. You might want to follow the discussion on the [Airbyte Github](https://github.com/airbytehq/airbyte/issues/17100) for updates on this issue. Remember to ensure that your Google Sheets API is enabled and that your service account has the necessary permissions to access the spreadsheet. You can refer to the [Google Sheets source connector documentation](https://docs.airbyte.com/integrations/sources/google-sheets#google-sheets) for more details on setting up the connector.