A Discord Bot that extracts information from a Google Sheets File. It was created to manage a New World's players list.

Version 1.0 - Discord Bot that manages a Google Sheets File A Discord Bot that extracts information from a Google Sheets File. It was created to manag

Information

Category: JavaScript / Miscellaneous
Watchers: 1
Star: 3
Fork: 0
Last update: Nov 15, 2021

Resource links

https://github.com/RuMont/DiscordSheet

README
Issues 5

Version 1.0 - Discord Bot that manages a Google Sheets File

A Discord Bot that extracts information from a Google Sheets File. It was created to manage a New World's players list.

About this project

This project uses the Google Sheets API v4 and Discord.js API v13.

Requires node.js v16+.

Requires a Google Cloud Console project to generate credentials and token.

Requires a config.json file to include the bot's client token and prefix. It is recommended to include the spreadsheet inside this file.

Usage

To start running this project you need to execute npm install to install dependencies.

To enable the bot once you have the required files execute node ..

To generate a new token execute node newtoken.js. Your google account needs privileges inside your Google Project

Available commands

showall - Displays the entire players list. It depends on the selected range for the spreadsheet.
show player - Displays an embed message based on information of the selected player.
help - Shows basic bot usage.

Useful references

0 Open More issues

Closed

Spreadsheet Example

Hello again, can you give us an example of the spread sheet data? I'm running into errors when using $show {name}, mainly I believe because I do not the know icon format for it to parse.

` /home/ubuntu/DiscordSheet/index.js:107 mainwpn = row[6].replace(/ /, ''); ^

TypeError: Cannot read properties of undefined (reading 'replace') at /home/ubuntu/DiscordSheet/index.js:107:42 at Array.map () at /home/ubuntu/DiscordSheet/index.js:103:22 at /home/ubuntu/DiscordSheet/node_modules/googleapis-common/build/src/apirequest.js:48:53 at processTicksAndRejections (node:internal/process/task_queues:96:5) `

opened Nov 29, 2021 by dbfy 2

Closed

Missing config.json

Requires a config.json file to include the bot's client token and prefix. It is recommended to include the spreadsheet inside this file.

Can you post an example json?? thanks.

opened Nov 28, 2021 by dbfy 2

Closed

Bump node-fetch from 2.6.5 to 2.6.7

Bumps node-fetch from 2.6.5 to 2.6.7.

Release notes

Sourced from node-fetch's releases.

v2.6.7

Security patch release

Recommended to upgrade, to not leak sensitive cookie and authentication header information to 3th party host while a redirect occurred

What's Changed

fix: don't forward secure headers to 3th party by @jimmywarting in node-fetch/node-fetch#1453

Full Changelog: https://github.com/node-fetch/node-fetch/compare/v2.6.6...v2.6.7

v2.6.6

What's Changed

fix(URL): prefer built in URL version when available and fallback to whatwg by @jimmywarting in node-fetch/node-fetch#1352

Full Changelog: https://github.com/node-fetch/node-fetch/compare/v2.6.5...v2.6.6

Commits

1ef4b56 backport of #1449 (#1453)
8fe5c4e 2.x: Specify encoding as an optional peer dependency in package.json (#1310)
f56b0c6 fix(URL): prefer built in URL version when available and fallback to whatwg (...
See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR
@dependabot recreate will recreate this PR, overwriting any edits that have been made to it
@dependabot merge will merge this PR after your CI passes on it
@dependabot squash and merge will squash and merge this PR after your CI passes on it
@dependabot cancel merge will cancel a previously requested merge and block automerging
@dependabot reopen will reopen this PR if it is closed
@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
@dependabot use these labels will set the current labels as the default for future PRs for this repo and language
@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language
@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language
@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies

opened May 9, 2022 by dependabot[bot] 1

Closed

Bump follow-redirects from 1.14.4 to 1.14.7

Bumps follow-redirects from 1.14.4 to 1.14.7.

Commits

2ede36d Release version 1.14.7 of the npm package.
8b347cb Drop Cookie header across domains.
6f5029a Release version 1.14.6 of the npm package.
af706be Ignore null headers.
d01ab7a Release version 1.14.5 of the npm package.
40052ea Make compatible with Node 17.
86f7572 Fix: clear internal timer on request abort to avoid leakage
2e1eaf0 Keep Authorization header on subdomain redirects.
2ad9e82 Carry over Host header on relative redirects (#172)
See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR
@dependabot recreate will recreate this PR, overwriting any edits that have been made to it
@dependabot merge will merge this PR after your CI passes on it
@dependabot squash and merge will squash and merge this PR after your CI passes on it
@dependabot cancel merge will cancel a previously requested merge and block automerging
@dependabot reopen will reopen this PR if it is closed
@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
@dependabot use these labels will set the current labels as the default for future PRs for this repo and language
@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language
@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language
@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies

opened Jan 15, 2022 by dependabot[bot] 1

Closed

Bump follow-redirects from 1.14.4 to 1.14.8

Bumps follow-redirects from 1.14.4 to 1.14.8.

Commits

3d81dc3 Release version 1.14.8 of the npm package.
62e546a Drop confidential headers across schemes.
2ede36d Release version 1.14.7 of the npm package.
8b347cb Drop Cookie header across domains.
6f5029a Release version 1.14.6 of the npm package.
af706be Ignore null headers.
d01ab7a Release version 1.14.5 of the npm package.
40052ea Make compatible with Node 17.
86f7572 Fix: clear internal timer on request abort to avoid leakage
2e1eaf0 Keep Authorization header on subdomain redirects.
Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR
@dependabot recreate will recreate this PR, overwriting any edits that have been made to it
@dependabot merge will merge this PR after your CI passes on it
@dependabot squash and merge will squash and merge this PR after your CI passes on it
@dependabot cancel merge will cancel a previously requested merge and block automerging
@dependabot reopen will reopen this PR if it is closed
@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
@dependabot use these labels will set the current labels as the default for future PRs for this repo and language
@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language
@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language
@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies

opened Feb 14, 2022 by dependabot[bot] 0

🤩 ‎‎‎‏‏‎ ‎Offers a range of beautiful sheets (dialogs & bottom sheets) for quick use in your project. Includes many ways to customize sheets.

A multipurpose bot, a clan bot, a all in one bot. The one bot u need for ur server originally made as Milrato discord Bot and by Tomato6966.

Read data from, write data to, and modify the formatting of Google Sheets

A Demo application📱 which stores User feedback from 💙Flutter application into Google Sheets🗎 using Google AppScript.

Awesome AI Learning with +100 AI Cheat-Sheets, Free online Books, Top Courses, Best Videos and Lectures, Papers, Tutorials, +99 Researchers, Premium Websites, +121 Datasets, Conferences, Frameworks, Tools

Connect to any API, website or database in Google Sheets.

Discord rich presence for MPRIS music players.

Simple Google Sheets interface to track time

AWS Cheat Sheets - handmade cheat sheets for different AWS services:

TedBottomPicker is simple image picker using bottom sheet

A discord bot that allows you to read, write and remove data from Google Sheets

Discord bot for the official Next.js Discord

Hydra is a Multi Purpose Discord Bot, Invite Hydra to your Discord Server to make your Server Cooler,

Discord ticket bot with buttons made with Discord.js v13

Discord Bot to scrape Among Us on-screen data and automatically mute players between rounds

Discord Bot to automute Among Us players at round transitions

OpenSource discord bot for FindMentor Network discord server

A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file.

A list of `.new` domain to perform online actions in one quick step.

A cool Discord bot to manage tickets on your server !

A simple short URL redirect service built on top of Google Sheets, and runs for cheap on Google Cloud Run serverless.

Share this repo

Related Repos

Miscellaneous

5.5k

Apache OpenWhisk is an open source serverless cloud platform

OpenWhisk OpenWhisk is a serverless functions platform for building cloud applications. OpenWhisk offers a rich programming model for creating serverl

Miscellaneous

Replaces twitter NFT idiocracy

HexaGone HexaGone allows you to revert or customize twitter's new hexagonal avatars. It's a collection of a several userscripts, with different clip m

Miscellaneous

replaces the nft avatars on twitter with subway jared

replace-nft-avatars a chrome extension that replaces the nft avatars on twitter with subway jared to install Download this repo (Code > Download ZIP).

Miscellaneous

Smart Contract Viewer for VS Code

Contract Viewer English | 中文 Contract Viewer 是一个 VS Code 扩展，他可以帮你从区块链浏览器下载合约代码，只需要一个合约地址即可下载。目前仅支持以太坊使用 Solidity 的智能合约，后续会支持更多类型。快速开始配置一个 API 在 Erh

Miscellaneous

Video calling using WebRTC

webrtc-video-call This project is a video calling application using WebRTC technology. It contains minimum requirements to provide a group video call.

Miscellaneous

A multipurpose bot, a clan bot, a all in one bot. The one bot u need for ur server origina...

Multipurpose-discord-bot A multipurpose bot, a clan bot, a all in one bot. The one bot u need for ur server originally made as Milrato discord Bot and

Miscellaneous

334

A template for site builders and low-code tools.

Platforms Starter Kit The all-in-one starter kit for building platforms on Vercel. Introduction · Guide · Demo · Contributing Deploy Your Own Read the

Miscellaneous

152

A Raycast/Alfred/Spotlight alternative

sol A Raycast/Alfred/Spotlight alternative Don't bother trying to run this, it's WIP, right now only the basic UI is there, no logic, there many bugs/

Miscellaneous

Self hosted media tracker for movies, tv shows, video games, books and audiobooks

MediaTracker · Self hosted platform for tracking movies, tv shows, video games, books and audiobooks, highly inspired by flox Demo https://mediatracke

Miscellaneous

Everytime I come across good Github profiles I index them here

awesome-devs Everytime I come across good Github profiles I index them here NOTE: If you are on the github repo currently, go to the website 👇 to see

Miscellaneous

Minimalist template for foundry projects

Foundry template This is a template for a Foundry project. Installation To install with DappTools: dapp install [user]/[repo] To install with Foundry

Miscellaneous

vite-plugin-terminal Log in the node terminal from the browser Open a playground online in StackBlitz Install npm i -D vite-plugin-terminal Add plugin

Miscellaneous

A simple web3 app for minting NFTs

Web3 - Full Tutorial The demo contains a basic web3 app and smart contract for minting NFTs. See it in action in the Web3 NFT Tutorial on YouTube. Fol

Miscellaneous

A three.js component library for Svelte.

A three.js component library for svelte. Index What is threlte? Getting started Concepts Interactivity Viewport Awareness Reactivity Conventions Refer

Miscellaneous

Wordle Svelte Clone

Wordle Svelte Clone Son zamanlarda popüler olan WORDLE uygulamasını svelte ile yapmaya çalıştım. Bu tarz acaba yapsam nasıl yapardım uygulamarı bana ç