Skip to content

Latest commit

 

History

History
52 lines (35 loc) · 2.02 KB

README.md

File metadata and controls

52 lines (35 loc) · 2.02 KB
Raw

🤖 Hall of Fame with Google Drive CSV Integration 📊

Welcome to the Hall of Fame project! This bot fetches messages and images from a CSV file stored in Google Drive and posts them to a specified Discord channel.

🌟 Features

  • Fetch Data from Google Drive: The bot reads a CSV file stored on Google Drive.
  • Message Filtering: Only fetches and posts messages with 8 or more reactions.
  • Flexible Posting: Posts messages to a Discord channel at a specific time every day. 🕒
  • Custom Message Format: Outputs messages in the format: name + message + message_link + image_url (if available).

🚀 Getting Started

1. Prerequisites

Before running the bot, make sure you have the following:

  • .NET Core SDK installed.
  • Google Cloud Platform account with a project that has access to Google Drive API.
  • Discord Bot Token: You can create one by following the Discord Developer Portal.
  • CSV File on Google Drive containing your data.

2. Environment Variables

Set the following environment variables to configure your bot:

DISCORD_BOT_TOKEN=your-discord-bot-token
DISCORD_CHANNEL_ID=your-discord-channel-id
GOOGLE_DRIVE_FILE_ID=your-google-drive-file-id
GOOGLE_CREDENTIALS_PATH=path-to-your-google-credentials.json
POST_TIME=HH:mm:ss (time in Spain to post)

3. CSV File Structure

Your CSV file should have the following columns:

  • name: The name of the person or bot.
  • message: The content of the message.
  • message_link: A link to the original message.
  • image_url: (Optional) A link to the image.
  • has_spoilers: Whether the message contains spoilers.
  • total_reactions: The number of reactions.

🛠️ Customization

You can easily modify the bot's behavior by editing the Program.cs file:

  • Posting Time: Change the POST_TIME to adjust when the bot posts.
  • Message Format: Modify the message format in the code to suit your needs.