Google Sheets

Google Sheets is the workhorse data connector: if your business runs on a spreadsheet (leads, orders, price lists, rosters), this connector lets your workflows read it and write to it. This guide covers connecting an account, choosing the spreadsheet, and what the agent can do once it is wired in.

Connect, Step by Step

1. In Faberiq, open Workflow, then the Connectors tab.
2. Find Google Sheets in the catalogue and click it.
3. Name the connection and continue.
4. On the Configure step, click Continue. A Google sign-in popup opens. Sign in with the account that owns (or can edit) the spreadsheet you want to use.
5. Google shows the requested permissions: managing your spreadsheets and read-only access to your Drive file list (the spreadsheets and drive.readonly scopes; the Drive scope is only used to list spreadsheets so you can pick one). Approve.
6. The popup closes and the dialog moves on to spreadsheet selection: pick a spreadsheet from the list of files in your Drive. Faberiq then loads the spreadsheet's tabs, and fills a Default range for you based on the first tab (for example Sheet1!A1:Z2000). Adjust the range if your data lives elsewhere.
7. Click Save. Selecting a spreadsheet is required to complete setup.
8. On the Skills step, review what this connection may do (see below) and finish.

Each Google Sheets connector is bound to one spreadsheet. To work with several spreadsheets, create several connectors, one per file, with clear names.

What the Agent and Workflows Can Do

The connector exposes two families of skills:

Simple read and write

• Read records (data.query): read the rows in the default range, returned with the header row separated out.
• Write records (data.sync): append rows to the default range.

These are the skills used by workflow data nodes.

Full spreadsheet control (sheets.ops and friends)

For agents that need to work a spreadsheet like a person would:

Skill	What it does
sheets.list_tabs	List every tab with its row and column counts.
sheets.read_headers	Read row 1 of a tab to discover its columns.
sheets.read	Read values from a tab, optionally limited to an A1 range such as A1:D20.
sheets.append	Add rows to the bottom of a tab, aligned to the existing headers.
sheets.write	Overwrite specific cells or a range with a grid of values.
sheets.create_tab	Add a new tab.
sheets.delete_tab	Delete a tab and its contents.
sheets.clear	Empty the cells in a range without deleting the tab.
sheets.delete_column	Delete a column by letter or by header name.
sheets.ops	The all-in-one operation the agent can drive with a single tool.

On the Skills step you can disable anything you consider too dangerous for automation; many operators turn off sheets.delete_tab and sheets.delete_column and keep the rest.

Using It in a Workflow

In the workflow designer, the connector appears in three shapes:

• Google Sheets Query: a trigger or read node that pulls rows into the workflow (backed by data.query).
• Google Sheets Write: a step that writes workflow output into the sheet (backed by data.sync).
• Google Sheets tool on an agent: hands the agent the skill family above so it can decide at runtime what to read or write.

When you drop a Sheets node onto the canvas, you bind it to one of your Google Sheets connectors; the node then operates on that connector's spreadsheet and default range. You can also enable it as an agent tool from Workflow Settings. See Workflows and Agents.

Common Uses

• Lead log: the channel bot appends a row (name, email, request, date) for every qualified lead.
• Order or intake capture: structured rows instead of chat transcripts for downstream teams.
• Reference data the agent reads: price lists, service menus, opening hours; the agent reads the tab before answering.
• Reports: a scheduled workflow writes daily summary rows.

tip

Keep row 1 of every tab as a clean header row. The append skill aligns incoming rows to the headers, so tidy headers are what make agent-written data land in the right columns.

Troubleshooting

Symptom	Fix
"Select a Google spreadsheet to complete setup"	The connector authenticated but no file was chosen. Open the connector and pick a spreadsheet, then save.
The spreadsheet list will not load	Re-run the Google sign-in from the Configure step; access may have been revoked under the Google account's third-party access settings.
Reads return nothing	Check the default range: if your data starts on another tab or outside the range, widen it (for example Leads!A1:Z5000).
Writes land in the wrong columns	Fix the header row on the target tab, or pass explicit ranges via sheets.write.

Related Pages

• Connectors overview
• Collections: Faberiq's own structured datasets, an alternative when the data does not need to live in Google
• Workflows and Agents