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:
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
- Open the bot → "Integrations" → Google Sheets → "Connect".
- Sign in with Google and allow access.
- Choose a spreadsheet from the list, paste a link to your own, or press "Create a new spreadsheet".
- 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.
Tips
- You can share the spreadsheet with managers: they do not need dashboard access.
- If you need deals and a pipeline, use amoCRM or Bitrix24. A spreadsheet and a CRM can work together.
Did not find the answer?
Write to support: we usually answer within a working day. Write on WhatsApp · [email protected]