Google and other integrations
Open Integrations in the chat sidebar to connect the services the agent can use for you. Each one runs on your own account at that service, so the agent can reach only what you can reach. Your company's ERP (ERPNext) is connected the same way, with your own ERP user.
Google has four separate connections, so you give each one only the permission it needs:
| Connection | What the agent can do |
|---|---|
| Google Drive | Read your files, including Docs, Slides and Sheets (drive_read). |
| Gmail | Search and read mail, and save drafts. It never sends mail. |
| Google Calendar | List events, and create or change them. |
| Google Sheets & Docs | Write into a spreadsheet (sheet_write) or a document (doc_write). |
Reading a Sheet or Doc needs Google Drive. Writing needs Google Sheets & Docs. Connect both when you want the agent to read a sheet and then fill it in.
If you ask for something that needs a service you have not connected yet, the agent does not give up. It shows a Connect card
in the chat (connect_integration). Press Connect, allow access at Google, and you come back to the same chat, where the agent
continues your request by itself. If you cancel at Google or the connection fails, the card says Could not connect, and
pressing Connect starts again.
Writing into a Sheet or a Doc
Ask in plain words, for example:
Add these two shipments to the dispatch sheet at this link.
The agent reads the file first, so it matches the columns or the place, and then writes straight away, without asking you to approve. Google keeps every version of your file, so a write is never a loss.
The answer tells you exactly what changed:
- Sheet, update: the tab and range, the rows and columns written, how many cells really changed, and up to 20 of them as
A12: "old" -> "new". Append adds rows after the last row of the table and says where. Clear empties a range. - Doc: how many characters were added at the end, or how many times a piece of text was replaced.
- One call writes at most 500 rows and 50 columns. Numbers and dates are read as if you had typed them, and formulas are kept.
- Without a tab name, the agent uses the tab from the link's
#gid=, or else the first tab.
When the API cannot do it: your own Chrome
Sometimes Hydra's Google connection cannot edit a sheet (for example, the connected account has view access only). If your Chrome
with the Hydra extension is online, the agent can ask Chrome to do it (sheet_fill_browser). A card appears in the chat and on the
extension: you read what it will do, which sites it touches and how long it takes, then press Approve. Hydra opens the sheet in
one tab, types the cells as you would, reads the block before and after, closes the tab and shows what changed. It uses your
screen for that time. Google's Version history can undo it.
The same mechanism is general: with browser_act the agent can run a short list of steps (open a page, click, type, read, take a
screenshot) on the sites it names, after you approve. It never types into or reads password or payment fields. See
Hydra for Chrome and Firefox.
Undo
Every answer names the file's revision from just before the change. To go back:
- Ask Hydra to undo. It puts the old cells back, removes the rows it appended, or removes the text it added. After a replace in a Doc, an undo may also change text that already matched the new words; Hydra says so.
- Or open the file in Google and use File > Version history to restore an earlier version yourself.
The ERP
With ERPNext connected, the agent can list, read and report on documents as your ERP user. A write (a new document, a change, a submit) always waits for your Approve in the chat, and some writes also go to a manager first. See Roles and approvals.
If something goes wrong
- "Connect Google Sheets & Docs in Integrations": you have not connected it yet, or Google asked you to connect again. Open Integrations, connect Google Sheets & Docs, and ask again.
- "The connected Google account ... cannot edit this spreadsheet": the account you connected has view access only. Ask the file's owner for edit access, or connect an account that can edit it.
- "No tab named ...": the answer lists the real tab names; ask again with one of them.