Spreadsheets
Google Sheets and GoTombola
One row per contribution in a Google sheet per campaign, kept up to date as it happens.
Built and being tested on our side, not open to organizers yet: this sheet already says what it will send.
Google Sheets
The sync sheet
What goes to Google Sheets
- The sale's number
- The kind of event and its date
- The campaign: code, name and currency
- The amount paid
- The ticket part: count and amount
- The donation part
- Payment fees
- The payment provider and method
- The tax receipt: number and issuer
- Cancellations and refunds
- Buyers' details, if you tick them
Never sent
- Your organization's number
- Direction
- From GoTombola to Google Sheets
- Frequency
- In real time
- Countries
- Belgium · France · Ireland · Switzerland
- Built by
- GoTombola
- Live since
- In testing, not open yet
- Version
- 1.1.0
- Offer
- Included
Known limits
- Refunds of PayPal and SumUp are not tracked yet.
- Fees may only be known after the payment: the column stays empty until then.
About this integration
GoTombola creates one sheet per campaign in the Google Drive of the person who connects the account (we recommend a shared account of the organisation) and adds, just below the header, one row per paid sale: ticket part, donation part, fees once known, payment method, date and id. A cancellation or a refund rewrites the row (« Status » column, refund) and keeps the payment date. Contact columns are filled only if you tick them.
FAQ
What exactly does Google Sheets receive?
Everything the sync sheet lists, and nothing else. What is marked « Never sent » does not leave GoTombola through this integration.
How do I connect Google Sheets?
From the console, under your organization's « Integrations », once the integration is available. The organization's owner and admins can connect and disconnect it.
Launch your raffle, plug in your tools afterwards
Create your campaign in a few minutes; your integrations are set up in the console, organization by organization.