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.

Updated:
June 9, 2021
|
Length:
16 Minutes
Join 1,000+ readers and get my bi-weekly newsletter. I share work that I've shipped and work that has piqued my curiosity. You'll also get access to all of my resources.
You're in! Check your inbox :)
There's an issue. Try Again :)

Project Resources

COVID19 API

Parabola

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):

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:

Click 'Show Updated Results'.

3. Numerical Formatting

Place the 'Format Numbers' function onto your canvas.

Open the function and format every column as follows:

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:

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:

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 1,000+ readers and get my bi-weekly newsletter. I share work that I've shipped and work that has piqued my curiosity. You'll also get access to all of my resources.
You're in! Check your inbox :)
There's an issue. Try again :)