EXPENSE PULSE

Make your own Sheet

Tap the button below, sign in to Google if asked, then choose Make a copy. The dashboard and its attached script are copied into your account.

Open the built-in script

Inside your copied Sheet, open Extensions → Apps Script. You should see code containing a function named doPost.

If the code is already there, leave it exactly as it is and continue. If the editor is blank, copy the script below and paste it into Code.gs.

const CATEGORIES = ["🍛 Food","🛍 Shopping","🚙 Travel","🧾 Bills","🎬 Entertainment","📦 Other"];

function doPost(e) {
  const lock = LockService.getScriptLock();
  lock.waitLock(10000);
  try {
    const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Expenses");
    const data = JSON.parse(e.postData.contents);
    const nextRow = sheet.getLastRow() + 1;
    ensureRows_(sheet, nextRow);
    sheet.getRange(nextRow, 1, 1, 4).setValues([[ new Date(), Number(data.amount), data.category, data.note || "" ]]);
    sheet.getRange(nextRow, 1).setNumberFormat("dd mmm yyyy, hh:mm am/pm");
    sheet.getRange(nextRow, 2).setNumberFormat("₹#,##0");
    return ContentService.createTextOutput(JSON.stringify({status:"success",row:nextRow}))
      .setMimeType(ContentService.MimeType.JSON);
  } finally {
    lock.releaseLock();
  }
}

function ensureRows_(sheet, requiredRow) {
  if (requiredRow > sheet.getMaxRows()) {
    sheet.insertRowsAfter(sheet.getMaxRows(), Math.max(500, requiredRow - sheet.getMaxRows()));
  }
}

Deploy your connector

1. Click Deploy → New deployment.
2. Tap the gear beside "Select type" and choose Web app.
3. Set Execute as to Me.
4. Set Who has access to Anyone.
5. Click Deploy and approve Google’s permission request.

Google may show an "unverified" warning. First confirm that you are authorizing the script inside your own copied Sheet. Then choose Advanced → Continue to project → Allow.

Copy the Web app URL. The correct address ends in /exec.

Install and connect the Shortcut

Open the Shortcut link on your iPhone, tap Get Shortcut, then open it for editing.

1. Scroll near the bottom to the blank URL action immediately above "Get Contents of URL".
2. Paste your Google web-app URL ending in /exec.
3. Tap Done.

Add one test expense

1. Run the Shortcut on your iPhone and enter a small test amount.
2. Pick a category and add an optional note.
3. Allow network access if iPhone asks.
4. Open the Expenses tab in your Sheet and check the new row.

See the new row? You're almost done! Continue to Step 6 below to connect your sheet to this web app.

Connect your Sheet to Expense Pulse Web App

1. Inside your Google Sheet, click File → Share → Publish to web.
2. Under "Link", select Comma-separated values (.csv) and click Publish.
3. Copy the published link.
4. In Expense Pulse, click the ⚙️ Settings icon at the top right, paste your published CSV link into the URL field, and tap Save Connection.

Setup Complete! Expense Pulse will now automatically sync your daily expenses!