nateay0/sheetsbot

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

SheetsBot

SheetsBot is a discord bot that allows you to read, write and remove data from Google Sheets.

Important:

• No additional help will be provided for this repository.
• Read the readme.md file for complete information about the bot.
• It is recommended to watch the GoogleSheetsAPI tutorial for more information. (Link Below, Under Configuration)
• If you have any questions, please contact me on discord.

Requirements

• Discord.js v13 or higher (npm install discord.js@latest)
• NodeJS v16.6 or higher
• Google APIs Client Library for NodeJS (npm install googleapis)
• applications.commands scope enabled for your bot in developer portal
• Basic knowlegde of Discord.js or JavaScript or NodeJS

Getting Started

Creating a fork

• Click here to create a fork
• Open your terminal and do git clone https://github.com/Simpleboy353/SheetsBot.git

Installing dependencies

• Open your terminal and do npm install

Starting the bot

Do any one

• npm start
• node index.js
• node .

Configuration

• Edit the config.json file

{
	"botToken": "ENTER_YOUR_BOT_TOKEN_HERE",
	"spreadsheetId": "ID_OF_THE_GOOGLE_SHEET",
	"ownerId": "ENTER_YOIUR_ID_HERE",
	"prefix": "ANY_PREFIX_OF_YOUR_CHOICE",
	"error_logs": "ENTER_THE_ERROR_LOGS_CHANNEL_ID_HERE"
}

• botToken is the token of your bot
• spreadsheetId is the ID of the Google Sheet you want to use
• ownerId is the ID of the owner of the bot
• prefix is the prefix of the bot
• error_logs is the ID of the channel where you want to send the error logs
• You will also need an additional credentials file to use this bot.
• Watch this video to see the full Google Sheets API Tutorial:
• 

Star the Repo if you liked it!