Spreadsimple provides a speedy and easy way to manage and create websites using Google Sheets using no code. Leveraging the power of Google Sheets, you have all the possibilities that the online suite offers at the tip of your fingers. Simple & without any Coding Experience.
In this article, we will look at Spreadsimple, why it is excellent, and how we used it to build Colorless Crypto - a Public, Dynamic Crypto Portfolio Website in no time.
Spreadsimple provides a speedy and easy way to manage and create websites using Google Sheets. Leveraging the power of Google Sheets, you have all the possibilities that the online suite offers at the tip of your fingers. You can manage all of your inventory, prices, and orders in one place. Many Native Google Sheet features are supported, such as formulas and expressions, collaborative edits, chats, and many more.
When compared to its alternatives, SpreadSimple makes it easier to create and manage content. Set it up within minutes & you are good to go with a Professional-Looking Website. Content is synced in close to real-time, publish an update in a new Google Sheets row or edit an existing one and the updates are instantly pushed into the frontend of SpreadSimple. A simple way to use Google Sheets as a Content Management System (CMS).
Everyone can do it. SpreadSimple is a popular no-code solution for simple Landing Pages, Online Shops, Affiliate Stores, Real Estate, Restaurants & many more Online Businesses.
Increase your store conversions by allowing your customers to place orders on WhatsApp. Using this add-on you will allow your customers to start the instant conversation with you right upon order placement.
Memberstack lets you build members-only websites by setting membership plans, pricing and permissions for your existing website.
External Checkout Action
This add-on allows you to send order form data to an external resource.
Google Analytics lets you measure your advertising ROI as well as track your video, and social networking sites and applications.
Google Tag Manager
GTM was designed to help manage the lifecycle of e-marketing tags (sometimes referred to as tracking pixels or web beacons), which are used to integrate third-party software into digital properties such as websites and web applications.
Hotjar is a behaviour analytics tool that analyses website use, providing feedback through tools such as heatmaps, session recordings, and surveys.
The Facebook pixel is a code that collects data that helps you track conversions from Facebook ads, optimize ads, build targeted audiences for future ads, and remarket to people who have already taken some kind of action on your website.
A cookie banner (popup) is a block which pops up on top of your website and warns your site visitors of the cookies usage.
Building a Public, Dynamic Crypto Portfolio Website with SpreadSimple
In this article, we will take a deep dive into SpreadSimple & how we can utilize this piece of Software to Build a Public, Dynamic, Crypto Portfolio Tracking Website for our Crypto Signals.
To achieve this, we will use SpreadSimple to display the Information about our CryptoCurrency Calls while Google Sheets resembles the backbone of our little application.
There are multiple ways to get Live Crypto Prices into your Google Sheets. In this article, although we will focus on two ways to get near to real-time, Cryptocurrency Information into our Sheets via =IMPORTDATA & =IMPORTXML.
A little bit of Background
One of my first memories about Bitcoin, The Blockchain & its existence, dates back to around 2010/2011, when one of my buddies & I had a conversation in Highschool trying to figure out how Bitcoin worked, what made it special, trying to grasp anything that we could understand about The Blockchain.
Bitcoin was very new at that time. Knowing nobody but my buddy who heard about this mysterious currency and its technology, the ball got rolling, and I found a new interest in the so-called crypto-verse.
Skipping through a few years in Highschool, earning a few Bitcoin with my Designing Service »real quick«, but also equally spending my first Bitcoin »real quick«, on dumb stuff like Games, pranking my friends with Spoofcard.com, or some other “fun” stuff at that time. Awfully paying with Bitcoin, of course.
I always kept an eye out on the Crypto-sphere and am glad that I did so. That so-called “Bitcoin Scam” or “Bitcoin Bubble” that should have burst at least a bazillion times in the past is now more present than ever, challenging the current state of our Financial System once again. want more? bitcoinisdead.org
Fast forward a couple of years, I have been investing pretty consistently into the space, building a small but growing Portfolio. Ever since Bitcoin, Ethereum & the altcoins took off in 2017, countless peers started reaching out to me asking for advice because I was that kid who told them about Bitcoin in high school. I will skip the stories about friends who ended up investing, first losing 50% of their stake because they panicked, then ultimately going mental when they realized they sold their asset at -50% when it’s up 100x to this point in time. As a result, I stopped talking to anyone about crypto besides fundamentals & technology.
I have been tracking my investments ever since but have never really talked about what assets I invested in and why, so I decided to create a Public, Crypto Portfolio Website with Google Spreadsheets + Spreadsimple. Using this platform, I can share my Investments with my Friends & Family without directly advising them in any way. (this is not financial advice btw :,-) I am just making them aware of specific Crypto-Related Projects I invest in.
Populate & Link all the Necessary Content to be displayed on the frontend.
Pulling Live Crypto Prices in Google Sheets
Method 1: =IMPORTDATA (Restricted Datapoints)
Use a service like Cryptoprices.cc to fetch Crypto Prices in Google Sheets:
Use =IMPORTDATA via Cryptoprices.cc
To fetch Live Crypto Prices in Google Sheets, go to Cryptoprices.cc and choose a cryptocurrency you want to fetch the price for. In this example, we are going to use Ethereum.
To fetch the price for Ethereum in this case, we would choose the =IMPORTDATA Google Sheets function to load a .csv from a URL and display it in the corresponding Google Sheets cell.
Fetch Ethereum Price:
Fetch Ethereum All-Time High Price:
The Google Sheets Cell should look something like this:
To learn more about Cryptoprices & available Cryptocurrencies visit the Official Website.
Method 2: =IMPORTXML (More Datapoints)
Use XPath to Parse Crypto Prices directly into a Google Sheets Cell:
Use =IMPORTXML & XPath to Parse Crypto Prices from Droptab.com
Use XPath to Parse Crypto Prices directly into a Google Sheets Cell
To fetch crypto prices into Google Sheets via =IMPORTXML we will use Droptab.com as a Source of Data and choose a Cryptocurrency that we want to fetch the Information for. In this example, we are going to use Ethereum.
You can use almost any Website to do this. You could use Coinmarketcap.com as an alternative.
To get the price for Ethereum in this case, we would choose the =IMPORTXML Google Sheets function to Parse data from a URL and display it in the corresponding Google Sheets cell.
Check out this XPath tutorial if you have never heard anything about XPath before. Since XPath can be pretty confusing by nature, we will make use of a SelectorsHubXPath Chrome Extension that will make our lives a lot easier.
To continue, download, install & activate the SelectorsHub – XPath Plugin and continue to the Website you want to fetch data from; in this case, we will use dropstab.com/ethereum.
After navigating to our Data Source Website, highlight it, right-click on the “Data” – in this case, the Ethereum Price & select SelectorsHub –> Copy ABS XPath.
After copying the ABS XPath of your selected Data Endpoint, simply replace “YOUR ABS XPATH” in the code example below.
Meet Noel - a designer, developer, and crypto enthusiast who blogs about various topics, including design, development, workflow optimization, cryptocurrencies, building services and many other exciting subjects.
As the founder of Colorless Identity, he is always on the lookout for the next upcoming technologies. His deep understanding of the latest, cutting-edge technologies is what you need to accomplish your business goals faster.