Rapidly collect proofs of Vaccinations on Google Sheets using ClickSend + Zapier (for FREE)

1) Setup

a. ClickSend setup

  1. Create Account. Clicksend allows you to use the number with some balance for a limited amount of time. If you need more then you purchase credits
  2. Create a new MMS number by Click on Numbers >> MMS (https://dashboard.clicksend.com/numbers/mms)

b. Zapier setup

  1. Create an Account in Zapier. Zapier lets you run a Zap 1000 times as part of its free tier.
  2. Create a Zap

c. Google Sheet Setup

  1. Create a new Google Sheet of a name of your choice. Free by default.
  2. Create 3 column “From”, “Message”, “Date”

2) Link

a. In Zapier → Setup ClickSend

Follow the images

a) Choose ClickSend App ; b) Link ClickSend Account ; c) Test Trigger

b. In Zapier → Link Click Send to Google Sheets

Follow the images
Make sure to MAP Clicksend’s fields to Google Sheet’s columns as follows:

  • Clicksend’s “From” → GSheet’s “From”that we created earlier
  • Clicksend’s “Body” → GSheet’s “Message”
  • Clicksend’s “TimeStamp” → GSheet’s Col. “Date”
a) Choose Google Sheets App ; b) Link Google Sheets Account ; c) Setup Action (Map fields) d) Test Trigger

3) Receive Proofs of Vaccine in Google Sheets

Try sending a message from your phone to the ClickSend number that was purchased in Step 1a. The Google Sheet you setup in 1c. should receive the message like below. Clicksend generates a link to Amazon S3 file for all incoming MMS images.

Lastly, you may convert the Date (originally in UNIX Timestamp format) to a more human readable format. I used the following formula to convert to EST timezone.

=(C2/86400+date(1970,1,1))-(5/24)
https://clicksend-api-downloads.s3.ap-southeast-2.amazonaws.com/_private/32F59E65-2DAD-4AC9-B08E-82B716F5E61F.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAWKMIV4OKLNEYMPU5%2F20211220%2Fap-southeast-2%2Fs3%2Faws4_request&X-Amz-Date=20211220T120329Z&X-Amz-SignedHeaders=host&X-Amz-Expires=600000&X-Amz-Signature=1b29b897947c15fdb193399d1efd4e11fec79caa808a6872ee60d3bdc73562cd

--

--

--

this shrub thing

Recommended from Medium

NEW COVID-19 DEVELOPMENT

Should You Be Worried About the New COVID Strains? (Video and Podcast)

PDF Download@ Contracts (Law in a Flash) Read ^book &ePub

[PDF] Download Solo: A Modern Cookbook for a Party of One *Epub* by :Anita Lo

The Government Should Be Beneath Our Feet, Not On Our Faces

What to decide for my 2nd dose, AstraZeneca or Pfizer/Moderna?

The epidemic is a shitstorm — I don’t need the daily news to know it’s there

October 3rd // Starting today, masks must be worn at all times, even out on the streets of Rome.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Varun Adibhatla

Varun Adibhatla

this shrub thing

More from Medium

Building a Bank Roll on Draftkings

Shaip offers a 50% discount on its off-the-shelf Audio/Speech datasets to train Conversational AI…

about nodez

Safety in Cardiac Rehab — A Primer