I’ve been using
OpenProject
to track some of my personal projects for a while and I’ve had the need to import time entries from openproject into google sheets. I’d looked around online and couldn’t find a prebuilt way to do this automatically without exporting to excel format first and then uploading. Also I wanted it to sync and I wanted a reason to practice my coding so I gave a go to writing an
apps script
that will use the OpenProject API to sync projects over.
Coding
I’m going to try and publish my coding projects here to help force me to actually finish them and write some documentation. I’ve started writing notes for my projects in obsidian so it shouldn’t be too hard and writing these will help me improve my skills at explaining what my code is doing.
A really useful tool while I was trying to work on this was
postman
. This tool lets you test your API queries to see if they’re working. I’d never worked with a REST API before and it was a very steep learning curve. It took a lot of poking to make it work and understanding the
openProject documentation
wasn’t easy for me. But with persistance I got it figured out.
I’ve been learning to use
VSCode
for writing my apps scripts. Using
Clasp
to manage changes to the apps script project. For this project I installed the VSCode extension called
Cody
. It’s an AI code writing assistant and it was really useful for the most part. it did make some mistakes that took me some troubleshooting to figure out but not more mistakes than I usually make and I got to save a lot of time writing functions that were easy but repetitive.
