>
>
Create A COVID Tracker Bot With Zapier

Create A COVID Tracker Bot With Zapier

Updated:
May 11, 2021
By:
Ravinder Deol
No-Code Cheat Sheet

Join 3,071 People Building Products Without Code

Unsure which no-code tool to use? Drop your email below, and get our FREE no-code cheat sheet. It lists 100's of no-code resources you can start building with.

You're in! Check your inbox for an email.
Something went wrong. Please try again.
We hate spam too. Unsubscribe with one click.

Table Of Contents

1. API Setup

2. Renaming Columns

3. Numerical Formatting

4. Export To Google Sheets

5. Publishing

6. Connect Zapier

Project Resources

COVID19 API

Parabola

Google Sheets

• 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.

No-Code Cheat Sheet

Join 3,071 People Building Products Without Code

Unsure which no-code tool to use? Drop your email below, and get our FREE no-code cheat sheet. It lists 100's of no-code resources you can start building with.

You're in! Check your inbox for an email.
Something went wrong. Please try again.
We hate spam too. Unsubscribe with one click.