Google Calendar transition to Google Spreadsheet

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.

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.

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.