ComfyUI-XAV-Google-Sheets Pipes Spreadsheet Text to AI Workflows

ComfyUI-XAV-Google-Sheets is a new custom node package for ComfyUI that lets you pull text directly from a public Google Sheet. It loads a shared spreadsheet as a data table and extracts a single cell’s value by specifying a row and column number. This makes it simple to feed external text data into a local AI workflow without writing any scripts.
XAV-Games, the developer behind the project, created these nodes to eliminate the need for manual copy‑paste or custom code when working with spreadsheet data. The tool handles the CSV download automatically and outputs the sheet as a matrix of text rows, ready for prompt generation or bulk processing. Released under the MIT license, it’s free to use and adapt in both personal and commercial projects.
How the nodes load and extract data
- Downloads any public Google Sheet as a matrix.
- Selects a cell by zero‑based row and column index.
- Handles multiple sheets using custom GID input.
- Passes data between nodes via a TABLE type.
- Requires no API keys or authentication.
- Synchronous download suited for smaller datasets.
The tool is built for ComfyUI users who manage prompt lists, product catalogs, or any bulk text in spreadsheets. By removing the need to copy and paste data manually, it speeds up batch image generation workflows significantly. Small agencies and privacy‑conscious creators running everything locally will appreciate how easily it connects a trusted sheet to their image pipeline.
What’s under the hood and what’s missing
The developer notes that only publicly shared spreadsheets are supported; private sheets would need OAuth authentication, which could be added if users request it. Because downloading is synchronous, very large sheets might briefly pause the queue, so it’s best for moderate‑sized data. The custom TABLE data type used between the loader and selector nodes is not directly compatible with other ComfyUI components unless you route it through a Python script node for further processing.
"Convenient and fast nodes for loading and retrieving values from Google Sheets." — Source: GitHub