Skip to content

Instantly share code, notes, and snippets.

@thepeopleseason

thepeopleseason/full.liquid

Last active November 13, 2025 15:09
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save thepeopleseason/584ebecf3a0c63c6bf987ef67370d67b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save thepeopleseason/584ebecf3a0c63c6bf987ef67370d67b to your computer and use it in GitHub Desktop.
Download ZIP
TRMNL Away message using Google Forms/Sheets
Raw
full.liquid
<div class="layout">
<div class="column">
<div class="value value--large">{{ data[-1][1] }}</div>
<div class="title">{{ data[-1][0] | date: "%Y-%m-%d %H:%M" }}</div>
</div>
</div>
Raw
settings.yml
---
strategy: polling
no_screen_padding: 'no'
dark_mode: 'no'
static_data: ''
polling_verb: get
polling_url: https://docs.google.com/spreadsheets/d/1qK8hzHpkQ6mL-OuOZWprDxCNoZtIwStAiLGMxou_w9A/export?format=csv&gid=2088308444#gid=2088308444
polling_headers: ''
polling_body: ''
id: 163154
name: Google Forms Away Message
refresh_interval: 1440
@thepeopleseason
Copy link
Author

thepeopleseason commented Oct 8, 2025

Instructions:

  1. Create Google Form with 1 "Short answer" question.
  2. Save Form.
  3. Go to Responses and "View in Sheets"
  4. In the sheet, go to Share and make sure General Access is set to "Anyone with the link"
  5. In the TRMNL recipe settings, set the polling URL to the url of the sheet, but with export?format=csv& in place of edit?
  6. Put the contents of full.liquid in the Full markup in TRMNL.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment