Create serial letters with Google Docs/Suite

Be it an invitation to a birthday party, a circular letter to the club members or any other marketing activity. Serial letters enable an automated and yet personalized approach to the recipients. In this article I would like to show how Google Sheets and Google Docs can be used to send even elaborately designed documents …

read more

Show and analyse Gitlab issues in Google Sheets

Back in May of this year, I showed how to display data from Gitlab in a Google Sheet using the GitLab API and Google App Scripts. Based on this, a new script has been created in the last few days that I would like to share with you. This time it’s about querying a whole …

read more

Photo by M. B. M. on Unsplash

Stock analysis with Google Sheets

If you deal with the investment of money on the stock market, you will encounter numerous tools that provide you with evaluations and statistics. As a big Excel/Google Sheets fan I love to tinker with individual evaluations. In this article I would like to show you which reports you can create with the help of Google Sheets.

Google offers own functions in Google Sheets through their service “Google Finance”. You can use these functions to create very comfortable reports.

read more

Photo by rawpixel on Unsplash

Simple time tracking directly in Google Kalendar

Even though many new working models do not use time tracking, I think it is very important to record the time spent. Someone once said: “Only what I measure can I improve”. For me personally, time tracking helps me to focus and budget my time. Especially when you work on many topics, it is difficult to set priorities. Time tracking helps me to keep within limits and to dedicate only the time I have allocated to each topic.

The most important thing for me is that time tracking is as simple as possible and can be integrated very easily. Therefore I have been using my calendar for four years now. A tool that is already open all day anyway. In this article you can find out how to do this.

read more