In the top-right corner, click + New source. Go to the Airbyte UI and in the left navigation bar, click Sources. The connector only finds the spreadsheet you want to replicate it does not access any of your other files in Google Drive. To set up Google Sheets as a source in Airbyte Open Source:Įnable the Google Cloud Platform APIs for your personal or organization account. For Row Batch Size, define the number of records you want the Google API to fetch at a time.To get the link, go to the Google spreadsheet you want to sync, click Share in the top right corner, and click Copy Link. For Spreadsheet Link, enter the link to the Google spreadsheet.If not, give your Service account access to your spreadsheet. If your spreadsheet is viewable by anyone with its link, no further action is needed. Make sure the Service Account has the Project Viewer permission. To authenticate your Google account via Service Account Key Authentication, enter your Google Cloud service account key in JSON format.(Recommended) To authenticate your Google account via OAuth, click Sign in with Google and complete the authentication workflow.Authenticate your Google account via OAuth or Service Account Key Authentication.Enter a name for the Google Sheets connector.On the Set up the source page, select Google Sheets from the Source type dropdown.In the left navigation bar, click Sources.To set up Google Sheets as a source in Airbyte Cloud: Set up Google Sheets as a source in Airbyte For Airbyte Cloud To replicate multiple spreadsheets, set up multiple Google Sheets source connectors in your Airbyte instance. The Google Sheets source connector pulls data from a single Google Sheets spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |