Last updated: 4 July 2026

Google Sheets

Google Sheets

Live
Auth: OAuth (Connect Link) · Plans: Free, Starter, Business, Enterprise · Tools: 5 · Category: Marketing & Analytics

Read data from Google Sheets, append rows, and create new spreadsheets through your AI.

Who needs this: Teams using Google Sheets as a lightweight data store or reporting layer who want AI to read and update it.

Example questions once connected

  • Read the supplier list from the Procurement sheet
  • What is in cells A1:D10 of the Budget 2026 spreadsheet?
  • Add a new row to the Sales Log with today's date and KES 45,000
  • Create a new spreadsheet called "June Collections Report"

Step-by-step setup

  1. Open the connector in your Msharti dashboard. Go to Connectors → Google Sheets → Connect. Msharti creates a unique OAuth link. Click Open in Browser.
  2. Log in with your Google account. A consent screen lists what Msharti can access. Review the permissions and click Accept or Continue.
  3. Confirm the connection in Msharti. You will be redirected back to the dashboard. The connector shows Connected with a green dot. Tokens are stored securely and refreshed automatically.

Tool reference

These are the tools the AI can call on this connector. Each tool fires automatically when you ask a relevant question.

read_range() Read cell values from a specified range in a Google Sheet.
Inputs spreadsheet_name or ID, range (e.g. Sheet1!A1:D20)
Try asking "Read the supplier names and KRA PINs from columns A and B of the Compliance sheet"
Returns 14 rows read. Sample: Juhudi Hardware | P051234567X, Simba Corp | P318295670X, TechCo Kenya | A744610021G...
append_row() Append a new row of data to the end of a Google Sheet.
Inputs spreadsheet_name or ID, sheet_name, row_data (array of values)
Try asking "Add today's M-Pesa total to the Collections Log sheet: 12 Jun 2026, KES 412,350"
Returns Row appended to Collections Log, row 183: 12/06/2026 | KES 412,350.
create_sheet() Create a new Google Spreadsheet or add a new sheet tab to an existing spreadsheet.
Inputs title, optional: folder_name, or existing_spreadsheet_id for a new tab
Try asking "Create a spreadsheet called "June 2026 Collections Report""
Returns Spreadsheet created: "June 2026 Collections Report". Shared with your Google account. ID: 1BxiM...

Limits

  • Google Sheets API quota: 300 read requests/minute per project. Msharti batches requests to stay within limits.
  • Sheets with >10MB of data may time out. Use database connectors for large datasets.
  • Formulas are returned as their computed values, not formula text.

Related connectors

GA
Google Analytics
Query site traffic, real-time user counts, and top content from Google Analytics 4.
 NO
Notion
Query Notion databases, create pages, and update content through your AI assistant.
 PG
PostgreSQL
Query your PostgreSQL database in plain English — the AI writes the SQL, you get the answer.
Need help? [email protected] — Nairobi-based, same time zone.