Redis 2 Sheet

Redis event to Google Sheet

Usage

go run main.go run --spreadsheetID 1b6yWP-uurheUvLgg0PENgYyZmLknqGHkRP9gsuHTBmI --channels=events,copy

Test

go test -v -run TestPublishEvent

Download

Linux

curl -L https://github.com/addodelgrossi/redis2sheet/releases/download/v0.0.3/redis2sheet_linux-amd64 -o redis2sheet
chmod +x redis2sheet

Configure Linux Services

Create user

sudo useradd -r -s /bin/false redis2sheet

Download Application

sudo mkdir -p /opt/redis2sheet/
cd /opt/redis2sheet/
sudo curl -L https://github.com/addodelgrossi/redis2sheet/releases/download/v0.0.5/redis2sheet_linux-amd64 -o redis2sheet_linux-amd64
sudo chmod +x redis2sheet_linux-amd64
sudo chown -R redis2sheet:redis2sheet /opt/redis2sheet

Create Service File

cat << EOF | sudo tee -a /etc/systemd/system/redis2sheet.service
[Unit]
Description=Redis to Sheet Service
After=multi-user.target
Conflicts=getty@tty1.service

[Service]
Type=simple
ExecStart=/opt/redis2sheet/redis2sheet_linux-amd64 run --channels=events,copy --spreadsheetID 1BnsjYrPXcr_QD1kc8JTrEfF3yKLgVFqFaG-jBHhzOqI
#StandardInput=tty-force
StandardOutput=journal
StandardError=journal
SyslogIdentifier=redis2sheet
User=redis2sheet
WorkingDirectory=/opt/redis2sheet
TimeoutStopSec=10
Restart=on-failure
RestartSec=5

[Install]
WantedBy=multi-user.target
EOF

Configure Service and start

https://www.baeldung.com/linux/systemd-create-user-services https://betterprogramming.pub/unleashing-your-daemons-creating-services-on-ubuntu-731cd933e02e

sudo systemctl enable redis2sheet.service
sudo systemctl daemon-reload
sudo systemctl status redis2sheet.service
sudo systemctl start redis2sheet.service

Testing

docker run -it ubuntu /bin/bash
apt update
apt install sudo curl systemctl systemd
apt install sudo curl systemd

View logs

sudo journalctl -u redis2sheet.service -f