Your AI-native BI platform home page
Search...
⌘K
Ask AI
Support
Log in
Log in
Search...
Navigation
Workflow cells & nodes
Pull from Google Sheets
Documentation
YouTube
Template Gallery
Security Hub
Getting started
Getting started with Fabi.ai
Connecting to your data
AI, SQL & Python
Data analysis & reporting
Smartbooks
AI Tips
Uploading files
Publishing Smart Reports
Analyst Agent
Scheduling updates
Filters and inputs
Workflow automation
Building AI data workflows
Workflow cells & nodes
Push to Google Sheets
Pull from Google Sheets
Slack integration
Sending emails
AI summaries
AI data processing
Pull from Airtable
Collaboration & organization
Real-time collaboration
Sharing and access control
Organizing your workspace
Integrations & connectors
Databases and warehouses
Other connectors
Advanced features & dev tools
Secret manager
Admin & configuration
User management
Authentication and SSO
On this page
Overview
Configuring your Google Sheets pull
Workflow cells & nodes
Pull from Google Sheets
Pulling data from Google Sheets into Fabi.ai
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.
Configuring your Google Sheets pull
Steps to set up your first pull:
In Smartbook or workflow, add a new cell and select
Google Sheet Pull
Connect your Google Workspace account
Click on
Select File
and search for the sheet you want to pull data from
Run the cell
Note
: We offer two cells to pull from Google Sheets: one for private sheets and one for public sheets.
Your sheet will automatically be saved as a new Python DataFrame which you can then use in subsequent cells.
Push to Google Sheets
Slack integration
Assistant
Responses are generated using AI and may contain mistakes.