Google Calendar transition to Google Spreadsheet

  • 1
  • Question
  • Updated 1 year ago
  • (Edited)
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members.

Need help with this please! I need to have a google spreadsheet with dated items for a menu instead of google calendar. It would need to show each day separately for the month. Calendar just isn't doing what I need it to do unfortunately. There is a link on here but it is deprecated. It talked about having a script and two pages. The link given is 404'd. I just need some guidance please.
Photo of Wayne Williams

Wayne Williams

  • 110 Points 100 badge 2x thumb
  • overwhelmed

Posted 1 year ago

  • 1
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
If I understand it correctly, you need different menu for different day and you want to use google sheets widget for that. If that is the case, then you need to make: #1 sheet file/page for each day, #2 google sheet item for each day, link each item to designated google sheets file/page and schedule them to show only on specific day of the month.
Photo of Wayne Williams

Wayne Williams

  • 110 Points 100 badge 2x thumb
No I need to have one continuous spreadsheet that will be added to every week to two weeks and then one page to format how it is displayed. It's a daily menu for an assisted living community. I don't want the person that will be entering the information to have to mess with the display on a daily basis. The person that wrote on here about a script that processed this information was 2 years ago and the information is deprecated so i can't even view what he did. I am a novice presently. I can move around Rise with ease but this goes out of my league when dealing with sheets. It would display Breakfast Lunch and Dinner menus on the display.
(Edited)