Need help to extract calendar events to numbers

Hi everyone,

I am new to the automators forum, but I’ve been experiencing a while with different solutions for my current problem…

I tried different ways to track my time while working on freelance work and then how to extract that date to my invoices set up as a Numbers template…

I tried timing on the Mac part, but lately I’ve been working on my windows side through Bootcamp, so it’s not really effective. So far, my solution is to imput my working times as events into my calendar and then have that data exported to a table…

This solution using google sheets and google calendar works (google apps script | Rainnic in the Clouds) but I was hoping to find insight on how to do it more natively within the Apple apps since my go-to calendar is on iCloud and I mainly using iWork (or whatever it is called these days).

I’m starting to delve into applescript but I’d like to hear your opinion on the best solution…

Thank you, looking forward

iCal buddy is the one I’ve used in the past

https://hasseg.org/icalBuddy/

That being said, you probably want to give Shortcuts a try!

Here’s a simple example of using Calendar and Numbers together. You’ll see it leverages GizmoPack for the generate CSV action.

https://www.icloud.com/shortcuts/0504930abe974e67a6ad7a930ff0fe80

Here’s the Numbers spreadsheet format

Perhaps this helps you to get started, at least if you want to use Shortcuts — jay