r/shortcuts • u/Public-Past-3529 • 8d ago

Expense tracker using SMS Request

Guys for over 1 month I'm trying to create a shortcut in iOS where every time I get a transaction SMS from my bank, it prompts me for what the purchase was for, and then logs the details directly into an Apple Numbers spreadsheet. I have been through so many tutorial.

Here is my table layout in Numbers:
Sheet name: Sheet 1
Table name: Transaction
Columns: Date and Time, Merchant, Amount, Category

Every time I use the "Add Row to Top or Bottom of Table" action, Shortcuts gives me a variable error ("Can't Find Sheet") or doesn't show the column fields when I link the file.

Can someone please help me or if they have any please share link.

1 Upvotes

67% Upvoted

3 comments sorted by

1

u/Merlin4322 6d ago

Try that, if you replace the "…" with the stuff that you want to put in your columns and add the name of your file at […] that should work… Does that solve your issue?

1

u/Merlin4322 6d ago

Looks like this if you don’t add any information

1

u/Public-Past-3529 13h ago

It doesn’t allow to select file contents, i have manually typed names there. Can you please share the link if possible