- Click
Create your first connectionto initiate a new connection workflow.
- Airbyte asks you to select a source. You can select an existing source or set up a new source. In this example, select
Google Sheets.
-
Add the link to the source spreadsheet as
Spreadsheet Link. -
For authentication use
Service Account Key Authentication, which uses a service account key in JSON format. Toggle from the defaultOAuthoption toService Account Key Authentication, then enter your Google Cloud service account key in JSON format. -
Make sure the service account has the
Viewerrole in your Google Cloud project and that theGoogle Sheets APIis enabled for the project. If your spreadsheet is viewable by anyone with its link, no further action is needed. If not, open the Google Sheet, clickShare, and give the service account email from the JSON key, listed asclient_email, at leastVieweraccess to the spreadsheet.
Note
For more details, refer to setting Google Sheets as Source Connector in Airbyte Open Source
- Click
Set up source. If the configuration is correct, you will see theDefine destinationsection.