Google Sheets

Almost every small business runs on a spreadsheet. Sales for the month, the client list, inventory, the cash-flow tracker — it all lives in a Google Sheet somebody keeps by hand. This connector lets your AI open that sheet, read it, and update it the same way you would.

Ask "how much did we sell this week?" and it reads the sheet and answers with the number — no formulas, no pivot tables. Say "add María García, $450, pending, to the Orders tab" and it writes the row. The spreadsheet you already trust becomes something you can just talk to.

What you can ask

• "In my 'Sales' sheet, add up this month's total and tell me if we beat last month."
• "Add a row to 'Orders': client María García, amount 450, status Pending."
• "Look at the 'Inventory' tab and list the products with fewer than 5 units left."

What you need

Google Sheets uses Google's sign-in (OAuth), so instead of a simple key you connect it once through a Google Cloud project. It sounds technical, but it's a one-time setup and then it just works on every device:

1. Go to console.cloud.google.com/apis/credentials and create a project (or pick one you already have).
2. Enable the Google Sheets API for that project.
3. Create an OAuth client ID (type: Desktop / Web app) and add http://localhost:3000/callback as an authorized redirect URL.
4. Copy the Client ID and Client Secret it gives you and paste them when the Lab asks for GOOGLE_CLIENT_ID and GOOGLE_CLIENT_SECRET.
5. The first time you use it, a browser window opens to let you approve access to your sheets. After that it's silent.

Both values are stored encrypted in your Keychain and synced across your machines — set it up on one computer, it's ready on the rest.

Heads up: the Google Cloud setup is the one genuinely fiddly part. If you get stuck, the in-app support chat can walk you through it step by step.