Connect Discord to Google Sheets
Ideas
What you can do with Discord and Google Sheets
Work through a content queue in Sheets and post results to Discord
Every hour, the next ready idea in your sheet becomes a draft script or caption, is saved back to the row and is posted to your Discord channel.
See how it worksPost new and changed sheet rows to Discord
Whenever a row in your sheet is added or changed, a formatted message appears in your Discord channel.
See how it worksExport Discord members with a role to Google Sheets
A sheet listing every member of your Discord server who has a chosen role, refreshed each day.
See how it worksLog form leads to a Google Sheet and announce them in Discord
Each lead from your website form is added to your Leads sheet and posted in your Discord #leads channel within seconds.
See how it worksLog every shop order in a sheet and post it to Discord
Each new order from your shop is added to your Orders sheet and announced in your Discord channel.
See how it worksCreate a Discord channel for each new project in your sheet
Add a project row to your sheet and a Discord channel is created, its members are tagged in a welcome message, and the channel ID is saved back.
See how it worksWatch a list in Google Sheets and alert Discord when something changes
Sites, domains or prices you list in a sheet are checked every 30 minutes, the sheet shows the latest status, and Discord hears when one flips.
See how it worksModerate a Discord channel against rules in a Google Sheet
New messages in your channel are checked against your rules sheet, and any that break a rule are logged and flagged to your moderators.
See how it works Your own logicAny other automation you can describe in words
Your own rules, schedule and AI steps with Discord and Google Sheets, plus any other app. Describe it and your assistant builds it.
See how to build your ownBuild your own
Build any Discord and Google Sheets automation you can describe
Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.
For example, ask your assistant
Every Sunday, post in Discord #leaderboard the top 10 rows from my Points sheet sorted by score.
Every hour, read new messages in Discord #suggestions, use AI to tag each as bug, idea or other, and add them to my Suggestions sheet.
Use cases
Why people connect Discord and Google Sheets
How the two apps work together
- The automation checks the sheet every few minutes for new or changed rows.
- New rows are posted to a Discord channel through a webhook or a bot, with the columns you choose.
- In the other direction, the script reads channel messages or server data through a Discord bot on a schedule and writes rows to the sheet.
Community event signups
Community managers log Discord event registrations or reactions in a sheet with username and date. They plan attendance from it.
Moderator reports
Moderators keep a sheet of flagged messages and actions taken. A weekly summary posts back to a private mod channel.
Product updates from a release sheet
Small game and software studios post new rows from a release notes sheet to an announcements channel.
Member growth tracking
Server owners log member counts daily in a sheet and chart growth over time.
More apps
Discord, Google Sheets and other apps in one automation
New videos logged and announced
When my YouTube channel publishes a video, add it to my Content sheet and post the link in our Discord #videos channel.
New supporters logged and welcomed
When a new Stripe subscription starts, add the customer to my Supporters sheet and post a thank-you in Discord #supporters.
Form applications to Sheets and Discord
When someone applies through my Google Form, add the row to the sheet and post a summary in our private Discord #applications channel.
Setup
Connect Discord and Google Sheets once
Discord
Community chat
- At discord.com/developers/applications, create a new application, open Bot and choose Reset Token. Copy the token, since Discord only shows it once.
- On the Bot page, turn on the privileged intents your automations need, such as Message Content to read messages or Server Members to list members.
- Under OAuth2, use the URL Generator with the
botscope and the permissions you need, such as Send Messages or Manage Messages, then open the URL to add the bot to your server. - In the ClickRuntime dashboard, open Connections & secrets and save the bot token. It is sent as
Bot <token>.
Google Sheets
Spreadsheets
- In the ClickRuntime dashboard, open Connections and choose Google Sheets.
- Sign in with your Google account and allow access.
- Pick the spreadsheets the automation may use. It can't see any other file in your Drive.
FAQ
Questions about connecting Discord and Google Sheets
How do messages get into Discord?
Will a row be posted twice?
Can I choose which columns appear in the message?
Can a sheet control what happens in Discord?
Do I need a Discord bot?
Can it read past messages?
How often does it check the sheet?
Related pages
Keep exploring
Tell your assistant what Discord and Google Sheets should do together
Free plan. No credit card.