Efficient Small Business

If you work with a team, Google Sites is a great tool to improve communication and increase productivity. It allows you to organize your data in a user-friendly way. Additionally, it seamlessly integrates with other Google services, so you can easily add files directly from your Drive. Recently, Google made updates to Sites, and we are excited about it. At Efficient Small Business, we want to keep you up-to-date on the newest developments to improve your workflow. The "New" Google Sites has been around for a few years, but it did not come with many features when it was first released (compared to "Classic" Sites). However, Google is steadily introducing new functionality and updates to make this platform more robust. Here are a few of the most recent updates. Collapsible Text It is now possible, to create a collapsible text element. This is ideal if you have a lot of information that you need to share, but you don't want to clutter your whole page. ...

Occasionally, you have more information than a spreadsheet can handle. When you have a million or more rows of customer data, it may be time to switch to a database. But how do you keep using Google Sheets if your data is stored in a database? In this video, I demonstrate how to connect Google Cloud SQL to your spreadsheet using Google Apps Script. Interested in learning more about Google Apps Script and Google Sheets? Subscribe to my channel.