Google Sheets

The Google Sheets integration lets your agents read and write data in spreadsheets — pricing tables, customer lists, job tracking, and more. Agents can find spreadsheets, read and update ranges, append rows, and create new spreadsheets.

Prerequisites

• A Google account with Google Sheets. Google Workspace and personal accounts are both supported.
• Admin or Owner role in your Sprigr Teams organisation.

Connecting Google Sheets

1. Open the Integration Hub

   Sign in to team.sprigr.com and click Integrations in the sidebar.

2. Find Google Sheets

   Locate the Google Sheets card and click Connect.

3. Authorise with Google

   A Google sign-in window will appear. Select the account that has access to the spreadsheets you want agents to use and review the requested permissions. Click Allow to grant access.

4. Set a default spreadsheet (optional)

   You can provide a default Spreadsheet ID so agents do not need to specify one each time. Leave it blank to create or choose a spreadsheet during use.

5. Verify the connection

   The Google Sheets card will show a green “Connected” badge.

Note

This integration connects the account you sign in with. Each user connects their own account, so actions are attributed to that user.

Available tools

Tool	Description
sheets_list_spreadsheets	List spreadsheets the connected account can access
sheets_search	Search within a spreadsheet
sheets_read_range	Read values from a range of cells
sheets_update_range	Update values in a range of cells
sheets_append_row	Append a new row of data
sheets_create_spreadsheet	Create a new spreadsheet

Common use cases

• Data lookups — An agent reads a pricing or product table to answer a customer question.
• Logging — An agent appends a row to a tracking sheet each time a job or enquiry comes in.
• Reporting — A workflow writes summary figures into a shared spreadsheet on a schedule.

Troubleshooting

“Access denied” during OAuth Your Google Workspace admin may need to approve Sprigr Teams as a trusted application in the Google Admin console.

Agent cannot find a spreadsheet Confirm the connected account has access to the spreadsheet. Files in Shared Drives require the account to be a member of that Shared Drive.

Next steps

• Google Drive — Browse and manage the files that hold your spreadsheets.
• Integrations Overview — See all available integrations.
• Workflows — Read and write spreadsheet data as steps in automated workflows.