Monitor the availability of Covid-19 Vaccines in your city and get email alerts when vaccine doses are available for people above 18 years of age.
India is currently in the midst of a second wave of the Coronavirus and this one is far more devastating than what we have seen last year. The country is reporting close to 400,000+ new cases every day but the actual count of daily infections could be much higher.
The COVID-19 vaccination program in India was earlier available to people above 45 years of age but starting May 1st, anyone above the age of 18 years can get vaccinated. That said, vaccine availability remains an issue countrywide and it is cumbersome to manually check slots every few hours.
The government’s official website - cowin.gov.in - has a useful search section that allows you see the nearby vaccination centers in your city or zip code. You’ll also know how many vaccine doses are available at a specific center and the earliest date when the vaccine slots are likely to open up.
Based on the public CoWIN API, I have developed an open-source vaccine tracker that will automatically monitor the vaccine availability near you and will send email alerts as stocks become available. The source code of the project is available on Github.
Step 1: To get started, click here to make a copy of the Vaccine Tracker Google Sheet in your Google Drive. You should complete this step on a desktop computer as Google add-ons are not available on mobile apps yet.
Step 2: Click the Vaccine Tracker menu (near the Help menu) and choose Enable as shown in the screenshot.
Step 3: You may see an authorization window. If you get an “unverified app” message, click the Advanced link and choose “Go to Vaccine Alerts”. The app is 100% safe and open-source.
Step 4: Go to Step 2 now and choose the
Enable menu again to launch the tracker. Enter one more pin codes (comma separated), the email address where you wish to receive the alerts and the age group for which you need to monitor vaccine availability.
The vaccine availability is checked every day but you can change the frequency to every 4 hours or every hour.
Create Email Alert button and your system is up and running. Google Sheets will run this monitor every day and send an email at 8 am indicating the availability of vaccines in your specified areas.
Here’s a copy of the email sent by the vaccine tracker.
And if you ever wish to stop Google Sheets from tracking vaccine availability, go to the same sheet and choose
Disable from the menu.