Q: How to get sources from Sheet2 of Google Sheet?
i integrated source from google sheet.
In the google sheet, i want columnsAi to extract and analyze data from Sheet2 (not Sheet1). How to do that?
ShawnCao
Aug 20, 2025A: Unfortunately Columns only read the first Sheet upon a new connection.
You will need to move Sheet2 to the first tab to make it accessible. At some point, we will fix this issue by introducing sheet selection in connection step.
ibestrikerPLUS
Verified purchaser
Thanks Shawn. It solved that issue at the moment. But I want to add more sheets into 1 Google sheet because I want to have more "formula" to calculate and placed in different sheets (tabs). If you can add features where we can choose multiple or/and selected sheets for visualization and analysis, it would be great and helpful.
Though we plan to add feature to allow user choose which sheet to target in a Gsheet connection, it is unlikely we will allow multiple sheets into one data source connection, because it is headache when multiple sheets do not have a consistent data schema to enable reasonable data analysis.