​
Overview

Our Pull from Google Sheets cell let’s you pull data from a Google Sheets and automatically save it as a DataFrame.

Once you’ve pulled your data in, you can easily analyze it using Python and AI and build reports and workflows with it.

Important: As of April 2025, we only support publish sheets. We’re currently working on Google authentication to access private links.

​
Configuring your Google Sheets pull

Steps to set up your first pull:

  1. In Smartbook or workflow, add a new cell and select Google Sheet Pull
  2. Copy and past the URL from your Google Sheet in the ##URL## input
  3. Run the cell

Your sheet will automatically be saved as a new Python DataFrame which you can then use in subsequent cells.