Video: How to build a no-code application to scrape and email data from a web site

In this video you will learn how to build a no-code application that scrapes data from a web site and then emails the data. The data scraped is also saved into a Google Sheets document.

This particular example shows how to get a daily Covid-19 data from a county web site. The same approach can be applied to any other web site and data.

Watch other videos from my no-code YouTube playlist.

Video: How to build a Twitter bot in 10 minutes

This videos shows how to build a Twitter bot with Zapier in under 10 minutes. The video is based on How I built a Twitter bot with no-code in 10 minutes blog post.

Check it out and let me know what you think. This is part of my journey to take an application built with code and build it with no-code tools. If you know any solutions built with code that I should try to build with no-code – let me know! You can also check out other no-code videos I have published.

How I built a Twitter bot with no-code in 10 minutes

Earlier this year I shared:

I published the following blog posts where I show how to take an application built with code and rebuild it with no-code:

Continue reading “How I built a Twitter bot with no-code in 10 minutes”

Video: How to update Google Sheets with JSON API

This video shows how to update Google Sheets with JSON API. The video is based on this blog post.

Video: Building a no-code application that sends an email and a text message when a new user registers

This 12-minute video shows how I built a no-code application that sends an email and a text message when a new user registers. I used the following no-code tools: Airtable, Parabola and Twilio. The video is based on this blog post.

Building a no-code app to send daily Covid-19 data

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:

Covid-19 data for 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:

Parabola flow

Let’s review the application flow.

Continue reading “Building a no-code app to send daily Covid-19 data”

Building a no-code application that sends an email and a text message when a new user registers

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.

This particular application is based on Upkar Lidder’s application built with Apache OpenWhisk. The application registers a user and sends a notification via email and text.

I used Parabola to build this application. This is how the application flow looks:

Parabola application flow
Continue reading “Building a no-code application that sends an email and a text message when a new user registers”

How to update Google Sheets with JSON API

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:

Glide app

This is how the Google Sheets spreadsheets looks:

Data for Glide app in Google Sheets

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”

Video: Building a no-code application to text positive news with Parabola, News API, Watson NLU and Twilio

Earlier I published two blogs posts where I share my experience building a no-code application that texts positive COVID-19 news:

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.

Tutorial: building a no-code application to text positive news with Parabola, News API, Watson NLU and Twilio

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.

  1. Parabola – no-code platform
  2. News API – news service
  3. Watson NLU – sentiment service
  4. Twilio – SMS service

Parabola

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:

Application flow in Parabola

Register for a free Parabola account.

Continue reading “Tutorial: building a no-code application to text positive news with Parabola, News API, Watson NLU and Twilio”