Google Sheets App


More and more these days I’m thinking of powerful ways to use Google Sheets for business needs. I recently created an “App” of sorts using only Google Sheets.

The project requirements were to maintain a future schedule for the main meeting in my church. I’m responsible for planning this meeting, which includes finding people to say prayers, people to speak, and hymns to sing.

The problem I had to solve was to allow the people responsible for different parts of the planning to communicate with each other (real time) while reducing the possibility of someone overriding another’s data and keeping some sensitive information private.

The solution was three Google Sheets that talk to each other. I have a sheet for themes and music that is populated by the music people. I have the planning document (with sometimes sensitive/private data) that I use to record future speakers and prayers; this document pulls in the themes and music (real time). And last, I have a program document that dynamically shows the next three weeks of the schedule so programs can be made.

It works like a charm. I’ve only found one issue; if someone opens the main document on a mobile phone and they close it before the sheet calculates, it breaks the formulas and shows errors in the program document. The work around is to replace the formulas with values if a week is totally planned.

About The Author

Ben currently works as a senior developer and technical business consultant outside of Boulder, Colorado.

Read more about Ben

About Buink

Buink Web Development is a website development company founded in 2009. Although we still focus on web development, we now offer digital marketing services, web design, local SEO services, ecommerce website design, and custom logo design

Our value proposition: Buink can help you unleash the power of the internet and help your business scale with superior quality code at a competitive price and in a transparent, honest way. 

Read more about Buink

Buink Web Development
Based on 8 reviews
Cycle S.
Cycle S.
Buink generously helped us optimize our Google Ads for an upcoming community event. He expertly walked us through our dashboard making precise recommendations that helped us launch a successful campaign. Google Ads were much more difficult to get going than we anticipated, so we were very grateful for the advice.

Connect with Buink

Connect with Buink via email, send us a message, or subscribe to our blog.