Config error connecting to Google Sheet

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is facing a configuration error while trying to connect Airbyte to Google Sheet. The error message indicates that the operation is not supported for the document.


Question

Hi, I have a issues with config to google sheet, I don’t know why airbyte can’t connect to the sheet when I config follow the step of docs.

Internal message: Config error:
Failure type: config_error

    return wrapped(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/googleapiclient/http.py", line 938, in execute
    raise HttpError(resp, content, uri=self.uri)
googleapiclient.errors.HttpError: &lt;HttpError 400 when requesting <https://sheets.googleapis.com/v4/spreadsheets/1PRfGtUXEgc1Dq6HKBuP3q_wtPMRJeYem?includeGridData=false&amp;alt=json> returned "This operation is not supported for this document". Details: "This operation is not supported for this document"&gt;
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
  File "/airbyte/integration_code/main.py", line 8, in &lt;module&gt;
    run()
  File "/airbyte/integration_code/source_google_sheets/run.py", line 15, in run
    launch(source, sys.argv[1:])
  File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/entrypoint.py", line 235, in launch
    for message in source_entrypoint.run(parsed_args):
  File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/entrypoint.py", line 115, in run
    yield from map(AirbyteEntrypoint.airbyte_message_to_string, self.check(source_spec, config))
  File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/entrypoint.py", line 139, in check
    check_result = self.source.check(self.logger, config)
  File "/airbyte/integration_code/source_google_sheets/source.py", line 64, in check
    raise AirbyteTracedException(
airbyte_cdk.utils.traced_exception.AirbyteTracedException: Config error: ```

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1721844454444529) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["config-error", "google-sheet-connector", "http-error", "airbyte-cdk"]
</sub>