October 4, 2021
16 Minutes

Create A COVID Tracker Bot With Zapier

By the end of this tutorial, you will have created an automated COVID19 tracker. The COVID19 tracker will email the figures of COVID daily.

Project Resources



Google Sheets

• Zapier

Table Of Contents

1. API Setup

2. Renaming Columns

3. Numerical Formatting

4. Export To Google Sheets

5. Publishing

6. Connect Zapier

1. API Setup

Sign up for an account on Parabola.

Log into Parabola and click 'Add A New Flow'. Title your flow, 'COVID19 Tracker'.

Place the 'Pull From An API' function onto your canvas.

Open the function and set the 'Request Type' to 'GET'. Then, confirm the 'API Endpoint URL' in COVID19 API's documentation.

Select the API for 'Word Total WIP' (or whichever endpoint you wish). Copy and paste the endpoint URL into Parabola (below):

  • https://api.covid19api.com/world/total

Click 'Show Updated Results'. You should now have access to the API.

2. Renaming Columns

Place the 'Rename Columns' function onto your canvas.

Open the function and rename the columns as follows:

  • TotalConfirmed - 'Total Confirmed'

  • TotalDeaths - 'Total Deaths'

Click 'Show Updated Results'.

3. Numerical Formatting

Place the 'Format Numbers' function onto your canvas.

Open the function and format every column as follows:

  • Numbers

  • With Comma Grouping

  • Showing 2 Decimal Places

  • Rounded To The Nearest Value

Click 'Show Updated Results'.

4. Export To Google Sheets

Place the 'Send To Google Sheets' function onto your canvas.

Open the function and authorise Parabola to post to your Google Sheet.

Click 'File' and 'Create A New File'. Title the sheet, 'COVID19 Tracker'.

Under the export rule, select 'Overwrite'.

Click 'Show Updated Results'.

5. Publishing

Click 'Publish' to get your Parabola flow live.

Click 'Add Rule' to the following scheduling rules for your flow:

  • Frequency - 'Once Per Day'

  • Days Of The Week - '7 Days Per Week'

  • Run Time - '09:00 AM'

  • Time Zone - 'Europe/London'

Click, 'Save Rule. Then, 'Run Flow Now'.

Your flow will now go live. It will query the API, rename columns, numerically format your data, and export it to Google Sheets.

6. Connect Zapier

Sign up for an account on Zapier.

Log into Zapier and click 'Make A Zap'.

Connect Google Sheets. And set the trigger event to 'New Or Updated Row'.

Click, continue. (You may need to authorise your Google account.)

Select your Google Sheet (and worksheet) titled 'COVID19 Tracker'.

Again, click continue.

Click 'Test Trigger'. Confirm if the automation can access your data.

Then, click continue.

Connect Email By Zapier. And set the trigger event to 'Send Outbound Email.'

Again, click continue.

Customise the outbound email as follows:

  • To - (Use Your Email Address)

  • Subject - 'COVID Figures'

  • Body - 'Hello! Here are today's COVID figures. Total Confirmed: {Insert Total Confirmed Figure}. Total Deaths: {Insert Total Deaths Figure}. Total Recovered: {Insert Total Recovered Figure}. I'll send you another update tomorrow. Stay safe. (Your Name).'

  • Attachment - (No Attachment)

  • From Name - 'COVID Updates'

You can leave the remaining fields as default.

Then, click continue.

Click, 'Test And Review'. Check if the email got sent to your email address.

Return to Zapier, and click 'Turn On Zap'.

Rename your Zap to 'COVID19 Tracker'.

You will now receive daily emails on COVID19 figures automatically.

Join over a thousand readers and get my short and insightful biweekly email. I share seven notable highlights from my latest book summary in the email.