build_sheets_service_with_api_key#

langchain_google_community.sheets.utils.build_sheets_service_with_api_key(api_key: str) Resource[source]#

Build a Google Sheets service with API key (read-only access).

Parameters:

api_key (str) – Google API key for authentication.

Returns:

Google Sheets API service with read-only access to public

spreadsheets.

Return type:

Resource

Note

API key authentication only works with public spreadsheets. For private spreadsheets, use OAuth2 credentials instead.