Connect Google Sheets to a tool built with Claude or ChatGPT (2026)
Your tool built with Claude needs to read or fill in a Google Sheet the team already knows. The usual path goes through a service account and a credentials file, which you should never paste into the code or the conversation. On while, it stays in while. Here is how.
By Aloïs Oddon, co-founder of Nextmap. Facts checked on November 18, 2026.
Many small business tools start as a Google Sheet, and many need to keep reading it: the client list, the stock, the schedule. A tool built with Claude or ChatGPT can do it, as long as it has a Google credential. The usual path goes through a service account and its credentials file, a file you should paste neither into the code nor into the conversation.
On while, that file stays in while. The tool calls Google without ever holding it, and your AI never sees it.
The short version. Create a service account in the Google Cloud console and its credentials file, share the sheet with the service account’s address, ask your AI to connect Google, then paste the file into while through the link it gives you.
Connect Google Sheets to your tool, in five steps
The whole thing takes a few minutes, and you do not have to write a line of code.
- Create a service account. In the Google Cloud console, open IAM & Admin, then Service Accounts, and create one in your project1. Also enable the Google Sheets API in that project.
- Create its credentials file. In the service account, open the Keys tab, add a new one, and choose the JSON format. Google only gives you this file once1.
- Share the sheet with the service account. Open the sheet, click Share, and add the service account’s address, as a viewer or an editor, as you would for a person. Uncheck the notification: the service account has no inbox1.
- Ask your AI to connect Google. It declares the connection in while and gives you a link.
- Paste the file into while. You open the link, paste the file’s content and confirm. Neither your AI nor the tool’s code sees it.
You, to your AI: Connect our Google Sheet of orders to this tool, so it reads today’s orders and adds the ones the team enters.

What while does on each call
The tool calls Google through while, without a credential. while signs each call with the service account file, and logs it. For the first seven days, reads go through and help learn what the tool calls. A write, like adding a row, goes through as soon as you approve its rule. After that, an unexpected call is refused, and your AI is notified.
Sharing the sheet and while’s rules add up: the tool only reads the sheets shared with the service account, and only writes what you allowed. The same mechanism works for any API in connect an API without a credential in the code.
What while brings around it
- Your colleagues use the tool with a while account for up to 3 people, or, on the Pro plan, with their email account, Google or Microsoft. See keep a tool for your colleagues.
- Connected software: one on the Free plan, and 25 on the Pro plan.
- The tool’s data is backed up every day, and your tools are hosted in France by Nextmap.
If the sheet has become the tool itself, read replace a shared Excel file with a tool built with AI instead, and for other connections, Notion or HubSpot.
Try it with your tool
Give this message to your AI, then ask it to connect your sheet. The trial is free, with no sign-up, and your tool has its address in 3 minutes.
Read while.sh/agents and help me get started with while.
Sources
- Google Workspace, Create access credentials, accessed November 18, 2026