Re: Google Finance stock quotes input/API for Airtable

3431 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

For a variety of investors and traders, it would be useful to have AirTable import current stock prices.

Google Finance offers this simple functionality within Google Sheets with this format: "=googlefinance(stocksymbol, “price”).

If there is a way to achieve this function in AirTable by linking to Google (or perhaps Yahoo), please share your thoughts.

16 Replies 16
6 - Interface Innovator
6 - Interface Innovator

Hey @Jay_Lee can you DM me your script’s URL? Happy to help debug.


Has there been any update regarding ready integration to pull stock data?
While I am currently using zapier to integrate with Google Sheets, it would help if a ready integration is available from Airtable itself. Thank you.

4 - Data Explorer
4 - Data Explorer

You can access a bunch of financial data through Google Sheets offered by Intrinio. They also have tutorials that take you through how to use it. Hope this helps!

5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,

I’ve installed Blockspring and the extension loads and is listed as “injected” when inspecting the page code but there seem to be jquery errors. Any thoughts on what to do next?




5 - Automation Enthusiast
5 - Automation Enthusiast

Encountered the same issue.

It looks like the Blockspring servers are very unreliable and have frequent connection issues. It takes the “team” weeks, if not months, to get the servers back online. It’s a free service, and is ran by a single person (correct me if I’m wrong), what did you expect?

My suggestion is to search for other solutions (I was not able to find one) or wait for the AT team to implement the feature.

All the best.

4 - Data Explorer
4 - Data Explorer

This is the main reason I am thinking about switching from AirTable to Google sheets.

6 - Interface Innovator
6 - Interface Innovator

I made a tool that can import stock prices into Airtable in bulk. Given a column of stock symbols, it will fetch the latest prices and add them to Airtable. It can be scheduled to run regularly, or use a webhook.