Raffle Operations can connect a manager's Google account to create and update editable winner sheets.
Connection
From the Winners tab:
- Select Connect Google.
- Complete the Google authorization flow.
- Return to Raffle Operations.
- Select a project with finalized winners.
The UI shows which Google account is connected.
Community sheets
Each manager’s Google Sheet contains their own raffles for one project and community.
For each community, the manager can:
- Create Google Sheet
- Sync Sheet
- Open Sheet
The sheet records the export mode used for the latest sync, such as:
- Discord + X + Wallet
- wallets only
The page also shows the latest sync status and time. If a sheet sync fails, the community card shows that the sheet needs attention.
Bulk sheet operations
Sync All Sheets updates the eligible community sheets for the selected project.
Open All Sheets opens the community sheets that already have a saved spreadsheet URL.
If a community does not have a sheet yet, creating that new sheet requires an active Google connection.
Disconnecting Google
Disconnect removes the CollabOS Google connection. Existing Google Sheets are not deleted by the disconnect action.
Regular CSV, Excel, copy, and ZIP winner exports remain available without Google Sheets.
Get winner files in Discord
- Open Raffle Operations > Notifications.
- For personal alerts, add your Discord webhook URL, choose when to notify you, enable personal notifications and save.
- For community results, enable the community, choose its Finalized results channel and save.
- To receive a Google Sheet link, leave Prefer Google Sheet enabled and connect your Google account in Winner exports.
Without an available Google Sheet, community notifications attach a CSV. Personal webhook notifications attach a CSV and a Sheets-ready TSV file. If you connect Google later, future notifications can use a Google Sheet link; earlier attachments are not converted automatically.
Choose a new Discord channel
Open the channel selector to load the current list. If your channel is missing, choose Use channel ID, paste its ID and choose Use channel. CollabOS checks that it belongs to the connected server and that the bot can view it, send messages and attach files. Check the channel name, then save the notification settings.
To find the ID in Discord, enable Developer Mode and use Copy Channel ID from the channel menu.
Community results as raffles finish
Community results for the same runner, project and community share one message. If their end times differ, the message shows progress such as 1 of 4 raffles finalized. Its CSV and copy action include only finalized winners. The same message updates as the remaining raffles finish. Different managers’ results stay separate.
Paste winners into Google Sheets
- Choose Open in CollabOS Sheets to view the winner spreadsheet, or Copy / Export Winners to copy or download the results.
- Open the private Winner exports link in the response. The project and community are already selected.
- Choose Copy Winners, then select cell A1 in Google Sheets and paste.
Only the manager who ran the raffles can request this link. It expires after five minutes and can be opened once. The browser receives a 15-minute export-only session, so Discord’s browser does not need an existing CollabOS sign-in. It grants no access to account settings or other projects. An expired session requires a fresh Discord link.
Copy / Export Winners remains available when the notification also includes a Google Sheet link.