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