Step-by-step:
To manage data connections, visit CData Connect AI, create a free account, and go to the dashboard.
Click "Add Connection," choose Google Sheets, log in with your Google credentials, and then click "Save & Test" to verify the connection.
Add the CData MCP server to Claude Desktop using the URL https://mcp.cloud.cdata.com/mcp, then log in with your CData login information.
"Use CData to analyze the Demo Invoice Data sheet and show me all unpaid invoices with company names and amounts, then calculate total outstanding" is an example of a natural language query for your data.
Click "Add Connection," choose Google Sheets, log in with your Google credentials, and then click "Save & Test" to verify the connection.
Add the CData MCP server to Claude Desktop using the URL https://mcp.cloud.cdata.com/mcp, then log in with your CData login information.
"Use CData to analyze the Demo Invoice Data sheet and show me all unpaid invoices with company names and amounts, then calculate total outstanding" is an example of a natural language query for your data.