Hello,
I’m brand new and in way over my head already! Woo Hoo!
I’m about to really get into it so TL/DR, I cannot for the life of me get Coda to write a table into an existing Notion database. Tried Make.com and was looking into Notion’s APIs but really struggling, has anyone found a way to do it without paying extra/using a 3rd party tool?
So I’ve been using Notion, as many of us have, as a note taking app and general hub for all things Life Management. This includes tracking things at my job, having a to-do list, and the subject of today’s conversation, tracking my finances.
I got a Notion template that works and looks great. I’m tracking my expenses and income in their own databases and have neat little buttons that automatically will create new spending/earnings in those databases. Only problem was Notion didn’t have the power feaures built-in that I was looking for. One thing I’m trying to do is every month, I want to archive my income and expenses for that month to a big table with a full history of everything. Then I want them to empty and just keep my recurring monthly income/expenses, ultimately giving me a fresh start at the top of each month. This will help me plan budgeting and other stuff.
That’s where I found out about Coda and it’s more advanced functions. I created a setup that I like, that I will now walk through, though I’m sure you all will pick it apart…
It starts with the tables I created. Through installing the Notion pack, I have a copy of the notion databases that I can refresh, an archive table that contains all my historical data written from that first Notion table, and another table that just writes a fresh set of data based on my recurring income/expenses. I then have 3 buttons at the top, 1 that refreshes the notion databases, one that archives the notion data and writes the clean monthly data over, and one that I WANT to make overwrite the original databases in Notion with the clean monthly data. Everything is working as intended except that last part…SO CLOSE.
Now the hard part… I can’t for the life of me get Coda to write that data back to the original Notion DBs, NOR CAN I JUST COPY/PASTE THE DATA IN. That last part is pretty inconvenient as I really wouldn’t mind that workaround. But anyways, I’ve been pointed in the direction of Make.com and Zapier, then heard about Notion’s APIs, but I am just struggling to get this Coda table to overwrite my Notion DB. Does anyone have suggestions or a solution that would work? I’m sure y’all would do this some other way but I’ve gotten this far and I’d really like to get this thing to work the way I want it to. Let me know what you suggest, hopefully you didn’t mind the word vomit!
