airbox.fyi

Google Sheets

Append rows to a Google Sheet from email

No coding required. If you've never used an API key before, follow the walkthrough below step by step. Developers can skip to Quick reference at the bottom

Part 1 — Get your API key

  1. Dashboard → Connections → + Google Sheets
  2. Click Connect Google Sheets and sign in with Google
  3. Approve access to Google Sheets on the consent screen
  4. You're returned to the dashboard with the connection added

Open Google Sheets key page →

Part 2 — Add your connection in Airbox

  1. Dashboard → Connections → + Google Sheets → Connect with Google
  2. Paste the spreadsheet ID or URL the AI should write to (optional default)
  3. Optionally set a default tab (e.g. Expenses)
  4. Google Sheets is a tool, not the LLM — keep an LLM provider as the inbox default
  5. Open inbox routing (gear icon) and enable Google Sheets under attached tools
  6. Save

Open the dashboard in a new tab if you want to follow along

Part 3 — Route your inbox

Your Airbox address does not use a connection until you attach one:

  1. Select an LLM provider as inbox default
  2. Enable Google Sheets under attached tools, and set a default spreadsheet/tab
  3. Save

Try it — send an email

Subject: Fwd: Receipt from Acme

(* @sheets append a row with the vendor, date, and total *)

New to commands? See copy-paste examples and the syntax cheat sheet

Quick reference

Dashboard typegsheets
Email targets@sheets, @sheets/Expenses
Default model—
Keyshttps://console.cloud.google.com/

What you get

  • Append rows
  • Read a range
  • Add a tab
  • Default spreadsheet & tab in config

Notes

  • Connects with Google OAuth — no token to paste. Access is refreshed automatically.
  • Point the connection at a spreadsheet by ID or URL; the AI appends rows to it. Airbox never creates a new spreadsheet — set the default (or use @sheets) so rows always land in the one you chose.
  • Works with batch inboxes: every email buffered during the period is processed at the scheduled send time, so each receipt or invoice lands as its own row in the same sheet — plus one summary email per period.

Related