Step-By-Step Guide: Google Sheets API Integration in SAP CPI via Open Connectors

Walks through connecting Google Sheets to Cloud IntegrationCloud IntegrationserviceBuilds and runs integration flows that process, route and map messages between cloud and on-premise systems, SAP and non-SAP, through prebuilt adapters; available only under an SAP Integration Suite plan.sap official, btp using Open ConnectorsOpen ConnectorsservicePrebuilt connectors to non-SAP cloud applications, each instance called as a harmonised RESTful API, inside SAP Integration Suite.sap official, btp rather than the Google Sheets API directly: enabling it under SAP Integration SuiteSAP Integration SuiteserviceSAP's integration service on BTP: Cloud Integration for orchestration, API Management in front of it, and an MCP gateway that serves a managed API to agents.sap official, btp's Extend Non-SAP Connectivity, creating a Google Sheets V4 instance with OAuth sign-in, retrieving the sheet ID and base URL, and wiring the instance credentials into an iFlow's Request-Reply step. A Groovy script in the iFlow converts the connector's JSON response into XML, and the piece closes by pointing to Open Connectors' Activity log for tracking API calls made through the instance.