Pricing
Log inGet started free
All integrationsCommunication
Live~2 minutes

Rocket.Chat → Google Sheets

Import channels & users from Rocket.Chat

Connect Rocket.ChatRead setup guide ↓

API key · Read-only by default · No data stored

~2 minutesSetup time
API keyAuthentication
15 minMin sync interval
Read-onlyDirection

Capabilities

Everything in the Rocket.Chat connector

3 built-in capabilities, from live queries to scheduled syncs and AI-powered data analysis.

Import Channels & Users (2 data types available)

Technical details

Built for IT teams to approve in one read

Every connection is read-only by default. Credentials are encrypted at rest. Brooked is a verified Google Workspace app.

Authentication
API key
Direction
Read-only

Setup guide

Connect in 3 steps

From install to your first live query in under 5 minutes. No engineering help required.

Get started free
1

Connect your account

Authorize Brooked to access your Rocket.Chat data using an API key or token.

2

Choose what to import

Pick from 2 available data types, like Channels, Users.

3

Schedule your sync

Run it once, or set a recurring schedule. Data flows straight into your Google Sheet.

Need help? Visit support →

Use cases

How teams use Rocket.Chat + Brooked

From finance reporting to real-time operations dashboards, see what your team can build.

Keep Rocket.Chat data current in Sheets

Automatically sync your communication data from Rocket.Chat into a Google Sheet on a schedule, so reports and dashboards always reflect what's actually in Rocket.Chat, no manual exports.

Live in Google Sheets
Rocket.Chat → Sheets · auto-refresh

Available functions

Query Rocket.Chat from a cell

Five built-in sheet functions, from natural-language queries to raw SQL and AI-powered KPI cells. No coding required.

fx

=BRKD_QUERY("Rocket.Chat", "show me the top records from last month")

Ask a natural-language question against any connected data source. Returns a table of results that spills into adjacent cells.

=BRKD_QUERY("Rocket.Chat", "show me the top records from last month")

Also supported

More Communication integrations

Discord Bot

Live

Import guilds (servers) your Discord bot is in

Facebook

Live

Import your Facebook Graph API profile & pages

Get your spreadsheet hours back

Brooked sets up in seconds. Your team is querying live data before lunch.

Get started free