# Google Sheets: customer leads and bookings in a spreadsheet

How to connect a Google Sheet so every new customer and every booking is added as a row automatically, and how to check it with a test row.

Updated: November 5, 2026 · https://onswer.ai/docs/en/integrations/google-sheets · Onswer

If you find it easier to keep customers in a spreadsheet, connect Google Sheets. Every new customer who left a phone number, and every booking, reschedule or cancellation the bot made, arrives as a new row. In an empty sheet the column names appear in the first row.

## How to connect

1. Open the bot → "Integrations" → Google Sheets → "Connect".
2. Sign in with Google and allow access.
3. Choose a spreadsheet from the list, paste a link to your own, or press "Create a new spreadsheet".
4. Press "Send a test row" and open the spreadsheet: the row should appear.

## Which columns

The basic customer and booking data, plus a column for each of your [lead fields](/docs/en/bot/lead-fields).

## Tips

- You can share the spreadsheet with managers: they do not need dashboard access.
- If you need deals and a pipeline, use [amoCRM](/docs/en/integrations/amocrm) or [Bitrix24](/docs/en/integrations/bitrix24). A spreadsheet and a CRM can work together.
