TIL about the =INDIRECT() spreadsheet formula method that allows you to reference columns in a RELATIVE position without knowing the current column or row position.
Super useful for generating formulas programmatically for things like @BudgetSheet!
It's hilarious to me how many personal finance tools crap on spreadsheets and then go on to build a web app, API, mobile app (or two!), widgets, data tables, charts, user accounts w/sharing etc.
And... I get all that for free. By using Google Sheets. 🤦♂️ #buildinpublic
Now I am looking at building my own whole oAuth flow for @BudgetSheet and doing pretty much *everything* on my own server - even manipulating spreadsheets via the REST API instead of Apps Script.
Using Clock Triggers for Autofetch is just not cutting it anymore. #buildinpublic
The reality of building an Add-On for the Google ecosystem is slowly moving everything out of Apps Script and onto your own server the more users you get.
Apps Script is great to get started, but tends to be slow and unreliable over time. #buildinpublic
SEO content marketing really works. Especially when combined with a matching product name and domain.
@BudgetSheet now ranks on the first or second page for many target search keywords, and am slowly gaining on highly competitive ones too. Need more of this!
@BudgetSheet I suspect that I probably just pulled forward some revenue that I may have had in another 30 days (15 days vs. 45 days), so I will see how that plays out over the next few months on wether or not it actually accelerated my revenue growth. #buildinpublic
Just got my first ever "your product is too expensive" email for @BudgetSheet. They even got the price wrong too! It was $69/year when they signed up (now $79/year).
Nearly 3 years into @BudgetSheet and I am finally setting up a proper onboarding email series thanks to the free startup plan from @CustomerIO! 🎉 #buildinpublic