Chapter 125. Google Sheets Component Available as of Camel version 2.23 The Google Sheets component provides access to Google Sheets via the Google Sheets Web APIs . Google Sheets uses the OAuth 2.0 protocol for authenticating a Google account and authorizing access to user data. Before you can use this component, you will need to create an account and generate OAuth credentials . Credentials comprise of a clientId, clientSecret, and a refreshToken. A handy resource for generating a long-lived refreshToken is the OAuth playground . Maven users will need to add the following dependency to their pom.xml for this component: 125.1. URI Format The GoogleSheets Component uses the following URI format: Endpoint prefix can be one of: spreadsheets data 125.2. GoogleSheetsComponent The Google Sheets component supports 3 options, which are listed below. Name Description Default Type configuration (common) To use the shared configuration GoogleSheets Configuration clientFactory (advanced) To use the GoogleSheetsClientFactory as factory for creating the client. Will by default use BatchGoogleSheetsClientFactory GoogleSheetsClient Factory resolveProperty Placeholders (advanced) Whether the component should resolve property placeholders on itself when starting. Only properties which are of String type can use property placeholders. true boolean The Google Sheets endpoint is configured using URI syntax: with the following path and query parameters: 125.2.1. Path Parameters (2 parameters): Name Description Default Type apiName Required What kind of operation to perform GoogleSheetsApiName methodName Required What sub operation to use for the selected operation String 125.2.2. Query Parameters (10 parameters): Name Description Default Type accessToken (common) OAuth 2 access token. This typically expires after an hour so refreshToken is recommended for long term usage. String applicationName (common) Google Sheets application name. Example would be camel-google-sheets/1.0 String clientId (common) Client ID of the sheets application String clientSecret (common) Client secret of the sheets application String inBody (common) Sets the name of a parameter to be passed in the exchange In Body String refreshToken (common) OAuth 2 refresh token. Using this, the Google Sheets component can obtain a new accessToken whenever the current one expires - a necessity if the application is long-lived. String bridgeErrorHandler (consumer) Allows for bridging the consumer to the Camel routing Error Handler, which mean any exceptions occurred while the consumer is trying to pickup incoming messages, or the likes, will now be processed as a message and handled by the routing Error Handler. By default the consumer will use the org.apache.camel.spi.ExceptionHandler to deal with exceptions, that will be logged at WARN or ERROR level and ignored. false boolean exceptionHandler (consumer) To let the consumer use a custom ExceptionHandler. Notice if the option bridgeErrorHandler is enabled then this option is not in use. By default the consumer will deal with exceptions, that will be logged at WARN or ERROR level and ignored. ExceptionHandler exchangePattern (consumer) Sets the exchange pattern when the consumer creates an exchange. ExchangePattern synchronous (advanced) Sets whether synchronous processing should be strictly used, or Camel is allowed to use asynchronous processing (if supported). false boolean 125.3. Spring Boot Auto-Configuration The component supports 10 options, which are listed below. Name Description Default Type camel.component.google-sheets.client-factory To use the GoogleSheetsClientFactory as factory for creating the client. Will by default use BatchGoogleSheetsClientFactory. The option is a org.apache.camel.component.google.sheets.GoogleSheetsClientFactory type. String camel.component.google-sheets.configuration.access-token OAuth 2 access token. This typically expires after an hour so refreshToken is recommended for long term usage. String camel.component.google-sheets.configuration.api-name What kind of operation to perform GoogleSheetsApiName camel.component.google-sheets.configuration.application-name Google Sheets application name. Example would be camel-google-sheets/1.0 String camel.component.google-sheets.configuration.client-id Client ID of the sheets application String camel.component.google-sheets.configuration.client-secret Client secret of the sheets application String camel.component.google-sheets.configuration.method-name What sub operation to use for the selected operation String camel.component.google-sheets.configuration.refresh-token OAuth 2 refresh token. Using this, the Google Sheets component can obtain a new accessToken whenever the current one expires - a necessity if the application is long-lived. String camel.component.google-sheets.enabled Whether to enable auto configuration of the google-sheets component. This is enabled by default. Boolean camel.component.google-sheets.resolve-property-placeholders Whether the component should resolve property placeholders on itself when starting. Only properties which are of String type can use property placeholders. true Boolean 125.4. Producer Endpoints Producer endpoints can use endpoint prefixes followed by endpoint names and associated options described . A shorthand alias can be used for some endpoints. The endpoint URI MUST contain a prefix. Endpoint options that are not mandatory are denoted by []. When there are no mandatory options for an endpoint, one of the set of [] options MUST be provided. Producer endpoints can also use a special option inBody that in turn should contain the name of the endpoint option whose value will be contained in the Camel Exchange In message. Any of the endpoint options can be provided in either the endpoint URI, or dynamically in a message header. The message header name must be of the format CamelGoogleSheets.<option> . Note that the inBody option overrides message header, i.e. the endpoint option inBody=option would override a CamelGoogleSheets.option header. For more information on the endpoints and options see API documentation at: https://developers.google.com/sheets/api/reference/rest/ 125.5. Consumer Endpoints Any of the producer endpoints can be used as a consumer endpoint. Consumer endpoints can use Scheduled Poll Consumer Options with a consumer. prefix to schedule endpoint invocation. Consumer endpoints that return an array or collection will generate one exchange per element, and their routes will be executed once for each exchange. 125.6. Message Headers Any URI option can be provided in a message header for producer endpoints with a CamelGoogleSheets. prefix. 125.7. Message Body All result message bodies utilize objects provided by the underlying APIs used by the GoogleSheetsComponent. Producer endpoints can specify the option name for incoming message body in the inBody endpoint URI parameter. For endpoints that return an array or collection, a consumer endpoint will map every element to distinct messages.

Commands:
<dependency> <groupId>org.apache.camel</groupId> <artifactId>camel-google-sheets</artifactId> <version>2.23.0</version> </dependency>
google-sheets://endpoint-prefix/endpoint?[options]
google-sheets:apiName/methodName