build_sheets_service#

langchain_google_community.sheets.utils.build_sheets_service( credentials: Credentials | None = None, service_name: str = 'sheets', service_version: str = 'v4', use_domain_wide: bool = False, delegated_user: str | None = None, service_account_file: str | None = None, scopes: List[str] | None = None, ) → Resource[source]#

Build a Google Sheets service with OAuth2 credentials (full access).

Parameters:

credentials (Optional[Credentials]) – OAuth2 credentials. If None, will attempt to load from default locations.
service_name (str) – The Google API service name.
service_version (str) – The Google API service version.
use_domain_wide (bool) – Whether to use domain-wide delegation.
delegated_user (Optional[str]) – User to impersonate for domain-wide delegation.
service_account_file (Optional[str]) – Path to service account file for domain-wide delegation.
scopes (Optional[List[str]]) – List of OAuth2 scopes. Defaults to full access scopes.

Returns:

Google Sheets API service with full access capabilities.

Return type:

Resource