RAiN — Rivium AI Network
Back to Help

Google Sheets

Spreadsheet automation and data entry.

What it does

Reads and writes a spreadsheet. This is the most useful integration for most Nigerian businesses, because the 'database' is usually a sheet — and it needs no database credentials at all.

What you need

An account with Google Sheets that you are entitled to authorise, and a moment in a browser. You do not need an API key: connecting sends you to Google Sheets's own sign-in and consent screen, and what comes back is an authorisation rather than a password. RAiN never sees your password, and the authorisation is held by our integration provider on our instructions — see the Integrations & Connected Accounts notice for what that means.

Connecting it

Connections belong to one project. A system built for one client never acts on another client's account, and a package handed to a business runs on theirs — so the same integration is connected again, separately, for each project that needs it.

  1. Open the project and stay on the Visual Editor tab.
  2. Open the Tools & Integrations rail on the right.
  3. Find Google Sheets and press Connect.
  4. Authorise in the window that opens, then come back. The rail will show it as connected.

The consent link is good for about twenty minutes. If you leave it and come back tomorrow, press Connect again rather than reusing the old tab.

To stop it, press Disconnect. That ends this project's access immediately. You can also revoke it from Google Sheets's own security settings, which works even if you never open RAiN again.

What an agent can do with it

32 actions are available once connected, 5 of which delete things and are marked where they appear. They appear in the tool list for this project only — a project that has not connected Google Sheets is never offered them.

Action What it does
google_sheets_add_sheet Add Sheet to Existing Spreadsheet
google_sheets_append_dimension Append Dimension
google_sheets_spreadsheets_values_append Append Values to Spreadsheet
google_sheets_spreadsheets_values_batch_clear Batch Clear Spreadsheet Values ⚠️ deletes things
google_sheets_batch_clear_values_by_data_filter Batch Clear Values By Data Filter ⚠️ deletes things
google_sheets_spreadsheets_values_batch_get_by_data_filter Batch Get Spreadsheet Values by Data Filter
google_sheets_batch_get Batch get spreadsheet
google_sheets_update_values_batch Batch update spreadsheet values
google_sheets_clear_basic_filter Clear Basic Filter
google_sheets_spreadsheets_sheets_copy_to Copy Sheet to Another Spreadsheet
google_sheets_create_google_sheet1 Create a Google Sheet
google_sheets_delete_dimension Delete Dimension (Rows/Columns) ⚠️ deletes things
google_sheets_delete_sheet Delete Sheet ⚠️ deletes things
google_sheets_find_replace Find and Replace in Spreadsheet
… and 18 more, all listed in the rail

Tick the ones an agent may use, or choose one in an Action step to run it exactly as written with no model involved.

A worked example

A distributor keeps stock in a sheet. Each morning an agent reads it, finds items below reorder level, and emails the purchasing officer one list. When stock is received, another step writes the new quantity back.

When it goes wrong

It cannot find the sheet. The spreadsheet id is the long string in the URL between /d/ and /edit, not the file's name.

A written row lands in the wrong place. Ranges are A1 notation — Sheet1!A2:D2. Name the tab explicitly or it writes to the first one.

See also