Google Sheets
Google Sheets connections give you access to your spreadsheet data.
Source Setup
Etleap supports two authentication methods for Google Sheets connections: Service account sharing and OAuth. Sharing spreadsheets with a dedicated Service Account is the recommended method for all new connections. Google Authorization through OAuth is still supported but is considered a legacy option and is not recommended for new connections.
When creating a new connection, select Share with a Service Account. Etleap creates a dedicated Google Cloud project for your organization and provisions a dedicated Google Service Account for the connection. Share each spreadsheet, or a folder containing your spreadsheets, with the Service Account email address as Viewer. Once the spreadsheets have been shared, Etleap will be able to read their contents.
Prefer using an API? Go here and select Google Sheets under the Body header to create a connection via API.
What Data is Available?
You can extract from any spreadsheet that your account has access to. Every sheet in a spreadsheet will require a dedicated pipeline and all pipelines will be in replace mode. If more than one sheet is selected in the file picker, the pipeline creation wizard will create a pipeline for each sheet.
Key Considerations
Etleap only fetches your 10 most recently viewed spreadsheets when representing sheets in the file picker. If you do not see the spreadsheet you want to create a pipeline for, please visit the spreadsheet in Google Sheets and refresh the Etleap file picker page pressing the button.