I recently updated my iPhone and discovered the old Aspire Mobile Budgeting app can no longer be downloaded from the app store.

I know people are working on a mobile app (e.g. here), but I wanted something that worked now to get transactions into Aspire from my phone (the Google Sheets interface is terrible on iOS).

So, based on this post I've built a system based around Google Script and Apple Shortcuts. It's fairly straightforward to get working.

First up the Google Script.

Before you get started, get the Sheet ID of your Aspire Budget. It's embedded in the URL of your Aspire sheet as below.

https://docs.google.com/spreadsheets/d/HEREISYOURID/edit#gid=0

Now go to https://script.google.com and create a new app. I called my app Add to Aspire.

In the code window—paste the code below:

//By reddit.com/funkydan2
//
//Based on Finances to Gsheet made by reddit.com/lautarooo from <https://www.reddit.com/r/shortcuts/comments/aafe5e/update_a_google_sheet_with_your_expenses/>

var aspireBudgetTransaction = SpreadsheetApp.openById("HEREGOESYOURID").getSheetByName('Transactions');

function doGet(e) {
  try {
    var date = JSON.parse(e.parameters.date)
    var amount = JSON.parse(e.parameters.amount)
    var category = JSON.parse(e.parameters.category)
    var account = JSON.parse(e.parameters.account)
    var memo = JSON.parse(e.parameters.memo)
    var status = "🅿️"

    lr = aspireBudgetTransaction.getLastRow();
    var dateFormat = aspireBudgetTransaction.getRange(lr, 2).getNumberFormat();
    var currencyFormat = aspireBudgetTransaction.getRange(lr, 3).getNumberFormat();

    aspireBudgetTransaction.appendRow(["",date,amount,"",category,account,memo,status]);

    aspireBudgetTransaction.getRange(lr+1, 2).setNumberFormat(dateFormat);
    aspireBudgetTransaction.getRange(lr+1, 3).setNumberFormat(currencyFormat);

    return ContentService.createTextOutput("Transaction added.");

  } 
  catch (error){
    return ContentService.createTextOutput("Error: " + error.message);
  }
}

The only change you should need to make to the code is to insert your sheet ID up the top in the place of HEREGOESYOURID.

Then there are two steps to get your script running.

1. Click the 'Run' button once. You need to do this to authorise the script to access your Aspire Budget spreadsheet. You'll need to put in your password and give permission—please make sure you understand the code before you do this, don't just ran any code you find on the internet!
2. Deploy the script. Click the 'Deploy' button select 'New Deployment'. The script needs to run as your user, but allow anyone to run it (you need to do this so the script can be run by Apple Shortcuts).
3. After you click deploy, make sure you get a copy of the Web App ID (not the whole link, just the ID).

Deployment Permissions

Now the Shortcut

You can get the shortcut by clicking the link below.

https://www.icloud.com/shortcuts/3f115a2ffb2b42878ee62fa84d693505

When you save or run it for the first time, a pop up will be displayed requesting the webappid. Paste the ID from Google Sheets.

Finally, you need to personalise the Shortcut to match your budget.