Live Stock Prices in Notion (Google Apps Script)
Hello, I'm Taylor. I wanted to use Notion as a database for my stock transactions, but quickly realized that being able to update live prices of those stocks in Notion was a huge pain in the butt. After trying out a few templates and procedures, I tried to do better:
What It Does
With some simple, no-code setup, you can connect this script to any Notion database, and have it read stocks from a database and update the stock's price on a time-based schedule (ie. hourly).
Manage your stocks in a Notion database, and let the script keep a Price column up to date
The Sheets template includes a simple, no-code interface to enter your Notion configuration details
Simple Setup
- Create a copy of the Google Sheet link that will be sent to you on purchase
- Create a private Notion integration, and paste a few fields into the Sheet's Setup tab
- Test run the script, and then set up a time-based trigger so that it runs automatically (ie. hourly)
Here's the full User Guide for this script, with step-by-step instructions for setting it up with your Notion database.
Setup should take less than 10 minutes.
Notable Details
- This solution relies on the Google Sheets function
=GOOGLEFINANCE()
which, according to their docs, may mean prices are delayed by up to 20 minutes - While this is a fully no-code solution, there are some configuration steps required. Here is the User Guide that steps through these, so that you can review them before purchasing.
If you experience any issues or have any questions, I'm more than happy to help. Shoot me an email at taylor@hubbub.dev