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

  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.

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]

This page as Markdown