🖼️ TRMNL Google Sheet Quote 📊

A private plugin for TRMNL to display quotes from a Google Sheet.

🚀 Features

• Displays a random quote from a Google Sheet.
• Customizable polling interval to fetch new quotes (default: 1 hour).
• Configurable columns for quote and author.
• Robust error handling with on-screen feedback.

🛠️ Installation

1. Clone this repository to your local machine.
2. Copy the src directory to your TRMNL plugins directory.
3. Rename the src directory to sheet-quote.

⚙️ Configuration

Configuration is handled within the TRMNL application. After installing the plugin, you will find the following settings:

• Spreadsheet ID: The ID of your Google Sheet.
• Quote Column Index: The column number (starting from 0) for the quotes in your sheet.
• Author Column Index: The column number (starting from 0) for the authors in your sheet.

For more detailed instructions, please see the TRMNL documentation.

❓ Troubleshooting

If you see "No data found" or the plugin is stuck on "Loading quote…":

1. Check Spreadsheet ID: Ensure the ID is correct and the sheet is shared with "Anyone with the link" (Viewer access).
2. Check Logs: In the TRMNL dashboard, go to the Logs tab for this plugin. Look for "Sheet Quote: Starting execution" to verify the script is running.
3. Error Messages: The plugin displays specific error messages on the screen if data is missing or malformed to help you debug.

🚧 Development

This project does not have any dependencies to install or a development server to run. The plugin is designed to be used within the TRMNL application.

To make changes, edit the files in the src directory. The .liquid files control the layout, and settings.yml controls the configuration options.

⚖️ License

This project is licensed under the Apache License 2.0. See the LICENSE file for details.

📝​ Author

​This project was started in 2025 by Nicholas Wilde.