Google Sheets Integration with IBM App Connect
Here in this blog, we will learn about Google Sheets Integration with IBM App Connect
The IBM App Connect Enterprise (ACE) v12.0.10.0 has introduced the Google Sheet Request node, providing seamless integration with Google Sheet. This node allows users to perform various actions on objects such as spreadsheets, worksheets, and rows within Google Sheet. This blog will guide you through the configuration process and highlight the key features and functionalities of the Google Sheet Request node.
The Google Sheets Request node enables users to connect to Google Sheet and execute actions on different objects, including creating or retrieving rows, spreadsheets, and worksheets. It’s important to note that operations performed by this node are synchronous and non-transactional. Even if a message flow encounters an error and rolls back after the node, the operation on the Google Sheet data source will still complete.
Configuration:
- Create a Flow: Begin by creating a message flow in the IBM App Connect Enterprise Toolkit that includes the Google Sheets Request node, an HTTP Request node, a Compute node, and an HTTP Response node.
- Launch Connector Discovery: Now, click on the “Launch Connector Discovery” property of the Google Sheets Request node. Afterward, provide the Google Sheets policy project that you have created, which includes the security credential name you have already created and saved in an external directory vault.
- Connect to Google Sheets: Enter your Google Sheets account information, including client ID, client secret, access token, and refresh token. Retrieve these values from the Google API Dashboard at https://console.developers.google.com/apis/dashboard .
- Configure Properties: Set up connector properties and specify the type of operation you want to perform on the Google Sheets application. This way, the Connector Discovery wizard generates request and response schema files based on the operation, simplifying data transformation and validation.
- Validation Settings: Check your node’s property settings, adjust validation settings, and save your message flow.
- Deploy & Test: Deploy the application and test the integration with Google Sheet.
Conclusion
The Google Sheet Request node in ACE v12.0.10.0 enables us to perform various operations in the Google Sheets application, including creating or retrieving rows, creating or retrieving spreadsheets, and creating worksheets. Users can execute these operations by integrating IBM App Connect with the Google Sheet application without disclosing the original password, thanks to the use of OAuth 2.0.
