This video shows how to update Google Sheets with JSON API. The video is based on this blog post.
I live in Contra Costa County in the San Francisco Bay Area. The county has setup a web site with Covid-19 information for its residents. The main page shows key Covid-19 data updated daily. I have been visiting this page almost daily. This is how it looks for Friday, June 19, 2020:
I wanted to build an application that would email me this data every day. To continue my no-code journey I built a no-code application that sends me a daily email with the latest data. I didn’t need to write a single line of code!
These are the tools I used to build the application:
- Simplescraper – to scrap data from the county web site and turn it into an API
- Parabola – build a flow to invoke the API and send the email
This is how the application flow looks in Parabola:
Let’s review the application flow.Continue reading “Building a no-code app to send daily Covid-19 data”
In this blog post I will give you an overview of how I built a no-code application that sends an email and a text message when a new users registers. This is part of me taking an application built with code and building it with no-code tools.
I previously shared how to build a no-code application to send positive news.
I used Parabola to build this application. This is how the application flow looks:Continue reading “Building a no-code application that sends an email and a text message when a new user registers”
Google Sheets is a well-known service and online spreadsheet. Google Sheets can be more than just a spreadsheet, it can be used as a back-end or a database for applications. For example, Glide uses Google Sheets as a database for its mobile applications. Glide allows to build a mobile application without any code connected to Google Sheets. It’s incredible how fast you can build a real app, .
I was building an app in Glide that displays the latest news using News API. I connected the app to a Google Sheets spreadsheet where I entered a number of news stories manually. The app looks like this:
This is how the Google Sheets spreadsheets looks:
If I need to update any news I can manually edit the Google Sheets spreadsheets and the Glide app will be updated.
This manual update is not ideal of course.Continue reading “How to update Google Sheets with JSON API”
Earlier I published two blogs posts where I share my experience building a no-code application that texts positive COVID-19 news:
- Parabola, Watson NLU, News API and Twilio – tools I used to build a nocode application
- Tutorial: building a no-code application to text positive news with Parabola, News API, Watson NLU and Twilio
I also recorded a video that shows how I built the application:
Hope you will find it useful. Let me know if you have any question.
I wanted to take an app build with code and rebuild it using no-code tools. Gwyneth Peña built a wonderful app that sends a daily positive news article about COVID-19 via a text message so I decided to build this app using no-code tools. I shared a high-level overview of the app in an earlier blog post.
In this blog post I will share a more step-by-step how I built the app. You should be able to follow the steps and build it as well.
Tools you need
You will need the following tools to build the application. All four services offer a free plan.
- Parabola – no-code platform
- News API – news service
- Watson NLU – sentiment service
- Twilio – SMS service
Parabola is a no-code tool where I built the app. Parabola is a drag-and-drop workflow builder. You build a flow with multiple steps (nodes) and connections between steps. Each step has input and output. Output from one step is passed as input to the next step. You can also look at it as a serverless application – where each step represents a serverless function. But, instead of writing code, each step is dropped onto the flow and configuring. This is how the application flow looks:
Register for a free Parabola account.
One thing I wanted to try is re-build an app built with code using no-code tools.
Gwyneth Peña built a wonderful app that sends a daily positive news article about COVID-19 via a text message:
I thought this is a great app I should try to build using no-code tools.Continue reading “Parabola, Watson NLU, News API and Twilio – tools I used to build a nocode application”
I shared earlier how no-code can help build solutions faster and allow a lot more people to participate in building solutions. I shared how the community stepped up to help fight COVID-19 by building various applications with no-code. For example, one such application is to allow restaurant owners to build an online menu for delivery or takeout:
The value of no-code is easy to understand:
- Build solutions faster
- Allow a lot more people to build solutions
A few days after I published my blog post, CNBC published a great article on demonstrating the two points above: Next frontier in Microsoft, Google, Amazon cloud battle is over a world without code. I want to share a few quotes from the article.
[NYC] created a COVID-19 crisis-management software platform in a matter of days, and without writing one line of computer code. Time is of the essence.CNBC (https://t.co/Y1MCdQY4dj)
NYC used a no-code solution from Unqork to build this application in 48 to 72 hours. I think the time it took to build this solution is incredible. For many applications there is no need to focus on frameworks, libraries, integrations and servers. No-code allows to focus on a problem and building a solution.
Microsoft expects 500 million new apps to be built in the next half decade, which is more than all the apps built in the last 40 yearsCNBC (https://t.co/Y1MCdQY4dj)
If this number is true, then this is an unprecedented demand for new software solutions. Today there are about 24-25 million developers. It’s impossible to meed this demand with this number of developers using traditional coding tools. No-code allows a lot more people to build software solutions. No-code democratizes software development. Imagine if we enabled millions more people to build solutions. These people will come with solutions, ideas, inventions that we were not possible or imaginable before. Imagine what solutions first reponders could build to help fight COVID-19?
The value of no-code is clear: build faster and allow a lot more people to build.
In November 2019 I attended No Code Conf in San Francisco. The main theme of the conference was that there are millions of people who want to create and build solutions but they don’t know how to code. No-code will allow these folks to build applications without code.
No-code will democratize software development.
Today there about 24-25 millions developers in the world which means only about 0.3% of people today know how to create software, invent new things.
Imagine if millions more people, who are not coders, could create and build software, invent new things. We would have awesome new services, products and markets that we probably don’t even imagine today.
Innovation would accelerate.Continue reading “No-code, Coronavirus, Call for Code 2020, innovation”