PhloemDocs
Markdown
Integration

Google Sheets

Cloud spreadsheet application

Category
Files & storage
Runs in
The Phloem cloud — nothing to install

Lets you and Hamming query the tabs of your Google Sheets with SQL.

What Phloem reads

  • Every tab of the spreadsheets you pick. Each tab is one table, and its first row gives the column names.
  • Each tab's columns, listed in Trace

What you need

  • A Google account that can open the spreadsheets
  • Your consent to read-only access to Sheets and Drive

Connect

  1. In the console, open Connectors, choose Add connector, then Google Sheets.
  2. Choose Sign in with Google. Your browser goes through your Phloem account to Google, where you approve read-only access, then back to the console.
  3. On Select Spreadsheets, pick the spreadsheets to connect.
  4. On Save Connection, name the connection and save it.

What Hamming can do

  • Run SQL over the connected tabs: query, sample rows, count rows, list columns

Nothing it does changes your spreadsheets.

Notes

  • A table is named after its tab: lowercase, other characters turned into underscores (Parts List → parts_list). If two picked tabs share a name, each gets its spreadsheet's name in front (bom__parts).
  • Repeated column names get _1, _2, … . An empty header becomes column.
  • Tabs are read at query time, and fetched again only when the spreadsheet has changed.
  • A run field can take its choices from a query over a connected sheet.
  • A query on a deleted tab, or a spreadsheet no longer shared with the account, fails and says so. The connection stays healthy.
  • If Phloem loses access, choose Reconnect on the connector's page and sign in again.

Updated