Skip to content
Analyze Google Sheets data
  • AI Chat
  • Code
  • Report
  • Spinner

    Analyze Google Sheets data

    • Open the "Databases" tab in the sidebar on the left.
    • Click the + icon.
    • Select 'Google Sheets'.
    • Follow the on-screen instructions. In the file picker that appears, select the spreadsheet you want to access.
    • In the SQL cell below, select the Google Sheets file you just connected.
    • Adapt the query to pull data from the right sheet.
    • Click "Run" on the cell menu.

    Your Google Sheets data is now available as a DataFrame df, ready to continue your analysis!

    Unknown integration
    DataFrameavailable as
    df
    variable
    SELECT *
    FROM Sheet1 -- Replace 'Sheet1' with the name of the sheet you want to import from
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    Unknown integration
    DataFrameavailable as
    df1
    variable
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    eazeazeaz

    Want to learn more?

    Check out the dedicated documentation article for in-depth information.

    Unknown integration
    DataFrameavailable as
    df2
    variable
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    Current Type: Bar
    Current X-axis: None
    Current Y-axis: None
    Current Color: None