Google Sheets is a powerful starting point for business solutions. How are you using it?
Hey IH Community,
I've found so much value in Google Sheets. I know many of you probably have as well.
Here's a breakdown of how I use it to automate email merges:
https://medium.com/p/how-to-make-google-sheets-send-personalized-emails-for-you-61be083553eb?source=email-65de8f916b5f--writer.postDistributed&sk=7f15bcfb24ea727f82530fab49b94df4
Are there any creative ways that you are using Google Sheets to solve problems for your business?
Let me know in the comments!!
Similar idea to the portfolio spreadsheet mentioned below -- I built a Sheet + Apps Script setup for my own portfolio (crypto, Vietnamese stocks, and gold) that pulls live prices via UrlFetchApp with a fallback source if the primary API is down, all converted to one currency. Ended up packaging it as a template after a few people asked how I set it up. Apps Script keeps it low-maintenance since it's just custom functions plus time-based triggers, no server to babysit.
We use it in our https://computools.com/chatbot-development-services/. But thank you. I've learned some new tricks
Nice! Thanks for the example!
I built a service to keep track of your stock portfolios. https://portfoliospreadsheets.com
I use server-side code rather than appscript to keep the spreadsheets light and maintenance free. It means there are less permissions manage and the user can't break the spreadsheet as easily.
This looks great! How are you guys doing with sales?
My husband's a whiz with Sheets (http://benlcollins.com) and he helps me built dashboards to track online sales in real time. Here's a walk-through of a recent one. I built a simple version and he helped me spice it up =) https://www.linkedin.com/posts/alexisgrant_onlinebusiness-affiliates-revenue-activity-6677170077923598336-bJZe
Yes! I've watched several of Ben's videos! Tell him I said he's doing a great job!
Also, that dashboard looks awesome. You guys are a power couple.
This comment was deleted 5 years ago
Yeah this is great. It sounds like you guys managed to built something decently powerful. I've been amazed by what a little custom code can do alongside a Google sheet.
Thanks for sharing!