I am working on a challenge where I want to automate adding one or more rows to a Numbers spreadsheet based on input from Siri Shortcuts.
This may be possible using CSV files and AppleScript, but I am a new with AppleScript and what research I have so far done suggests a level of complexity that I am not sure I can manage.
Thanks to inspiration from the Automators Podcast I have already created a workflow using a Siri Shortcut which uses Zapier to append a line to a Google Sheet. I use this to track household expenses and get a frequent overview of what budget I have left to spend.
The downside of this setup is that the Zapier free tier only allows up to 100 transactions per month, and it turns out my household has slightly more than 100 transactions per month. Paying 20 euros per month for the next Zapier tier seems excessive for my specific use, so I am researching if I can do this without Zapier.
I would prefer to use Apple Numbers over Google Sheets as a privacy consideration.
Does anybody have a suggestion on how to tackle this challenge?
Would a Siri Shortcut --> CSV --> append row in Numbers spreadsheet combined with AppleScript seem like the best option, or are there better/easier alternatives?
Many thanks in advance for your thoughts on this.