Keep a live Google Sheet of registrants
Connect a Google Sheet once and Bottega keeps it up to date with every registrant, their attendance, calls and sales.
On this page4 sections
Bottega writes your registrants into a Google Sheet and keeps it current: new sign-ups appear straight away, and attendance, calls and sales follow within a few minutes. Bottega owns the tab it writes and rewrites it on every sync, so rows never drift or double up.
Bottega signs in to Google as one robot account, called a service account, which your sheets are shared with. GOATEDX sets this up once for every client. Until it's done, Settings › Google Sheet says Google isn't set up yet.
Create or pick a Google Cloud project
In the Google Cloud console, pick a project for Bottega or create one (Select a project › New project).
Turn on the Google Sheets API
APIs & Services › Library, search for Google Sheets API and click Enable. Bottega needs nothing else from Google.
Create the service account
IAM & Admin › Service accounts › Create service account. Name it, for example,
bottega-sheets, then click Done. It needs no roles: it only reaches sheets that are shared with it.Create a JSON key
Click the new account's email, open the Keys tab, then Add key › Create new key › JSON › Create. A file downloads. Google can't show it again, so keep it somewhere safe and never email it.
Add it to Bottega
In Vercel, open the Bottega project › Settings › Environment Variables. Add
GOOGLE_SERVICE_ACCOUNT_JSONfor Production and paste the whole contents of the file as the value. Then redeploy (Deployments › latest › Redeploy).
Check that it worked
- Settings › Google Sheet shows an email address ending in
iam.gserviceaccount.comto share your sheet with.
Share the sheet
Open your Google Sheet, click Share and add the address Bottega shows as Editor. Untick Notify people; nobody reads that inbox.
Add your space's code to the sheet's name
Bottega shows a code that starts with
BOTTEGA-. Put it anywhere in the sheet's name in Google Sheets, for example Registrants BOTTEGA-…. It shows the sheet belongs to your team, so nobody else can connect it to their space. Once the sheet is connected you can take the code out again.Paste the link and pick columns
Paste the sheet's link, tick the columns you want (sign-up details, source and ad, attendance per night, call and sale) and choose one tab for everyone or a tab per webinar.
Connect
Bottega fills the sheet straight away. From then on it syncs by itself.
If your space takes application forms, the sheet gets them too, in tabs of their own: who applied, when, the form and webinar, whether Bottega found their sign-up, and one column per question. Team tests are left out. Change it under Applications, below the columns:
| Option | What it does |
|---|---|
| A separate Google Sheet (recommended) | Applications go to a sheet of their own. Share it with Bottega and add your space's code to its name, exactly as for the registrants sheet, then paste its link. The Applications tab in the registrants sheet is emptied then (not deleted). |
| The same sheet as registrations | Applications get a tab in the registrants sheet. Spaces that already had one keep it until you change this. |
| Send applications to this sheet | On by default. Switch it off and nothing is sent; the Applications tabs are emptied, never deleted. |
| One tab for all forms | Every application in one tab, called Applications unless you rename it. |
| One tab per form | A tab named after each form, with only that form's questions. |
| Re-apply the tidy layout | Styles the Applications tabs again: header, widths, wrapping and stripes. It replaces their formatting; the values stay. Other tabs aren't touched. New tabs already get this layout. |
Each form's own page, under Sales › Forms, shows which tab its answers go to.
| What you see | Why | What to do |
|---|---|---|
| Needs attention: no access to the sheet | The sheet isn't shared with Bottega's address, or it was unshared. | Share it again as Editor, then click Sync now. |
| Google isn't set up for Bottega yet | The service account key isn't in Vercel, or the deploy after adding it hasn't run. | Add GOOGLE_SERVICE_ACCOUNT_JSON and redeploy. |
| Google sign-in failed | The key was deleted or disabled in Google Cloud. | Create a new JSON key, replace the value in Vercel and redeploy. |
| Add the code to the sheet's name | The sheet's name doesn't have your space's code yet. | Rename the sheet in Google Sheets to include the code, then click Connect again. |
| Already connected to another space | Each sheet can be connected to one space only. | Use a sheet of your own, or disconnect it from the other space first. |
| Paused | Someone paused the sync. | Click Resume. |
Read next
Something here out of date? Tell us and we'll fix the guide.